Vendor ID
V-001
V-002
V-003
V-004
V-005
V-006
V-007
V-008
V-009
V-010
V-011
V-012
V-013
V-014
V-015
Vendor Name
Austin Computer Parts
Sound Galaxy
Peripherals City
Reliable Computers
Parts 4 U
Digitonix Inc
Buda Computer Solutions Corp
Keyboards and Mice Galore
Dale Computer Parts
Components Inc
Computer Components 4 Sale
Computer Insides Corp
College Computer Suppliers
Rider Computer Supplies Inc
Computer Sounds Ltd
Address
5486 Main St
286 Tyco Rd
2403 Brush St
879 Ranch Rd
120 N Oak St
2930-M Enterprise Ct
862 Cedar La SE
62 Executive Dr
647 N Pickett St
7410 Fuller Rd
44 Galaxy Cir
322 Bluebell Dr
240 College Way
484 Briarwood Blvd
9000 Innovation Loop
City
Austin
Kyle
San Marcos
Leander
Austin
Red Rock
Buda
Manor
Dale
Liberty Hill
Dripping Springs
Austin
Austin
Spicewood
Austin
State
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
Postal Code
78748
78640
78666
78645
78749
78662
78610
78653
78616
78642
78620
78761
78762
78669
78748
Phone
(512) 555-7191
(512) 555-8200
(512) 555-4927
(512) 555-2126
(512) 555-2174
(512) 555-0505
(512) 555-8159
(512) 555-3059
(512) 555-3996
(512) 555-5303
(202) 555-7023
(512) 555-9116
(512) 555-7756
(512) 555-8089
(512) 555-3000
Email Address
parts@AustinCP.biz
sound@soundgalaxy.com
PC@pericity.biz
RC@reliablecomp.biz
parts@parts4u.biz
info@digitonix.biz
solutions@budacompsol.biz
info@keyandmice.biz
parts@dalecompparts.biz
parts@componentsinc.biz
components@computercomp4sale.biz
info@compinsidescorp.biz
info@4citiessuppliers.biz
supplies@ridercompsupplies.biz
sounds@compsoundsltd.biz
Office 2016 – myitlab:grader – Instructions
GO - Access Chapter 1: Assessment 1
GO16_AC_CH01_GRADER_1E_AS - Computer Club Inventory
Project Description:
In this project, you will create database objects to track the inventory of new computer parts used by the
Computer Club. You will create a table and import data from Excel to create a second table. You will create a
simple query, a form, and a report.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
1
Points
Possible
Instructions
Start Access. Open the downloaded file named a01_grader_a1_Computer_Club.accdb, enable
the content, and then open the Inventory table.
0
Beginning in the second column of the Inventory table and using the specified data types,
create the following fields (in this order):
2
3
Part (Short Text), Room (Short Text), Cabinet Location (Short Text), Vendor ID (Short
Text), Price (Currency), Quantity in Stock (Number).
Change the data type of the ID field to Short Text, rename the ID field to Part ID, and then
save the table.
12
6
Add the following three records to the Inventory table and then close the table.
Record 1:
Part ID: V-01
Part: Monitor with speakers
Room: SE110
Cabinet Location: Cabinet A, Shelf 3
Vendor ID: V-015
Price: 199.99
Quantity in Stock: 3
4
Record 2:
Part ID: S-01
Part: Sound Card
Room: SE110
Cabinet Location: Drawer A
Vendor ID: V-002
Price: 24.99
Quantity in Stock: 10
10.5
Record 3:
Part ID: P-01
Part: Power Supply
Room: SE110
Cabinet Location: Drawer C
Vendor ID: V-010
Price: 189.99
Quantity in Stock: 2
Updated: 12/02/2015
1
GO16_AC_CH01_GRADER_1E_AS_Instructions.docx
Office 2016 – myitlab:grader – Instructions
GO - Access Chapter 1: Assessment 1
Step
Instructions
Points
Possible
5
Append the records from the downloaded Excel file go_a01_grader_a1_Parts_Inventory.xlsx to
the Inventory table and then open the table in Datasheet view (the table has 13 records).
7
6
Switch to Design view and delete the Room field. For the Part field, enter a description of
Enter the computer component name and then change the field size to 50. For the Part
ID field, change the field size to 4 and then save the table.
8
7
Switch to Datasheet view, apply Best Fit to all of the fields in the table, save the table, and
then close the table.
0
8
Import the records from the downloaded Excel file go_a01_grader_a1_Vendors.xlsx into the
database as a new table named Vendors. Designate the first row as column headings and the
Vendor ID field as the primary key. Open the Vendors table in Datasheet view (the table has
15 records).
6
9
Switch to Design view. For the State field, enter a description of Enter two-letter state
abbreviation and then change the field size to 2. For the Vendor ID field, change the field
size to 5 and then save the table.
6
10
Switch to Datasheet view, apply Best Fit to all of the fields in the table, save the table, and
then close the table.
0
11
Based on your Inventory table, use the Query Wizard to create a simple query. Add the Part,
Cabinet Location, and Quantity in Stock fields (in that order). Keep the default name of
Inventory Query, click Finish to display the query results, and then close the query.
8
12
Based on your Vendors table, use the Form tool to create a form for the table. Save the form
as Vendor Form, display the form in Form view, and then close the form.
8.5
13
Based on your Inventory table, use the Report tool to create a report. Delete the Vendor ID
and Price fields from the report. Save the report as Inventory Report.
15
14
Sort the Part field in ascending order. Set the width of the Part and Cabinet Location fields to
2 inches. Delete the page number from the report, save the report, and then close the report.
13
15
Close all database objects, close the database, and then exit Access. Submit the database as
directed.
0
Total Points
Updated: 12/02/2015
2
100
GO16_AC_CH01_GRADER_1E_AS_Instructions.docx
Part ID
T-01
P-02
P-03
V-02
M-01
D-01
R-01
B-01
C-01
C-02
Part
Tower Case
CPU
CPU Cooler Bracket
Video Card
Mouse, Wired
Hard Drive
RAM, 8GB
Motherboard
Cables, Power Supply
Cables, Hard Drive
Room
SE110
SE110
SE110
SE110
SE110
SE110
SE110
SE110
SE110
SE110
Cabinet Location
Cabinet B, Shelf 1
Drawer C
Drawer C
Drawer B
Drawer D
Drawer E
Drawer F
Cabinet A, Shelf 1
Drawer G
Drawer G
Vendor ID Price
Quantity in Stock
V-010
79.99
3
V-010
199.99
2
V-010
22.99
7
V-015
144.99
3
V-003
49
20
V-012
169.99
5
V-013
125
4
V-009
209.99
3
V-008
3.99
10
V-008
4.99
10
Purchase answer to see full
attachment