When you create a new Microsoft Access database, you will be taken directly to the "Tables" view. Tables provide the foundation of Microsoft Access databases. They work a little but like Excel spreadsheets where you create fields for each type of data you want to use.
We will demonstrate the creation of a database using basic customer information Including name, address, phone number, customer number and membership date. To do this, we will use two tables: "customers" and "accounts."
1. Name your fields. The easiest way to create fields is in the "Datasheet" view that you have on your screen. Left-click the "Click to Add" tab and select "Text"
Your new field is labeled "Field1."
Place your cursor into the field and enter the real field name, "Lastname" and then press <Enter>. Repeat this process for Firstname," "Middle," Phone," "Address," "City," "State," and "Zip." For the last field, "Accountno," choose the "Number" option rather than "Text."
2. Richt click on the "Table1" tab and choose the "Save" option. Enter the name of your table (here we'll use "Customers") and then click "OK."
3. Next, we will create the "Accounts" table. This doesn't have to be fancy because this is just an example. To do this, click on the "Create" option on the main ribbon and select "Table."
4. Click the "Click to Add" header and select "Number." Replace "Field1" with "Accountno" to name the new field. Next, Click the "Click to Add" header and select "Date & Time." Replace "Field1" with "Membersince." Right click on the "Table1" tab and choose "Save." Name the table "Accounts" and click "OK."
The table portion of this tutorial for building Microsoft Access databases is now complete.
Continue on to page to so we can build a form and then enter data into our new database.
Image Credits: Screenshots taken by Bruce Tyson.