Hide Columns
There may be times when you may not want to display a certain column or set of columns. In such cases, you can temporarily hide the column or columns from view. Later, if you want to display them column again, you can unhide them.
To hide columns:
To create relationships:
1. Close all tables and forms. (Right-click on the tab of any Object. A menu appears. Click Close All.)
2. Activate the Database Tools tab.
3. Click the Relationships button in the Show/Hide group. The Relationships window appears.
4. If anything appears in the relationships window, click the Clear Layout button in the Tools group.
If you are prompted, click Yes.
5. Click the Show Table button in the Relationships group. The Show Table dialog box appears
6. Activate the Tables tab if your relationships will be based on tables, activate the Queries tab if your relationships will be based on queries, or activate the Both tab if your relationships will be based on both.
7. Double-click each table or query you want to use to build a relationship. The tables appear in the Relationships window.
8. Click the Close button to close the Show Table dialog box.
9. Drag the Primary table’s primary key over the related table’s foreign key. After you drag the primary key to the related table’s box, the cursor changes to an arrow. Make sure the arrow points to the foreign key. The Edit Relationships Dialog box appears.
10. Click the Enforce Referential Integrity checkbox.
11. Click Create. Access creates a one-to-many relationship between the tables.
12. Click the Save button on the Quick Access toolbar to save the relationship.
Post a Comment