Security architecture – 1

1

Lab: MS Access/DeSassure

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

F. Upload the MS Access file. This should be ONE file.