Developing Data Queries

To do this assignment you'll need:

• The project instruction sheet
• The Access database file (file will download as a Zip)

When you've completed the assignment, zip the Access database and submit to the dropbox with the query designs in place. Do not just present a printout.

Please Meet Criteria!

List the fields found initially (#2 top of instructions)

Identify fields in the original run but not in the query. What fields are new? (#5 top of instructions)

Run Query1 ? discharge date prior to 12/31/01 (accurate, complete, in the correct order)

Run Query2 ? sorted by birthdate (accurate, complete, in the correct order)