Chinese Access2000 quick tutorial-1.2 use the "Database Wizard" to create a table

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. Use the Database Wizard to create all the tables, forms, and reports required for the database during database creation. You may think that this is similar to the "Project Manager" in Visual Foxpro 6. In fact, their functions are quite different. Here, the "Database Wizard" can create new databases, however, you cannot add a new table, form, or report to an existing database. After the operation in the previous section, you should have created various tables in the database, but each table does not have any records, for example, if you click the "Enter/view customer" button in the "master switch panel" (see figure 7), the "customer" table and records in the table are displayed on the screen, and Figure 8 shows that the table does not have any data records.

Figure 7 click this button

In the "customer" table, the "Database Wizard" of Chinese Access 2000 has created the required fields and allows you to enter records for these fields subsequently, add new fields and delete extra fields if necessary.

In fact, the "customer" window shown in Figure 8 is a Chinese Access 2000 window dedicated to inputting and browsing data records. The following sections describe operations and Windows dedicated to input data records, follow these steps:

Figure 8 input data records

Step 1. Set the "employee working hours and salary" Database window to the current form (click it, or press the F11 function key on the keyboard), and then open the "object" group in the list, see Figure 9.

Figure 9 click and open the group

Note: The "employee working hours and salaries" Database window provides a toolbar from which you can choose to use the "design" view (see the following content) and the list method. List methods and other Windows ApplicationsProgramThey 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.

Figure 10 target customers

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 Record of the second row starting from the "Company Name" column. See Figure 11. The "Customer ID" field indicates the number, which is automatically provided by the Chinese Access 2000, you don't need to worry about it, but you can enter a specific number if needed.

Figure 11 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 enter data records, refer to the following content.