Computer Frequently Asked Questions (FAQ) -- Access:  Tips and Tricks

Recycle Access Tables
 

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.

The new table inherits all the field properties from the original table. You can then alter field names and properties as appropriate.

 

Set Up Your Access Database to Automatically Compact and Repair

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.
   

< Back to Oregon Intranet