Creating Databases and Tables Manually 801
The renamed fields.Tip Again, don’t worry if your screen doesn’t look exactly like this graphic, because
we’ve made adjustments so that you can see all the fields.- Add another record containing the following field values to the table, pressing Tab
to move from field to field:
FirstName John City Montreal Country Canada
LastName Frederickson State Quebec Phone 514 555-0167
Street 43 rue St. Laurent ZIP (press Tab to skip this field) - At the right end of the tab bar, click the Close button.
- When Access asks whether you want to save the design of the table, click Yes.
Important Clicking No will delete the new table and its data from the database.
Access displays the Save As dialog box.You must save the table before closing it.- In the Table Name box, type Customers, and then click OK.
Access closes the table, which is now listed in the Tables group on the Navigation bar.The database now contains one table.