Access - Create Customers Database And Table Manually

1 Open MS Access.

2 Create a blank database.

3 Set a database name and location and click on create.

4 Click on the save icon in the top left corner.

5 Choose a name for your table and then click on OK.

6 With the right mouse button, click on the newly created table and select "Design View".

7 Now fill out following field names and choose appropriate data types:

1. ID
2. Customer_Number
3. First_Name
4. Last_Name
5. Full_Name
6. Username
7. Company_Name
8. Job_Title
9. Email
10. Phone
11. Country
12. Country_Code
13. City
14. Postal_Code
15. Gender
16. isActivated
17. Created_At
18. Updated_At

8 That's it. Save and go back to "Datasheet View".