A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments using the following business rules: Patients can have many doctors and many doctors can see many patients. Patients can have many procedures and many procedures are done on patients. Doctors can have multiple appointments. (hint: these are many to many relationships, so associative tables need to be added). Milestone 2

Create and Populate the Database 6a Create the tables and relationships in Access 15

6b Integrate the data from the spreadsheets 20 6c Create query 1 - Create any Action query 1 - Action queries can delete records, update data, append data from one or more tables to another table, and make a new table. See your professor 10

6d Create query

2. - Multiple criterion query 10

6e Create query

3. - Crosstab query or create a Form of your choice