Extracting Information from a Database (Queries)

When you create a basic select query, you identify the table (or tables) with the data you want to find, name the fields to appear in the query results, and then save the query. The Query Wizard walks you through the process, making it easy to identify the tables and fields to appear in your query. What’s more, you can choose whether to have Access display detailed results (that is, the individual query rows) or summarize the query’s contents.

Create a Detail Query

  1. Click the Create tab.

  2. Click Query Wizard.

  3. Click Simple Query Wizard.

  4. Click OK.

    Tip

    Tip

    To add all of a table’s fields to your query, click the Add All (>>) button. You can also remove a field by clicking the Remove (<) button or remove all fields by clicking the Remove All (<<) button.

    Tip

    Tip

    This step of the wizard only appears for some types of queries; don’t panic if you don’t see it.

  5. Click the Tables/Queries down arrow and then click the table or query with the fields you want to use in your query.

  6. Click the first field to include in the query’s results.

  7. Click Add.

  8. Repeat steps 6 and 7 to add more fields (and step 5 to change the table or query from which you draw fields).

  9. Click Next.

  10. Click the Detail option button.

  11. Click Next.

  12. Type a name for your query.

  13. Click Finish.

    Tip
    Tip
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset