Getting to Know Microsoft Access, Part 10 - Improving Performance
(Page 2 of 4 )
The two tools you need to know about to improve database performance are the table analyzer and the performance analyzer. Choose the Tools | Analyze menu options to get started using both of these tools.
The Table Analyzer is useful for reducing redundancy in your tables. The Table Analyzer will look at your tables and show you ways to split them apart. The Performance Analyzer, in contrast, looks at all the objects in the database and suggests ways to improve their performance generally.
Switchboards
A switchboard is a dialog box you create that works as a single point of entry into the application and gives the user a list of things they can do when they first open the application. This can be helpful for the user of the database who is not familiar with the object-model and just wants to do data entry or see a report.
To create a switchboard for your application, use the Switchboard Manager by selecting the Tools | Database Utilities | Switchboard Manager menu option. Select ‘Yes’ when prompted to create a new Switchboard. Next, add items to the switchboard. Do so by clicking the ‘New’ button in the Switchboard Manager.
In the New dialog box you’ll specify the label for the item, the action the items runs when selected by the user, and any command arguments (in the Switchboard field). To make the switchboard the startup page for the application, choose the Tools | Startup menu option and click the arrow next to the Display Form/Page box and choose the Switchboard option from the list.
Next: Exchanging Data with Others >>
More Microsoft Access Articles
More By Sage Adams
/ 16 
