1. On the Database Tools tab, in the Relationships group, click Relationships.

2. If you haven't yet defined any relationships, the Show Table dialog box automatically appears. If it doesn't appear, on the Design tab, in the Relationships group, click Show Table.

3. Select one or more tables, and then click Add. After you have finished adding tables, click Close.

4. Drag a field (typically the primary key) from one table to the common field (the foreign key) in the other table. To drag multiple fields, press the Ctrl key, click each field, and then drag them.

5. Verify that the field names shown are the common fields for the relationship. If a field name is incorrect, click on the field name and select the appropriate field from the list.

6. To enforce referential integrity for this relationship, select the Enforce Referential Integrity box and click create.
   
   

7. When you are finished in the Relationships window, click Save to save your relationship layout changes.
   
   

A report is a database object that comes in handy when you want to present the information in your database for any of the following uses: Display or distribute a summary of data. Archive snapshots of the data. Provide details about individual records.

2. Click the table or query on which you want to base your report.
   

4. Click the Report button in the Reports group. Access creates your report and displays your report in Layout view. You can modify the report.

2. Double-click the first cell in the header row and type the name of the field in the sample table.

1. On the Create tab, in the Tables group, click Table.

3. Use the arrow keys to move to the next blank header cell and then type the second field name (you can also press TAB or double-click the new cell). Repeat this step until you enter all field names.