Assignment

You must design a Microsoft Access database file for managing project & employee data with tables, fields, relationships, and queries as given below. Please submit your Access file without any data the TAs will import data to test your work. However, you may find it useful to temporarily add some data to your tables, especially to test your queries.

3) Queries:

Select and display all Customer first & last names with a 2/29 birthday

Select and display all Agent first & last names where the Agent's Location is 1 or 2

Select and display all Location names & addresses

Select and display all Customer addresses, zip codes, & emails where the Customer's Agent has the last name "Jackson" & the first name "Bob"

Select and display all Account records (all fields) where the Account's status is "Platinum"

Select and display all Account ids, balances, & limits where the Account's Customer has the last name "Burns" & first name "Montgomery"