Chinese Access2000 Accelerated Tutorial--1.1 Use the wizard to design a database

First, use the wizard to design the database

Use Chinese Access 2000 to organize user information from a single database file. In this file, you can separate the data in the name "table". This is the previous container for the datasheet, and then you can use the online form to let network users view, add, and update data in the table, query find and retrieve data, and use reports to analyze or print data in a specific layout. In addition, you can view and update or analyze data from the Internet by creating a data access page. As with the two software described earlier, to store and use data, you can create a table for each type of information, and you can then organize data from multiple tables in a form, report, or data access page, and define relationships between tables to help you find and retrieve data that meets only the criteria you specify. Beginners should note that the "form" here is an object that is not in the top two software.

It is important to design a database before you can use Chinese Access 2000 to create tables, forms, and other objects that make up your database. Because whether you use a database or a project in Chinese Access 2000, you need a database that can perform the required functions efficiently and accurately and in a timely manner.

As with the Chinese visual FoxPro 6, in Chinese Access 2000, you can also create a database by using a "wizard" that has the name "Database Wizard," which, when you start the software, will be a dialog box shown in Figure 1, which is also a wizard-like dialog box. Used to guide you through the process of establishing a database file, similar to how you would do in Chinese visual FoxPro 6.

After that, you can create a database file by following these steps.

Figure 1 Entering the Microsoft Access dialog box

Step one, open the Access Database Wizard, data pages, and items radio button. Then click the OK button, see Figure 1.

By the way, if you open the empty Access database radio button in the Microsoft Access dialog box, an empty database will be created, but you can then add the related table to it. Open the Open existing File radio button, you can choose to open a database that already exists from the list below.

After you complete this step, the new dialog box, shown in Figure 2, lets you select a template to quickly build the database.

Note: If you have already opened the database, or if you close it when you display the Microsoft Access dialog box after you start, click the New button on the Standard toolbar, and then create a new database from the Database tab.

Figure 2 Selecting the work and billing template

In step two, see Figure 2, select the work and billing template in the Database tab of the New dialog box, and then click OK to go to the File New Database dialog box shown in Figure 3.

Note: There are many templates available in this dialog box, where only work and billing is selected for demonstration operations.

Figure 3 Specifying the data file name in this dialog box

The name of the File New Database dialog box does not conform to the Chinese grammar rules. But its basic function is familiar to every Windows user, through it can specify the data file name, and save its folder, this book gives the filename here is "employee hours and wages", click the "Create" button, The newly created database file will be specified to be saved in the default folder of Access 2000. At this point, a new database is set up, and the Database Wizard dialog box will appear on the screen, as shown in Figure 4.

Figure 4 In this dialog box, click the Next button

In step three, click the Next button in the First Action dialog box in the Data Wizard.

Figure 5 Selecting Tables and fields in a database

Step four, in the Second Action dialog box of the Database Wizard, select tables in database and fields from tables.

Next, you can also do more in the Database Wizard, which is what you have the ability to do, and this book is not going to say anything more, just provide the form that will appear on the screen after the operation is finished, as shown in Figure 6.

Figure 6 Entering the main Switchboard form

Behind the main Switchboard form is the employee hours and wages form, as shown in Figure 8. After that, a new database is created, which allows you to perform a variety of operations on the two forms. Whenever you use the Database Wizard to create a new database, Chinese Access 2000 automatically creates a new switchboard that is helpful for browsing the database. There are buttons in the switchboard that you can click to open the appropriate forms and reports (or to open switchboards for other forms and reports), exit Chinese Access 2000, or customize the switchboard.

Note: The role of form in Chinese Access 2000 is to provide an operating platform from which you can select the object you want to manipulate and enter the appropriate Action dialog box.