Database Reference
In-Depth Information
You can create queries by using a Query wizard, and you can also create them from scratch.
The most common type is the select query, which extracts matching records from one or
more tables. Less common are queries that perform specific types of actions.
Processing a query, commonly referred to as running a query or querying the database ,
displays a datasheet containing only the records that match your search criteria. You
can use the query results as the basis for further analysis, create other database objects
(such as reports) from the results, or export the results in another format, such as an Excel
spreadsheet.
1
If you create a query that you are likely to want to run more than once, you can save it. It
then becomes part of the database and appears in the list when you display the Queries
group in the Navigation pane. To run the query at any time, you simply double-click it in
the Navigation pane. Each time you run the query, Access evaluates the records in the spec-
ified table or tables and displays in Datasheet view the current subset of records that match
the criteria defined in the query.
To set up a query, you work in Design view. Switching to this view displays the Query
Designer, which has two components:
The top pane displays boxes listing the fields of the tables the query is designed to
work with. Each box represents one table. In a query that works with more than one
table, lines between the boxes indicate that before the query was created, relation-
ships were established between the tables based on common fields. The relationships
enable the query to draw information from the tables.
SEE ALSO For more information about relationships, see “Defining relationships
between tables” in Chapter 2, “Create databases and simple tables.”
The bottom pane displays the design grid, where the query's search criteria are de-
fined. Each column of the grid refers to one field from one of the tables in the top
pane. Each row defines a different aspect of the query.
Don't worry if this all sounds a bit complicated at the moment. When you approach queries
logically, they soon begin to make perfect sense.
SEE ALSO For more information about queries, see Chapter 7, “Create queries.”
 
Search WWH ::




Custom Search