teaches you how to analyze the performance of an Access database

Analysis of the Access table, see the menu on the analysis of this option there are "performance" and "Document Manager" two options, the following talk about these two options, is a summary of some of the experience it .

1. First click the Analyze item in the Tools menu and select the Performance command. Now we're going to start profiling the entire database. For ease of use, we often select the "All Object Type" option, and click on the "Select All" button on this tab, which will allow us to spend more time profiling, but it is well worth it.

2, the analysis results come out.

Each item in the list is preceded by a symbol, each of which represents a meaning, which is described in this dialog box, and now if there are "recommendations" and "suggestions" in the list box, we will move the mouse over the "Select All" button and click the Left button, and each option in the list box is selected.

3, after completing these, move the mouse to the button "optimization", click the left mouse button, and so on, we will find that the original "recommendation" and "suggestion" items have become "corrections", indicating that we have solved these problems.

4. The "idea" item with "bulb" symbol does not change. When we select one of the "idea" options, we find that in the Analysis Notes in this dialog box, you'll see a detailed list of the ideas that access has made to solve the problem;

You just have to remember these methods, click the Close button, and then step through the way it prompts you to do it.

5, the "Document Manager" option in this menu can print out all the information of each object of the database, move the mouse to this option, click the left mouse button, the screen will pop a dialog box;

6, in this dialog box also has the tab, we select the "Query" tab, and then in the corresponding list box to select the desired object name, choose later, click the "OK" button to display the various contents of these options, you can print out the content if necessary.

7, in this dialog box has an "Options" button, which is used to determine the meaning of the printed table, let us click on this button, a dialog box will pop up;

8, in this dialog box contains the "Table meaning", "field meaning", "index meaning" of the three meaning group, select different options in the group, will change the printed table, that is, the content of the information will be displayed. When we are done with these tasks, click the "OK" button.

9. With this information, experienced access users can analyze the problems of the established database from the printed information.

E-Mentor Network provides you with more free database tutorial knowledge.

teaches you how to analyze the performance of an Access database