Creating a Query Using a Wizard

graphics/microsoft138_1.gif

A query is a simple question you ask a database to help you locate specific information within the database. When you create a query with the Query Wizard , you can specify the kind of query you want to create and type of records from a table or existing query you want to retrieve. The Query Wizard guides you through each step; all you do is answer a series of questions, and Access creates a query based on your responses. All queries you create are listed on the Queries tab in the Database window.

Create a Simple Query Using the Query Wizard

graphics/1_icon.jpg

In the Database window, click Queries on the Objects bar, and then double-click the Create Query By Using Wizard icon.

graphics/2_icon.jpg

Select a table or existing query.

graphics/3_icon.jpg

Click to select the fields that you want included in the query.

graphics/4_icon.jpg

Click Next to continue.

graphics/5_icon.jpg

If you selected numeric or date fields in step 3, indicate whether you want to see detail or summary information.

graphics/6_icon.jpg

If you choose Summary, click Summary Options to specify the calculation for each field, and then click OK.

graphics/7_icon.jpg

Click Next to continue.

graphics/06inf05.jpg

Did You Know?

You can include fields from another source . Click the Tables/Queries list arrow if you want to include a field from another source.

You can use the New button to create a query . In the Database window, click Queries on the Objects bar, click New, click the wizard you want to use, click OK, and then follow the wizard instructions.


graphics/8_icon.jpg

In the final wizard dialog box, type the name of the query.

graphics/9_icon.jpg

Choose whether you want to view the results of the query or modify the query design in Design view.

graphics/10_icon.jpg

For more help on queries, select the Display Help On Working With The Query? check box.

graphics/11_icon.jpg

Click Finish.

graphics/06inf06.jpg

Did You Know?

You can switch between Datasheet and Design view . In Design view, you format and set controls for queries, reports , forms, or tables that you are creating from scratch or modifying from an original wizard design. In Datasheet view, you observe the result of the modifications you have made in Design view. To switch between the two, click the View button on the toolbar, and then select the appropriate view.




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net