Microsoft Office Tutorials and References
In Depth Information
2 Querying a Database
A database management system such as Access offers many useful features, among them
the capability of answering questions, the answers to which are found in the database.
When you pose a question to Access, or any other database management system, the
question is called a query. A query is simply a question presented in a way that Access can
Thus, to ﬁ nd the answer to a question, you ﬁ rst create a corresponding query using
the techniques illustrated in this chapter. After you have created the query, you instruct
Access to display the query results; that is, to perform the steps necessary to obtain the
answer. Access then displays the answer in Datasheet view.
Project — Querying A Database
Organizations and individuals achieve several beneﬁ ts from storing data in a database and
using Access to manage the database. One of the most important beneﬁ ts is the capability
of easily ﬁ nding the answers to questions such as those shown in Figure 2-1 and the
following, which concern the data in the JSP Recruiters database:
1. What are the number, name, the amount paid, and the current due of client FD89?
2. Which clients’ names begin with Be?
3. Which clients are located in Berridge?
4. Which clients have a current due of $0.00?
5. Which clients have an amount paid that is more than $20,000.00?
6. Which clients of recruiter 21 have an amount paid that is more than $20,000.00?
7. In what cities are all the clients located?
8. What is the total amount (amount paid + current due) for each client?
9. What is the client number and name of each client, and what is the number and
name of the recruiter to whom each client is assigned?
In addition to these questions, JSP Recruiters needs to ﬁ nd information about
clients located in a speciﬁ c city, but they want to enter a different city each time they ask the
question. A parameter query would enable this. The agency also has a special way it wants
to summarize data. A crosstab query will present the data in the desired form.