MyItLabs Computer Club Inventory MyItLabs Assignment

User Generated

awfzvgu93

Writing

Description

I need help with a MyItLabs Grader Project Access Chapter 1 Assignment. I apologize for the rush, but I do need the material within a rather quick period of time. The Word document should provide a detailed step by step list of the required work in Access. The Excel files should be used as the instructions suggest. I need the final version of the Access file uploaded, please help if you can, thanks!

Unformatted Attachment Preview

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
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

Here is the answer for the qu...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags