Microsoft Office Tutorials and References
In Depth Information
Tables, Queries, Forms, and Other Objects
Queries for getting the data out
Figure 1-3 shows a simple query for finding out which employees in the
database table shown in Figure 1-1 are Sales Representatives. A query is
a question you ask of a database. The question here is, “Who is a Sales
Representative?” Notice the criterion “Sales Representative” in the Job Title
field on the Query grid.
Book VII
Chapter 1
Figure 1-3:
Querying a
database.
In an address database, you can use a query to find all the people in a
particular ZIP code or state. If information about contributions is stored in
the database, you can find out who contributed more than $500 last year.
Queries can get very complex. For example, you can find all the people in a
particular city who contributed between $50 and $500 and volunteered more
than eight hours in the past year. You can construct the query so that it
produces each person’s name and telephone number, or you can construct it
so that all the information you have concerning each person appears in the
query results.
When you get junk mail, it likely comes to your mailbox as the result of a
database query. Companies routinely buy and sell customer databases. They
query these databases to gather the names of people who they believe are
well-disposed to purchasing the products they sell. Next time you get junk
Search JabSto ::




Custom Search