Support

Online Support - Microsoft Access

Create a copy of a Microsoft Access table

Did you know you can create a copy of a Microsoft Access table without copying all the data it contains?

Here's how:

1. In the Database window under Objects, click Tables.
2. In the Object list on the right side of the Database window, click the table that has the structure or data you want to copy, and then click Copy on the toolbar.
3. Click Paste on the toolbar.
4. Click Structure Only under Paste Options.

Worried about the increasing size of your database?

To ensure optimal performance, you should compact and repair your Microsoft Access files regularly. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database. But don't stop there! Let Access do it for you automatically. How?

1. Open the Access database or Access project that you want Access to compact automatically.
2. On the Tools menu, click Options.
3. Click the General tab.
4. Select the Compact on Close check box.

Generating a graphical representation of table relationships

Proper design of tables and the relationships between them is critical to building a good database. Access 2002 helps you evaluate your design by generating a graphical representation of table relationships in your database.

1. On the Tools menu, click Relationships.
2. On the File menu, click Print Relationships. A report is generated that displays the relationships as they appear in the Relationships window.
3. Save or print the report, if desired, and then close the report window.

Close the Relationships window.