Description
Please see the attached file. Need to create tables , write query using MS Access
Unformatted Attachment Preview
Lab 3: Part 2: MS Access/DeSassure (Summer 2020)
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
First
Last
State
Phone
SSN
Data Type
Short Text
Short Text
Short Text
Short Text
Short Text
Field Size
25
25
2
Do not change
Do not change
B. Input 10 records. Make-up the data.
1
Comments
Add > in format option
Add > in format option
Add > in format option
Use input option
Use input option
C. Create table TWO.
DO NOT DELETE THE ID FIELD!!!!!!
For each table, input 10 records.
A. Table Name: Client Amount
Field
Amount
Data Type
Currency
Field Size
Do not change
Comments
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.
2
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Just what I was looking for! Super helpful.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
need to select an topic and write about 5-6 pages meeting GIAC standards paper guidelines and also API style of format at the end need to write an para on the topics given in question
Pick a topic for a 5-6 page paper on any topic in information security. GIAC Gold standards paper guidelines should be fol...
Campbellsville University Information Governance Worksheet
course: Information Governanceam working as a Java Full Stack Developer.Provide a reflection of 2 pages double spaced of...
my organization is the medical field
Discuss a specific situation where association rules are used, or could be used, in your organization or in one with which...
UC Institutional Review Board Discussion
The article on IRB(Institutional Research Board) this week discusses broad consent under the revised Common Rule. When you...
Current Literature to Compare the Project Management Methods Research Paper
Topic - Research paper on current literature to compare the project management methods
FORMAT-
1. Abstract -
2. Background...
AU Cyber Security Threats for Confidentiality Question
CYBER SECURITY ASSIGNMENT
Question 1
Give the Solution for the following Issues with Cyber Securitya) Threats for Confiden...
Best Coding Practices
There are many different aspects of best practice coding guidelines, but some of the most important ones include choos...
Plagiarism Report
...
Twitter Company Case Study
My case study will concentrate on using Apache Pig to manage and organize big internet datasets. Social media has become a...
