Chinese Access2000 Accelerated Tutorial--2.1 Use the wizard to create a simple select query

Source: Internet
Author: User
Tags query
access| Create | tutorials | Use wizards | crash | Chinese

First, use the wizard to create a simple select query

Using a query in Chinese Access 2000 also allows you to view, change, and analyze data in different ways, as well as to use a query as the recordsource for forms, reports, and data access pages. The most common type of query is the SELECT query, which retrieves the data from the table using the specified criteria, and then displays the data in the order in which it is needed. When you do this, you can create a query by using the Designer, wizard, just as you would with the Chinese visual FoxPro 6 (see the Follow up course for this web), only when you're doing it in a different way than the name of the dialog box and how it works. But Chinese Access 2000 is easier for beginners to master and less of a theory to use.

If you are a busy person, you can quickly create a simple and useful query by using the Simple Query Wizard provided by Chinese Access 2000, and you specify the data in the retrieved field in one or more tables or queries. If you want, you can also calculate totals, counts, and averages for a group of records or all records, as well as a minimum or maximum value in a field, but you cannot limit the retrieved records by setting criteria. To use it, you can follow these steps.

Step one, see Figure 1, in the Database window, click the query item in the Objects list, and then click the New button on the Database window toolbar.

Figure 1 Click this list item

In step two, select the Simple Query Wizard in the list in the New Query dialog box, and then click OK to see Figure 2.

Figure 2 Click the Simple Query Wizard

Step three, after you go to the Simple Query Wizard, select the table you want to query from the table/query Drop-down list shown in Figure 3.

Figure 3 Selecting the table to query

Step four, select the fields you want to query from the Available fields list, and then move them to the selected Fields list by clicking the Add button, as shown in Figure 4.

Figure 4 Select the fields you want to query



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.