Security Architecture & Design

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. This should be ONE file