Microsoft Office Tutorials and References
In Depth Information
Give me the number, name, amount
paid, and current due for all clients
whose name starts with Be.
Give me the number,
name, amount paid,
and current due for
client FD89.
Give me the number, name, amount paid, current
due, and recruiter number for all clients whose
amount paid is more than $20,000 and whose
recruiter number is 21.
List the client number, name,
recruiter number, and
amount paid for all clients.
Sort the results by recruiter
number and amount paid.
Summarize the total
amount paid by city
and by recruiter.
Database
For each recruiter, list the
number, last name, and first
name. Also, list the client number
and name for each of the
recruiter’s clients.
Give me the average
amount paid by
clients of each
recruiter.
List the client number, client
name, amount paid, current
due, and the total amount
(amount paid plus current
due) for each client.
Figure 2–1
AC 75
 
Search JabSto ::




Custom Search