CIS 100 -- Access Assignment 2
In this lab, you will use MS Access to perform queries on the database you
created in the first assignment.
You will perform the following queries, and save each query as the name in
parentheses in bold (such as (first query)). You will need to
copy your access1.mdb file from your backup to your application
disk and call it access2.mdb. Hint: copy and rename the file.
NOTE: If you must change your table design in order to do the queries, you
should note that on your grade sheet. You might want to add records to
your database so that you can test whether these queries work. Be sure to
test that they do.
- 1.
- (everyone): Query the first name, last name, and state of
each person in your database sorted by last name in ascending order.
- 2.
- (youngsters): Query the first name, last name, and age of people
between the ages of 15 and 30.
- 3.
- (georgians): Query the first name, last name, state, and
zip code of people that live in the state of GA.
- 4.
- (georgian adults): Query the first name, last
name, state and birthday of people who live in GA and are at least 15
years old.
- 5.
- (generosity): Query the total cost of all the gifts you
have given.
- 6.
- (beneficiaries): Query the first name, last name, and the
number of gifts given of people you have given gifts to.
- 7.
- (birthday gifts): Query the first name, last name, gifts,
and when given for only the people you gave birthday gifts to
last year.
- 8.
- (next bdays): Query the first name, last name, and DOB
for people that were born in the month of December. (Hint, you may need
wild-cards here.)
- 9.
- (non-locals): Query the first name, last name and state of
those people that do not live in GA or in FL.
- 10.
- (generosity detail): Query the first name, last name, and
number of birthday and christmas gifts you have given to each person.
(That's two numbers for each person, the total number of gifts
given for each of those occasions.)
Check with the Instructor as to how this assignment is to be turned in.
Verify that you named all of the queries properly. You will not receive credit for queries
that are named incorrectly.
This whole assignment should take you between one and two hours. If it is
taking you longer than that, find someone to ask for help.
CIS 100 -- Access Assignment 2
This document was generated using the
LaTeX2HTML translator Version 98.1 release (February 19th, 1998)
Copyright © 1993, 1994, 1995, 1996, 1997,
Nikos Drakos,
Computer Based Learning Unit, University of Leeds.
The command line arguments were:
latex2html -split 0 -no_navigation access2.tex.
The translation was initiated by Scott D. Anderson on 2000-01-24
Scott D. Anderson
2000-01-24