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.
.jpg)
Very useful
ReplyDelete