4. If prompted, enter the user name and password for your Outlook account. 5. In the Import Exchange/Outlook Wizard, do the following: a. Select the folder you want to import, and then click Next. b. Make changes to the field names or data types Access assigns to the folder’s contents, set the Indexed property for a field, or specify to skip a field. Then click Next. c. Choose an option to have Access set a primary key, select your own key, or set no primary key. Then click Next. d. Change the name of the table if you want to, and then click Finish. 6. In the Get External Data dialog box, do the following: a. If you want to save the steps of the operation for reuse, select the Save import steps check box and provide a name and optional description for the steps. b. Click Close. To open the Relationships window ➜ On the Database Tools tab, in the Relationships group, click Relationships. To display tables in the Relationships window 1. On the Design tool tab, in the Relationships group, click Show Table. 2. In the Show Table dialog box, select the tables, and then click Add. Tip Hold down the Ctrl key to select multiple items. To remove tables from the Relationships window ➜ In the Relationships window, do either of the following: ● To remove one table, click the table to select it. Then on the Design tool tab, in the Relationships group, click Hide Table. ● To remove all tables, on the Design tool tab, in the Tools group, click Clear Layout. To display relationships in the Relationships window ➜ In the Relationships window, do either of the following: ● To display all direct relationships of a specific table, click the table to select it. Then on the Design tool tab, in the Relationships group, click Direct Relationships.
● To display all relationships in the database, on the Design tool tab, in the Relationships group, click All Relationships. To view object dependencies 1. In the Navigation Pane, select the database object whose dependencies you want to view. 2. On the Database Tools tab, in the Relationships group, click Object Dependencies. 3. In the message box informing you that Access needs to update dependency information, click OK. 4. In the Object Dependencies pane, click Objects that depend on me or Objects that I depend on. To create a table relationship 1. Open the Relationships window. If the tables you want to create relationships between aren’t displayed in the Relationships window, add them. 2. Drag the linking field from the first table (the “one” table in a one-to-many relationship) to the second table (the “many” table). 3. In the Edit Relationships dialog box that opens, do the following: a. Ensure that the linking fields are selected in the Table/Query and Related Table/Query lists. b. If you want to enforce referential integrity for this relationship, select the Enforce Referential Integrity check box. c. If you enforce referential integrity, you can also do one or both of the following: ۵ If you want Access to update related fields when you change the primary record, select the Cascade Update Related Fields check box.
You've reached the end of your free preview.
Want to read all 11 pages?
- Spring '18
- Donald Batkoski
- Dialog box, Navigation pane