Chinese Access2000 Crash Course--1.5 use existing data to automatically build a new table

access| Tutorials | data | quick | Chinese Five talk about using existing data to automatically build a new table

In Chinese Access 2000, you can enter data directly into a blank datasheet, and then when you save the new datasheet, the software can analyze the data and automatically specify the appropriate data type and use format for each field. In order to perform this operation, to start by selecting the table item in the objects list in the employee hours and Wages Database window, and then clicking the New button on the toolbar, go to the New Table dialog box, and then through the Datasheet view item in the list, see Figure 23.

Figure 23 Selecting this list item

After that, an empty datasheet appears similar to the Chinese Visual FoxPro 6 Browsing window, providing a default column name, field: Field 1, Field 2, .... At this point, you can enter the data record immediately, as shown in Figure 24. But the result is not practical, you must also think that only if you set the field name to create a real table, you should rename each column you want to use. To do this, you can use the following two methods of action:

Figure 24 Entering data records

Figure 25 The result of modifying the column name

1. Modify directly in the table

Combo The column name you want to modify, and then type the new column name when an insertion point cursor appears in the cell. This method is characterized by fast operation and results as shown in Figure 25.

Figure 26 Select this command

2. Through the shortcut menu to operate

The procedure for this method is as follows:

Step one, right-click the column name that you want to modify, and then select Rename Column from the shortcut menu shown in Figure 26.

Step two, enter a new name from the keyboard.

The shortcut menu shown in Figure 26, in addition to being able to complete the column renaming operation, can do something else, where "sort" and "insert Column" is commonly used, the operation method and Chinese visual FoxPro 6 similar, you can try.

The new table structure established in this chapter and the data records entered are shown in Figure 27.

Figure 27 The new table established in this chapter

After you enter data into all columns, you can name the new table by clicking the Save button on the Standard toolbar. Operation, Chinese Access 2000 will ask if you want to create a primary key. If you have not entered data that uniquely identifies each row in the table, such as a part number or an ID number, the software will recommend "Yes". If you have entered data that uniquely identifies each row, you can specify this field as the primary key.

Figure 28 Click this Drop-down button

Note: After you open Datasheet view, you can position the current action on the specified column with the Go To field Drop-down List on the Formatting toolbar, as shown in Figure 28. This applies when the number of columns used is large.