Chinese Access2000 quick tutorial-1.1 Use the "Wizard" to design a database

The first step is to use the "Wizard" to design a database. With the Chinese Access2000, you can organize user information from a single database file. In this file, you can separate the data in the container named "table", that is, the aforementioned "data table, then, you can use the online form to allow network users to view, add, and update table data and query

First, use the "Wizard" to design a database. Use Chinese Access 2000 to organize user information from a single database file. In this file, you can separate the data in the container named "table", that is, the aforementioned "data table, then, you can use the online form to allow network users to view, add, and update table data and query

Lecture 1Use"Wizard"DesignDatabase

UseChineseAccess 2000 can be used from a singleDatabaseFile. In this file, you can separate the data in the container named "table", that is, the aforementioned "data table". Then you canUseOnline forms allow network users to view, add, and update table data, query and search for data,UseReports analyze or print data based on a specific layout. In addition, you can view and update or analyze data on the Internet by creating a data access page. Like the two software mentioned aboveUseData: You can create a table for each type of information. After that, you can organize the data in multiple tables in a form, report, or data access page and define the relationship between tables, this allows you to search for and retrieve data that only meets the specified conditions. For beginners, it should be noted that the "form" here is an object not found in the first two software.

InUseChineseAccess 2000 is created for compositionDatabaseBefore tables, forms, and other objects,DesignDatabaseIs very important. BecauseUseChineseAccess 2000DatabaseOr a project requires an effective, accurate, and timely completion of the required functions.Database.

AndChineseSimilar to Visual FoxPro 6ChineseAccess 2000 can also be created through a "Wizard"DatabaseAnd their names are"DatabaseWizard ", after the software is started, a dialog box shown in 1 will be displayed on the screen. It is also a wizard dialog box to guide you through the creationDatabaseFile Operations, andChineseThe Operation Method in Visual FoxPro 6 is similar.

After that, you can create a copy by performing the following steps:DatabaseFile.

Enter Microsoft Access dialog box

Step 1. Open "AccessDatabaseWizard, data page, and project radio button. Click OK. For more information, see.

By the way, if you open "null Access" in the Microsoft Access dialog boxDatabase"Single-choice button, will create an emptyDatabaseBut then you can add the relevant tables to it. Open the "open existing file" radio button, you can choose to open an existing file from the list belowDatabase.


After this step is completed, the "new" dialog box shown on the screen allows you to select a template to quickly createDatabase.


Note: If you have enabledDatabaseOr close it when the Microsoft Access dialog box is displayed after it is started. You can click "new" in the "frequently used" toolbar andDatabase"Tab to create a newDatabase.

ChineseAccess2000 Fast Production Tutorial-- 1.1 Use"Wizard" Design Database() "Src =" http://cdn.verydemo.com/upload/2013_06_08/13706381983960.jpg "width = 344 border = 0>

Select the "working hours and bills" template

Step 2. See"DatabaseOn the "tab, select the" working hours and bills "template, and click" OK "to go to the" File Creation "page.Database"Dialog box.



Note: Many templates are provided in this dialog box. Here, only "working hours and bills" are selected for demonstration.

In this dialog box, specify the data file name

ChineseAccess2000 Fast Production Tutorial-- 1.1 Use"Wizard" Design Database() "Src =" http://cdn.verydemo.com/upload/2013_06_08/13706381983961.jpg "width = 294 border = 0>

In this dialog box, click "Next ".

Step 3: click "Next" in the "Data wizard" Step 1 operation dialog box.

ChineseAccess2000 Fast Production Tutorial-- 1.1 Use"Wizard" Design Database() "Src =" http://cdn.verydemo.com/upload/2013_06_08/13706381984122.jpg "width = 322 border = 0>

SelectDatabaseTables and fields in


Step 4:DatabaseSelect"DatabaseAnd fields in the table ".
You can alsoDatabaseYou can do more operations in the Wizard. This is what you have the ability to do. I will not talk about it in this book. I will only provide the form displayed on the screen after the operation is completed, as shown in 6.

ChineseAccess2000 Fast Production Tutorial-- 1.1 Use"Wizard" Design Database() "Src =" http://cdn.verydemo.com/upload/2013_06_08/13706381984283.jpg "width = 288 border = 0>

Go to the "Main switch panel" Form
The "employee hours and wages" form is behind the "Main switch panel" form, as shown in figure 8. After that, a newDatabaseYou can perform various operations on these two forms. AnytimeUse"DatabaseWizard "NewDatabase,ChineseAccess 2000 will automatically create a new switching panel, which viewsDatabaseVery helpful. There are some buttons in the "switch panel". You can click them to open the corresponding forms and reports (or open the switch panel for other forms and reports) and exit.ChineseAccess 2000 or custom switch panel.

Note: the "form" is inChineseAccess 2000 is used to provide an operating platform for you to select the object to be operated and enter the corresponding operation dialog box "create a file ".Database"The Dialog Box Name is invalid.ChineseSyntax Rules, but its basic functions are familiar to every Windows user, through which you can specify the data file name and save its folder, the file name provided here is "employee working hours and wages". After you click "CREATE ",DatabaseThe file will be saved in the default Access2000 folder. So far, a newDatabaseIt will be created, and the screen will also show"DatabaseWizard dialog box, as shown in figure 4.

Author: