Optimization and security of ACCESS data

Open a database for analysis, and click the analysis option on the tool menu. the pop-up menu contains three commands: Table, performance, and document manager. These three commands can optimize the corresponding content. First, optimize the table and click the table command. ACCESS to start preparing the table analyzer wizard, on the first page of this wizard

Open a database for analysis, and click the analysis option on the tool menu. the pop-up menu contains three commands: Table, performance, and document manager. These three commands can optimize the corresponding content. First, optimize the table and click the table command. ACCESS to start preparing the table analyzer wizard, on the first page of this wizard

Open a database for analysis, and click the "analysis" option on the "Tools" menu, the pop-up menu contains three commands: "table", "performance", and "Document Manager. These three commands can optimize the corresponding content.

First, optimize the table and click the "table" command. ACCESS started to prepare the table analyzer wizard. On the first page of the wizard, we provided 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 shows how the analyzer solves the problems encountered in step 1. The solution is to split the original table into several new tables to make the new table

The data is only stored once.

Click "Next". In the list box in this step, select the table to be analyzed. Here, although ACCESS prompts you to select a table with duplicate information, however, it is best to perform an analysis on all the tables, which does not take much time. Instead, you can make your work more standardized. Xiaoyu: The tables I have created in the future will be optimized and analyzed. Doctor: This is a good habit. After you select the table to be analyzed, click "Next". In this step, select "yes" for the Wizard to decide, in this way, ACCESS can automatically analyze the table for us. Click "Next". A dialog box is displayed on the screen after analysis. In this dialog box, the table selected in the previous step needs to be split for optimization. If you do not need to split the table, click "cancel" to exit the Analysis Wizard. The created table does not need to be optimized.

If you click "Next", no such dialog box is displayed. Another window appears. This indicates that the created table must be split to store the data reasonably. Now the ACCESS Analysis Wizard has split your table into several tables and created 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. This not only optimizes the initial table, but also does not invalidate the original work because of changes to the initial table. Therefore, we usually select "Yes, create query" here, and do not select "show help information for processing new tables and queries ". After all this is done, click the "finish" button to complete the optimization analysis of a table.

　　How to analyze the database performance

We analyzed the table just now. We can see that there are two options under the menu analysis: "performance" and "Document Manager". The two options are described below.

Click "analysis" in the "Tools" menu and select the "performance" command. Now we start to analyze the performance of the entire database. For ease of use, we often select the "All object types" option,

And click the "select all" button on this tab, although it will make us spend more time on performance analysis, it is very worthwhile. After that, click the "OK" button on this tab. Now, ACCESS begins to optimize and analyze our database.
The analysis result is displayed,

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.

The "idea" item with the "bulb" symbol remains unchanged. When we select one of the "idea" options, we will find that the "analysis comment" in this dialog box will detail the ACCESS idea to solve this problem,

You only 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 all the information of each object in the created database, move the mouse over this option, and click the left mouse button. A dialog box is displayed on the screen,

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,

The dialog box contains three definition groups: "Table meaning", "field meaning", and "index meaning". selecting different options in the group will change the printed table, that is, the content of the information to be displayed. When we complete these tasks, click OK.

With this information, experienced ACCESS users can analyze the problems of the created database from the printed information.

　　Security Management

We will also accumulate a lot of experience in using the database, which can help us use the database more rationally. Now let's talk about the security management of ACCESS databases.

Generally, the database we create does not require everyone to use it and can modify the content in the database. This requires that our database be managed more securely. Restrict access by some people and modify the content in the database. Visitors must enter the corresponding password to operate the database, and there are limits on the operations that can be performed by those who enter different passwords. In addition, database security also includes data encryption and decryption. In this way, the databases you create that require confidentiality cannot be easily attacked by others. Security and confidentiality.

To implement security management, we need to achieve the goals mentioned above. We have provided several commands in ACCESS to help us achieve these goals.

Now let's add security management for the database address book. To manage the security of the database, first open the database and click "security" on the "Tools" menu. A small menu is displayed on the right of the "Security" item, which has five options. Each option can execute certain functions.

　　

　　Set and cancel database passwords

First, let's talk about setting and canceling the Database Password. Click the "tool" topic on the ACCESS menu bar and move the mouse to the "Security" item on the menu that appears. A smaller menu is displayed on the right of the "Security" item. Move the mouse over the first "set Database Password" in the menu and click the left mouse button. The "set Database Password" dialog box is displayed,

In this dialog box, you need to enter the database password in the first text box, and then enter the password you just entered in the second text box, to ensure that the entered password will not cause us to be unable to open our database in the future due to incorrect password. After completing these steps, click OK.

In this case, a prompt window is displayed, prompting you to enable the database exclusively before you can set or cancel the Database Password.