Access tutorial 19.1 analyze and optimize a table

Now you can perform basic operations, but sometimes the database is very slow to use because it was not optimized during database creation. Now let's talk about database optimization analysis. Open a database for analysis, and click the analysis option on the tool menu. the pop-up menu contains tables,

Now you can perform basic operations, but sometimes the database is very slow to use because it was not optimized during database creation. Now let's talk about database optimization analysis. Open a database for analysis, and click the analysis option on the tool menu. the pop-up menu contains tables,

Now you can perform basic operations, but sometimes the database you create is very slow, because the database is notProceedPassOptimizationAnalysis. Now let's talk about the databaseOptimizationAnalysis.

First, openProceedAnalysisAnd then click"Analysis"Option. The pop-up menu contains three commands:" table "," performance ", and" Document Manager. These three commands can be usedProceedOptimization.

First, you mustProceedClickOptimizationClick the "table" command. ACCESS to start preparing this tableAnalysisIn the first page of the wizard, the wizard provides a common problem for creating a table. This means that the same information is stored in tables or queries multiple times, and duplicate information will cause many problems. After reading this, We can click "Next.

Step 2 tell us thisAnalysisHow to solve the problems encountered in step 1. The solution is to split the original table into several new tables so that the data in the new table is only stored once.

Click "Next". In the list box in this step, selectAnalysisHere, although ACCESS prompts you to select a table with duplicate information, it is best to createAnalysisThis does not take much time. Instead, you can make your work more standardized. Xiaoyu: The tables I created laterProceedClickOptimizationAnalysis. Doctor: This is a good habit. When you chooseAnalysisAfter the table is created, click "Next". In this step, select "yes" and let the wizard decide, so that ACCESS can automatically completeAnalysis. Click "Next" and clickAnalysisA dialog box will pop up on the screen. In this dialog box, it will show you whether the table selected in the previous step is required.ProceedSplit to achieveOptimization. If you do not need to split, click "cancel" to exit thisAnalysisWizard.Optimization.

If you click "Next", no such dialog box is displayed. Another window appears. This indicates that the table you created must be split to make the data reasonable.ProceedStorage. ACCESSAnalysisThe wizard has split your table into several tables and established a relationship between the tables. You only need to name these tables separately. In this case, you just need to move the mouse to the field list box of a table and double-click the title bar of the list box. A dialog box is displayed, in which you can enter the name of the table. After entering the information, click OK.

Click "Next. We are now at the end of this wizard. In this step, we will ask whether to automatically create a new query with the original table name and rename the original table. In this way, you can first make the form, report, or page based on the initial table continue to work. In this wayOptimizationThe initial table does not invalidate the original work because of changes to the initial table. Therefore, we usually choose "Yes, create a query" here, and do not select "show help information for processing new tables and queries ". after all this is done, click "finish"OptimizationAnalysisThat's done.