Chinese Access2000 quick start tutorial-2.1 use the Wizard to create a simple selection Query

In the Chinese Access2000, you can also view, change, and analyze data in different ways. You can also use the query as the record source of the form, report, and data access page. The most common Query type is to select a query. It can use the specified criteria to retrieve data from the table and then display the data in the desired order. During the operation, you can use the Chinese Visu

In Access 2000, you can view, modify, and analyze data in different ways. You can also use the query as the record source of the form, report, and data Access page. The most common Query type is to select a query. It can use the specified criteria to retrieve data from the table and then display the data in the desired order. During the operation, you can use the Chinese Visu

In Access 2000, you can view, modify, and analyze data in different ways. You can also use the query as the record source of the form, report, and data Access page. The most common Query type is to select a query. It can use the specified criteria to retrieve data from the table and then display the data in the desired order. During the operation, you can use the "designer" and "Wizard" as in Visual FoxPro 6 (refer to subsequent courses on this website) to create a query, the operation method is different from the name of the dialog box and the running mode. However, Chinese Access 2000 is easier for beginners to master, and the theory used is less.

If you are a busy man, you can quickly create a simple and practical query by using the "simple query wizard" provided by Access 2000, in addition, you can specify the data in the search field in one or more tables or queries. If necessary, you can also calculate the total, count, and average values of the record group or all records, and calculate the minimum or maximum values in the field, but you cannot set a criterion to limit the records to be retrieved. To use it, follow these steps.

Step 1. See. In the "Database" window, click "query" in the "object" list, and then click "new" on the toolbar of the "Database" window.

Click this list item

Step 2: Select "simple query wizard" in the list of the "new query" dialog box, and click "OK". For more information, see.

Click "simple query wizard"

Step 3. Go to the "simple query wizard" and select the table to be queried from the "Table/query" drop-down list.

Select the table to be queried

Step 4. Select the fields to be queried from the "available fields" list, and then use the "add" button to move them to the "selected fields" list in sequence. For more information, see.

Select the fields to be queried