Fine-Tuning with the Performance Analyzer Wizard
Even the most experienced database designers (including me) don’t always take advantage of all the techniques available to improve performance in an Access application. Fortunately, Access provides a Performance Analyzer Wizard to help you do a final analysis after you build most of your application. In this section, we’ll let the wizard analyze the Housing Reservations sample database (Housing.mdb). To start the wizard, switch to the Database window, choose Analyze from the Tools menu, and then choose Performance from the submenu. Access opens the window shown in Figure 24-16.
Figure 24-16. The main ...
Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
