Access2000 provides two ways to create a table: Create an empty table for input data, and create a table using the existing data from other data sources. You can use the Database Wizard to create all the tables, forms, and reports required for the database during database creation. Maybe you will think of this as using the Chinese VisualFoxPro6
Access 2000 provides two ways to create a table: Create an empty table for input data, and use existing data from other data sources to create a table. You can use the Database Wizard to create all the tables, forms, and reports required for the database during database creation. Maybe you will think of this with the use of the Chinese Visual FoxPro 6
ChineseAccess 2000 provides two typesCreateTable method:Create"Empty table" for input data ";UseExisting data in other data sourcesCreateTable.Use"DatabaseWizardDatabaseOperation in progressCreateTheDatabaseAll required tables, forms, and reports. You may thinkUseChineseThe "Project Manager" in Visual FoxPro 6 is similar. In fact, their functional differences are quite obvious.DatabaseWizard "yes"CreateNewDatabaseBut cannot add new tables, forms, or reports to existingDatabase. After the operation in the previous section is complete, it should be set up.DatabaseBut there are no records in each table. For example, click the "Enter/view customer" button in the "master switch panel" (see). The "customer" table is displayed on the screen, and the records in the table, and Figure 8 shows that the table does not have any data records.
Click this button
In the "customer" table,ChineseAccess 2000DatabaseThe wizard has created the required fields and allows you to enter records for these fields later. If necessary, you can add new fields and delete extra fields.
In fact, the "customer" window shown in Figure 8 isChineseAccess 2000 is used to input and browse data records. This chapter describes the operations and Windows dedicated to input data records. follow these steps:
Figure 8 input data records
Step 1. Set "employee working hours and salary"DatabaseSet the window to the current form (click it or press the F11 function key on the keyboard), and open the "object" group in the list. See figure 9.
Figure 9 click and open the group
Note: "employee working hours and wages"DatabaseThe window provides a toolbar from which you can selectUse"Design" view (see the following content) and the list method. The list method is the same as that of other Windows applications. They are: "icon" and "list.
Step 2: Select "table" in the group list, and then click "customer" in the right-side table list box, as shown in 10.
0-click the "customer" table
Step 3. Enter data records in the customer table.
Because a row of records has been input in the previous input/browse window, you will see a row of existing records after entering the "customer table, in this case, you can enter the second row of records starting from the "Company Name" column. For more information, see 1. The "Customer ID" field indicates the number,ChineseAccess 2000 is automatically provided, so you don't need to worry about it, but you can enter a specific number if needed.
1. enter a new record line from here
Note: If you want to modify the field structure in the table, remove unnecessary fields, add required fields, and then input data records, you can refer to the following content.