Share this Page URL

Chapter 4. Importing and Linking to Data > Importing Data - Pg. 121

Importing and Linking to Data 5. 6. 7. 8. 121 On the Tools menu, click Relationships. On the Relationships menu, click Show Table, and then add the new tables to the Relation- ships window. Close the Show Table dialog box. In the Relationships window, click the CampaignID field in the MarketingCampaigns table, and then drag it to the CampaignID field in the Tasks table. In the Edit Relationships dialog box, select Enforce Referential Integrity, and then click Create. The Relationships window should now look something like the following. (Remember that you can change the layout of the field lists in the Relationships window to see the relationships between tables more clearly.) 9. Close the Relationships window, saving the layout if you want to. Know the data you're importing As you've learned in this chapter so far, you need to know about the data you're importing to import it suc- cessfully. Here are some other tips to keep in mind when you're importing data: If you import a table that includes a lookup field, you should also import the table or query from which the lookup field gets its values. If you import forms from another database, you should also import the table or query that the form is based on. In general, be sure you import the tables that are required for any reports, forms, queries, or other objects you import. Just the Steps Import data from another Access database 1. 2. 3. 4. On the File menu, click Get External Data, Import. In the Import dialog box, select Microsoft Access from the Files Of Type list, and then select the Access database that contains the data you want to import. Click Import. In the Import Objects dialog box, select the database objects you want to import.