Access tutorial 19.2 analyze database performance

We analyzed the table just now. We can see that there are two options, performance and Document Manager, under the menu analysis option. The two options are described below. Click the analysis item in the tool menu and select the performance command. Now we start to analyze the performance of the entire database. For ease of use, we often choose all

We analyzed the table just now. We can see that there are two options, performance and Document Manager, under the menu analysis option. The two options are described below. Click the analysis item in the tool menu and select the performance command. Now we start to analyze the performance of the entire database. For ease of use, we often choose all

TableProceedNowAnalysis, See on the menuAnalysis"Performance"And" Document Manager ", the two options are described below.

Click "Tools">"Analysis"Item, select"Performance"Command. Now we startDatabaseProceedPerformanceAnalysis. For ease of use, we often choose the "All object types" option,

Getting startedTutorial19.2 PairsDatabasePerformanceProceedAnalysis"/>

And click the "select all" button on this tab, although it will take us more timeProceedPerformanceAnalysisBut it is very worthwhile. Click "OK" on this tab. Now ACCESS isDatabaseProceedOptimizationAnalysis.

AnalysisThe result is displayed,

Getting startedTutorial19.2 PairsDatabasePerformanceProceedAnalysis"/>

Each item in the list has a symbol before it. Each symbol represents a meaning, which is described in this dialog box. If the list box contains "recommendation" and "suggestion ", we move the mouse over the "select all" button and click the left mouse button. Then, each option in the list box is selected.

After that, move the mouse over the button "optimization", click the left mouse button, and wait for a while, we will find that the original "recommendation" and "suggestion" items are changed to "correction" items, indicating that we have solved these problems.

Getting startedTutorial19.2 PairsDatabasePerformanceProceedAnalysis"/>

The "idea" item with the "bulb" symbol remains unchanged. When we select an "idea" option, we will find"AnalysisNote "will list in detail the ACCESS idea for solving this problem,

Getting startedTutorial19.2 PairsDatabasePerformanceProceedAnalysis"/>

You just need to remember these methods, click the "close" button, and then follow the prompts step by step.

The "Document Manager" option in this menu can print the createdDatabaseAll information about each object, move the mouse over this option, and click the left mouse button. A dialog box is displayed on the screen,

Getting startedTutorial19.2 PairsDatabasePerformanceProceedAnalysis"/>

In this dialog box, there are tabs. We select the "query" tab and select the desired object name in the corresponding list box. After the selection, click OK to display the content of these options. You can print the content as needed.

In this dialog box, there is an "option" button, which is used to determine the meaning of the printed table. Let's click this button and a dialog box will pop up,

Getting startedTutorial19.2 PairsDatabasePerformanceProceedAnalysis"/>

The dialog box contains three definition groups: "Table meaning", "field meaning", and "index meaning". If you select different options in the group, the printed table is changed, that is, the content of the information to be displayed. Click "OK" to complete these tasks.

With this information, experienced ACCESS users can print the informationAnalysisThe createdDatabaseWhat are the problems.