Phase 1: Written Test Phase

In this phase you will take a fifteen-question exam. I will select the questions at random from the first exam you took earlier in the course. Your best approach to studying for this phase is to study that exam. It’s posted on the syllabus website.

Phase 2: Design a Microsoft Access Database

In phase 2 you will design a Microsoft Access database. I’m concerned mostly with your demonstrated understanding of relational database terminology, not necessarily in a complete application. At minimum you will create any required tables, their fields, and relationships. You must be able to explain the purposes of Primary Keys and Foreign Keys and how they are applied to create table relationships in a relational database. The following scenario is a typical example of what will be on the test:

Task: You are a small business owner who needs to track customer data. Design a database with two tables: Customers and Purchases.

Give the Customer table the following fields of the corresponding type:

Customers
Field Name	Type	Description
ID	Autonumber	Primary Key (PK)
First_Name	Text	Customer’s first name
Middle_Name	Text	Customer’s middle name
Last_Name	Text	Customer’s last name
Date_Added	Date	Date added to the database
Address_1	Text	Street Address
City	Text	City
State	Text	State
Zip	Text

Create a second table named Purchases with the following fields and types:

Purchases
Field Name	Type	Description
ID	Autonumber	Primary Key (PK)
FK_CustomerID	Number	FK to Customers.ID. This is a look-up column.
Item Purchased	Text	Item purchased
Date Purchased	Date	Date item purchased

When you’ve finished creating the tables go to the Relationships window, select the relationship that exists between the Customers and Purchases tables, and check Enforce Referential Integrity, Cascade Delete, and Cascade Update.

Next, create a query that shows you a list of customers and the items they purchased including the date they purchased the items.

Demonstrate to me that you have created the database, the tables, the relationship between the tables, and the query.

Once you’ve created your database, populate it with test data and test the query.

Phase 3: Create Mail Merge Letter to Customers

In this phase you will use Microsoft Word to create a mail merge document that uses the data contained in the database query to generate customer form letters.

Task: Create a mail merge document to each customer. Use the query you created in the previous phase to provide the data fields. Add an address block and salutation line. Add the text of the letter. (Let your imagination help you here.) When you’ve finished, run the mail merge and show me the results.