(Solved) : Instructions Using Ms Access Create Two Tables Input Records Establish Relationship Tables Q44020439 . . .
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 StateShort Text 2 Add > in format option Phone Short Text Do notchange Use input option SSN Short Text Do not change Use inputoption
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 notchange 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 thetitle.
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 thetitle.
Title: Client General Information – Type your name Fields touse: SSN, Phone, First, Last, State, Amount
Report 3 – Use the name below that is in bold letters as thetitle.
Title: Client Data – Type your name
Expert Answer
Answer to Instructions: Using MS Access, create two tables. Input records. Establish a relationship between tables and create repo…
OR