Question: Assignment You must design a Microsoft Access database file for managing project & employee data with tables, fields, relationships, and queries as given below. Please
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.
1) Relationships: Link all foreign key fields to their original tables
Account.customer to Customer.id
Customer.agent to Agent.id
Agent.location to Location.id
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
