access-create-customers-database-and-table-manually

Access - Create Customers Database And Table Manually

This article shows how to create manually a simple MS Access Database and Datatable for customer's data.

Misc

  • 593
  • 435
  • 0
  • 0
Add to collection
© 2021VBAmacros.net

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".