1
Lab 3: Part2: MS Access/DeSassure
Instructions: Create two tables. Input records. Establish a relationship between
the 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
F. Upload the MS Access file.
3