Microsoft Office Tutorials and References
In Depth Information
Chapter 1: Creating Select Queries
Chapter 1: Creating Select Queries
In This Chapter
Seeing what queries do and what kind of queries you can make
Creating a select query with a wizard
Creating and editing a select query in Design view
Using criteria and sorting to get the data in your queries
Using query datasheets to enter and edit data
Saving your queries
Q ueries are a way to ask questions of your data. Do you want to know
who ordered a lawn flamingo? Which customers live in California?
Which orders contain items that have been discontinued? What your ten
best-selling items are? Queries can tell you all that and more.
Like tables, which we cover in Book II, queries have two views: Design and
Datasheet. In Design view, you define your query, telling Access which fields
you want to see, which tables they come from, and the criteria that any
record has to meet to appear on the resulting datasheet. In Datasheet view,
you see the fields and records Access finds that meet your criteria.
You can use queries to do the following:
Look at data from related tables.
Look at subsets of your data — selective slices that meet certain criteria
that you specify.
Sort and alphabetize data.
Create new calculated fields.
You can make as many queries as you want to. Usually, some queries are
made on the fly and not saved; others are saved and used as the basis for
forms and reports.
To create a query, you need to know what data — more specifically, which
fields — you want to see and which tables those fields are in. As you define
the query, you may have criteria that limit the data. After you define the
query, you can view the data in a datasheet (or in a form or report to see the
data in a different format). The datasheet created by a query is dynamic
that is, you see the data that meets the query definition each time you view
Search JabSto ::




Custom Search