| |
Create Table and Fields
 Step 1
The first object you need to create in your Access database is a TABLE.
We will create a Customer table. You Customer Table will consist of rows of information (one row per customer).
fields will include custid, lastname, firstname, street, city, state, and zip.
Create Table and Fields
Step 2
Select the Tables Tab.
Click on the New button (Access 97) or Create Table in Design View (Access 2000).
Create Table and Fields
Step 3
The Table Design Dialog Box will appear.
Create Table and Fields
Step 4
Enter custid, select AutoNum from the dropdown list, type Customer Identifier in Description.
Tab to next line.
Create Table and Fields
Step 5
Enter the following field names, data types, and descriptions.
Field 2 = lastname, text, Last Name
Field 3 = firstname, text, First Name
Field 4 = street, text, Street Address
Field 5 = city, text, City
Field 6 = state, text, State
Field 7 = zip, text, Postal Code
Create Table and Fields
Step 6
Click on the gray box to the left of custid.
The custid field is selected.
Create Table and Fields
Step 7
Click on the Primary Key icon to make custid the Primary Key for the Customer table.
The Primary Key is the unique identifier for rows in a table.
Create Table and Fields
Step 8
To save the Customer table, click on File / Save As/Export... on the Access menu bar.
Create Table and Fields
Step 9
Name the table CustomerTable.
Click OK.
Create Table and Fields
Step 10
Close the New Table window by clicking on the close button in the upper-right corner.
The database window shows the CustomerTable in the Table Tab.
|