  Tables
 Forms
 Reports
 Macros
 Modules |
After creating tables, you may find that the information that you have recorded is too much to see at once. This is the time that queries really come in handy.
A query is an object that displays selected data from one or more tables. These queries can be displayed on screen, be created as tables, or be viewed by forms. To really get an idea of how a query will work, look below to the illustrated example.
Going back to the book database from the example described in the Tables section, a listing of books and their publication dates are desired, but only from a particular author. The initial table consists of rows of all the books with their corresponding information, seen here:
From here, a query would be created specifying the authors name (Agatha Christie) and pulling the appropriate fields that you would like in the query (Title, Author, and Publication Date). This query leaves the following result:
 |
Effective use of queries within a database will help get a clear focus on the data, and from there, allow for proper analyses of that data.
|
Queries
What is a query?
