Creating Databases and Tables Manually 803
- On the Create tab, in the Tables group, click the Table button.
Access creates a new table containing an ID field and a Click To Add field
placeholder.- With the Click to Add field active, on the Fields contextual tab, in the Add &
Delete group, click the More Fields button.
The More Fields gallery appears.
The Quick Start fields are at the bottom of the More Fields gallery.- If necessary scroll to the bottom of the gallery, and then under Quick Start,
click Name.
Access inserts ready-made LastName and FirstName fields. - Repeat steps 18 and 19 to add the Address fields from the Quick Start list.
Access inserts ready-made Address, City, State Province, ZIP Postal, and Country
Region fields.- Close the table, saving it with the name Shippers when prompted.
CLEAN UP Retain the MyTables database for use in later exercises.