Share this Page URL

Chapter 2. The Basics of Database Design > Using the Table Wizard to Create the... - Pg. 61

The Basics of Database Design 6. 61 In the screen shown here, keep ExpenseID selected as the field to use as the primary key. Keep the option to have Access automatically number records selected, and then click Next. 7. In this screen, which lets you create a relationship for the CampaignExpenses table, select Related To MarketingCampaigns, and then click Next. 8. In the wizard's last screen, select Modify The Table Design, and then click Finish. You can see how the wizard put the table together, choosing data types for each field. The wizard has also filled in some of the field properties. For example, click in the ExpenseType field, and you can see that the wizard entered Expense Type in the Caption property for this field.