How to analyze and optimize tables in an Access database

We open a database for analysis, and then click Analysis on the Tools menu, and the menu pops up with the table, performance, and document manager three commands. These three commands can be optimized for the appropriate content.

1, first of all to the table to optimize, click the "table" this command. Access begins to prepare the Table Analyzer Wizard, on the first page of the wizard, which provides us with a common problem when creating tables. This is the same information that is stored in the table or query more than once, and repeated information will cause a lot of problems for us. After reading these, we can click the Next button.

2. The second step tells us how this parser solves the problems encountered in the first step. The solution is to split the original table into several new tables so that the data in the new table is stored only once.

3, click "Next" button, in this step in the list box we select the table that needs to do analysis, here, although Access prompts you to select a table with duplicate information, but it is best to do an analysis of all the tables, so it will not take much time. Instead, you can make your work more standard.

Q: Then I set up a table to do a bit of optimization analysis.

A: It's a good habit. When you select the table you want to analyze, click the Next button, and in this step we choose Yes, let the wizard decide, so that access automatically completes the analysis of the table for us. By clicking the Next button, a dialog box pops up on the screen, which will tell us whether the table selected in the previous step needs to be split to achieve the goal of optimization. If you do not need to split, click the "Cancel" button, you can exit the Analysis wizard, the established table will not be optimized.

4, if the "Next" button is clicked, there is no pop-up such a dialog box AH. Instead, there was another window. This means that the tables you create need to be split in order to store the data reasonably. The Analysis wizard for access now splits your table into several tables and establishes a relationship between the tables. You just have to name each of these tables.

5, then you just move the mouse to a table field list box, double-click the list box title bar, then a dialog box will pop up on the screen, in this dialog box can enter the name of the table. When you are finished typing, click OK.