Please see attached documents

 

1. Skip task g.

2. Amanda Ashley is the same person as Andrea Ashley (textbook error). 

 

 

Dear 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.
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 FirstName
1 Marvin
2 Andrea
3 Elton
4 Melissa
5 Stan
6 Hal LastName
Pine
Ashley
Maple
Brooks
Calbro
Scot Department
Purchasing
Marketing
Marketing
Accounting
Human Resourse
Operations SerialNumber Brand
400 Sony
500 Lenovo
200 Toshiba
300 Dell
600 Dell
700 Lenovo
900 Dell
100 Dell
800 HP PurchaseCost OperatingSystem EmployeeID
$1,750.00 Windows 8
1
$900.00 Windows 7
6
$1,050.00 Windows 7
6
$1,475.00 Windows 8
3
$1,195.00 Windows 7
4
$1,325.00 Windows 7
5
$1,800.00 Windows 7
5
$1,750.00 Vista
2
$750.00 Windows 8
2

Attachments:

• 1493165268-AccessTask.docx
• 1493165268-Colour Palette.docx
• 1493165271-Information.pdf