Instructions: Using MS Access, create two tables. Input records. Establish a relationship between tables and create reports.

1. Create the table below.

File Name: Client_typeyourname

DO NOT DELETE THE ID FIELD!!!!!!

For each table, input 10 records.

A. Table Name: Client Information

Field Data Type Field Size Comments First Short Text 25 Add > in format option Last Short Text 25 Add > in format option State Short Text 2 Add > in format option Phone Short Text Do not change Use input option SSN Short Text Do not change Use input option

B. Input 10 records. Make-up the data. 2

C. Create table TWO.

DO NOT DELETE THE ID FIELD!!!!!!

For each table, input 10 records.

A. Table Name: Client Amount

Field Data Type Field Size Comments Amount Currency Do not change Input value of from $100 to $5,000

D. Establish a relationship using the ID key.

E. Create reports. Modify the reports as required.

Fields to use: First, Last, Phone, Amount, State

Report 1 - Use the name below that is in bold letters as the title.

Title: Client Information Type your name Fields to use: SSN, First, Last, Phone

Report 2 - Use the name below that is in bold letters as the title.

Title: Client General Information Type your name Fields to use: SSN, Phone, First, Last, State, Amount

Report 3 - Use the name below that is in bold letters as the title.

Title: Client Data Type your name