Share this Page URL

Chapter 2. The Basics of Database Design > Planning and Designing the HelloWorl... - Pg. 52

The Basics of Database Design Create a junction table 1. 2. 52 In the Database window, click Tables in the Objects list, and then double-click Create Table In Design View. In the Table Design window, enter two fields, as follows: Field Name CampaignID LanguageID Data Type Number Number Description Campaign identifier Language identifier 3. Click the row selector to the left of CampaignID, and drag down to select both fields. On the toolbar, click the Primary Key button. The Table Design window should now look like this: