I have been assigned the following assignments but I am having trouble making everything make sense and flow correctly in the database. I would like help/examples of what they should look like for me to go off of when completing my work.

 

Assignment 1)

For this assignment, you will utilize a provided database to perform basic object creation and modification.

 

At a minimum your submitted database should:

• Modify the Patient table to include at least 2 additional records
• Modify the Employee table to include an Employee Title field and then give each employee record a title in the Title field
• Make a relationship between the EmployeeID field in the Employee table and the DoctorID field in the Patient table
• Include three queries
• One query should be a simple one table query with two criteria (using the or: row. Name this one Query 1)
• One query should be a simple one table query with a criteria from the list at http://www.gcflearnfree.org/access2016/query-criteria-quick-reference-guide/1/. Name this one Query 2.
• One query should be a multiple table query with at least one criteria. Name this one Query 3.
• Each query should include multiple fields.
• Include at least one form
• The form should allow a user to add a new record to one of the tables.

The database must also utilize database design and data management principles such as primary keys and defined relationships, as appropriate.

 

Assignment 2)

For this assignment, you'll be creating mailing labels and a mail merge letter that integrate an Access database and a Word Document. The Access database has been provided for you (see attached). You will use this database as the source for your merge field data.

You may use the mail merge wizard for this assignment, or you may go through the process without the wizard. You will submit three files 

1. A finalized sheet of address labels (you can find an example in the example files for this unit)
2. You must use an address label sized label setting. The Avery US Letter, Product Number 5630 Easy Peel Address Labels setting is recommended.
3. A finalized set of 10 form letters (you can find an example in the example files for this unit)
4. A non-finalized form letter that shows the field names (you can find an example in the example files for this unit.) At minimum this file should contain:
5. An address block (can use address block field or separate fields)
6. A salutation/greeting (can use greeting field or separate fields)
7. At least 1 field in the body of the letter

Attachments:

• 1510726519-MailMerge.accdb