please do the problem listed in the pictures and answer all ?’s. all
necessary files are located below . . when working on the assignment use the
numbers listed in the files. if you have any other ?’s feel free to ask
ASAPDear IS 3100 Students,
Your task is to create, complete, and submit an Access database based on Application Exercise
5-3 starting on page 513 of the Kroenke textbook.
You are required to complete and save the database Access Task link on the Assignments page.
How to approach this task?
Read the chapter;
Read the assignment fully;
Take notes;
List requirements;
Design your database;
Open Access, provide a name (LastNameAccess.accdb);
Start building, and then save.
Your response is required as follows:
1. Your completed workbook must be authentic; it must be your own original work. Any
plagiarism will result in a failing grade for the course.
2. Please make sure the file is attached before you submit.
3. You may use the Questions about the Access Task thread on the Discussion Board to ask
questions about the task and exchange ideas with your classmates.
Criterion
Description
Structure
A completed and organized database is present and
according to instructions.
20
Tables
Tables are present, correct, and complete with data.
30
Forms
Form and subform are present, correct, and functional.
30
Report
Report is present, correct, and organized.
20
Total:
Maximum
points
100
Your
Points
0
ID
1
2
3
4
5
6
FirstName
Marvin
Andrea
Elton
Melissa
Stan
Hal
LastName
Pine
Ashley
Maple
Brooks
Calbro
Scott
Department
Purchasing
Marketing
Marketing
Accounting
Human Resourse
Operations
SerialNumber
400
500
200
300
600
700
900
100
800
Brand
Sony
Lenovo
Toshiba
Dell
Dell
Lenovo
Dell
Dell
HP
PurchaseCost
$1,750.00
$900.00
$1,050.00
$1,475.00
$1,195.00
$1,325.00
$1,800.00
$1,750.00
$750.00
OperatingSystem EmployeeID
Windows 8
1
Windows 7
6
Windows 7
6
Windows 8
3
Windows 7
4
Windows 7
5
Windows 7
5
Vista
2
Windows 8
2
5-3.
1
ΚΑ
In this exercise, you will create a two-table database, define relationships,
create a form and a report, and use them to enter data and view results.
a. Download the Excel file Ch05Ex03_U7e.xlsx. Open the spreadsheet and review the
data in the Employee and Computer worksheets.
b. Create a new Access database with the name Ch05Ex03_Solution. Close the table that
Access automatically creates and delete it.
c. Import the data from the Excel spreadsheet into your database. Import the Employee
worksheet into a table named Employee. Be sure to check First Row Contains Column
Headings. Select Choose my own primary key and use the ID field as that key.
d. Import the Computer worksheet into a table named Computer. Check First Row
Contains Column Headings, but let Access create the primary key.
e. Open the relationships window and add both Employee and Computer to the design
space. Drag ID from Employee and drop it on Employeeld in Computer. Check Enforce
Referential Integrity and the two checkmarks below. Ensure you know what these ac-
tions mean.
f. Open the Form Wizard dialog box (under Create, More Forms) and add all of the col-
umns for each of your tables to your form. Select View your data by Employee. Title
your form Employee and your subform Computer.
g. Open the Computer subform and delete Employeeld and ComputerID. These values
are maintained by Access, and it is just a distraction to keep them. Your form should
appear like the one shown in Figure AE-5.
h. Use your form to add two new computers to Amanda Ashley. Both computers are
Dells, and both use Vista; one costs $750, and the other costs $1,400.
Employee
5 5
FirstName
Stan
LastName
Calbro
Department
Human Resourse
Computer
SerialNumber
Brand
700 Lenovo
PurchaseCost
OperatingSystem
$1,325.00 Windows 7
$1,800.00 Windows 7
900 Dell
Figure AE-5
Employee Computer Assignment
Form
Record: 1
1 of 2
No Filter
Search
513
i. Delete the Lenovo computer for Stan Calbro.
j. Use the Report Wizard (under Create) to create a report having all data from both the
Employee and Computer tables. Adjust the report design until you find a design you
like. Correct the label alignment if you need to.
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.