• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Managing a Database > Analyzing a Database

Analyzing a Database

From time to time, you should analyze your database to ensure that it works as efficiently as possible. Begin by running the Performance Analyzer, which provides ways to organize your database optimally and helps you make any necessary adjustments. Whenever you determine that several fields in a table store duplicate information, run the Table Analyzer to help you split the data into related tables (a process called normalization), but leave the original table intact.

Optimize Database Performance

Open the database you want to analyze.

Click the Tools menu, point to Analyze, and then click Performance.

Click the All Object Types tab.

Select the check boxes for the objects whose performance you want to analyze.

Click OK.

If the Performance Analyzer has suggestions for improving the selected object(s), it displays them in its analysis results.

Click each item, and then review its analysis notes.

Press and hold Ctrl, and then click the suggested optimizations you want Access to perform.

Click Optimize.

Click Close.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint