View the step-by-step solution to:

Test the basic knowledge of the students with MS Office Word, Excel and Access applications. Students can use MS Office 2003, 2007 or 2010. MAC...

I need a tutor for my microsoft access exercises. Can anyone help?
HE1 Hands on Exercise 1 (HE1) Purpose of assignment: Test the basic knowledge of the students with MS Office Word, Excel and Access applications. Students can use MS Office 2003, 2007 or 2010. MAC versions can also be used. Overview: As part of the prerequisites for this course, it's assumed each student has the fundamental working knowledge of word processing, spreadsheets, and databases. It's expected for each student to be able to design, populate, and query small spreadsheets and databases. You may use any Windows or Mac compatible database program that will open an Access program file to complete the assignment and submit for grading. The instructor is using Microsoft Office 2010. The assignments consists of a hands-on exercise and a brief explanation of the requirements. Assignments will be graded on the accuracy of your presentation and the quality of your accompany products. The Value of each HE is 20 points toward the final grade. Software Skills: Database querying and reporting Business Skills: Sales trend analysis Data Source: Store and Region Sales Database (Attached) 1. Effective information systems transform data into meaningful information for decisions that improve business performance. The attached Excel database includes fields for store identification number, sales region number, item number, item description, unit price, units sold, and the weekly sales period when the sales were made. Students will develop reports and queries using the Office Access Program to make this information more useful for the running of the business. Use the information in the database to perform the tasks and answer the questions below, based on the information in the reports. If you need any of the Microsoft Office applications, you can download the trial version from Microsoft. 2. Students will start the HE1 assignment by importing the attached Excel file (Store and Region Sales) into Access. Name the Access database HE1_students last name. Name the imported table as Store and Region Sales. The Order number will be the primary key. Import the entire file and contents. Access Requirements: 3. Run an Access report for Vendors 1-4, a total of four reports. Each report will only show data for each vendor. There will be four reports. 4. Additional queries and reports will be required to answer the questions below.
Background image of page 1
Students will be graded on the queries and reports required to answer the questions. For the purpose of this HE, only show data from Vendors 1-4 or unless instructed otherwise. Students will name the queries and reports similar to the task item (i.e. 5a= Required Restock Items Report). 5. Run a report or query to conduct/support analysis to help management make the following decisions for Vendors 1-4. Based on the queries made, students will analyze the data to determine the response to the tasks below. a. Run a query or report to determine which Products from each vendor should be restocked when an item falls below 200. Items should be ordered when stock levels fall below 200. b. Run a query to determine which Products appear to be the top selling items? c. Run a query to determine which vendor would benefit from additional marketing and promotional campaigns? (Select the bottom 3 vendors with the lowest sales.) d. Run a report to provide a report showing the number of gaskets and O-Rings sold in October. e. Run a report to show the leading vendor by total sales based on the total cost for each order. Report will have vendors from highest to lowest. Word Requirements: f. Write the Access questions 5A-5E and answers for 5 a, b, c, d and e in Word to explain your analysis and decision. g. Include two Excel Charts in the Word document after the questions for item d and e. h. Add clip art or picture to the Word assignment. i. Include a cover page with the assignment details. j. Protect the Word assignment. Password will be HE1. Excel requirements: 6a. In Access, Run a query from vendors 1-8 to determine which items are sold at more than one vendor. Include all fields. 6b. Using the Vendors 1-8 query from Access, export this data to Excel and create a bar, line or column chart to show each item and the total quantities for each. Export back into the original Excel Work book. Name the new worksheet Total Quantity. Name the Chart, Total Chart. Add a legend to the chart. Each pie, line or bar will have the values listed. Add vertical and horizontal titles. 6c. Include the two charts for item d and e above in the Excel assignment. Create a tab for each within the same workbook. 7. When finished with HE1 requirements, zip the Word, Access and Excel files and submit to the HE1 tab for grading by the deadline. UMUC/IFSM 300
Background image of page 2
Show entire document
Vendor Name Vendor No. Order No. Item No. Item Description Item Cost Quantity Cost per order A/P Terms Order Date Arrival Date Spacetime Technologies 2 A0111 6489 O-Ring $3.00 900 $2,700.00 25 10/10/08 10/18/08 Spacetime Technologies 2 A0533 9752 Gasket $4.05 1,500 $6,075.00 25 09/20/08 09/25/08 Spacetime Technologies 2 A0555 6489 O-Ring $3.00 1,100 $3,300.00 25 10/05/08 10/10/08 Spacetime Technologies 2 A0622 9752 Gasket $4.05 1,550 $6,277.50 25 09/25/08 10/05/08 Spacetime Technologies 2 A0666 5125 Shielded Cable/ft. $1.15 15,000 $17,250.00 25 10/01/08 10/15/08 Spacetime Technologies 2 A0777 6489 O-Ring $3.00 1,050 $3,150.00 25 10/29/08 11/10/08 Spacetime Technologies 2 A1222 4111 Bolt-nut package $3.55 4,200 $14,910.00 25 09/15/08 10/15/08 Durrable Products 3 A1234 9399 Gasket $3.65 1,250 $4,562.50 45 10/01/08 10/06/08 Durrable Products 3 A1235 9399 Gasket $3.65 1,450 $5,292.50 45 10/03/08 10/08/08 Durrable Products 3 A1344 5454 Control Panel $220.00 550 $121,000.00 45 10/09/08 10/14/08 Durrable Products 3 A1345 9399 Gasket $3.65 1,470 $5,365.50 45 10/07/08 10/12/08 Durrable Products 3 A1346 9399 Gasket $3.65 1,985 $7,245.25 45 10/05/08 10/11/08 Spacetime Technologies 2 A1444 4111 Bolt-nut package $3.55 4,250 $15,087.50 25 09/20/08 10/10/08 Spacetime Technologies 2 A1445 4111 Bolt-nut package $3.55 4,200 $14,910.00 25 09/25/08 10/25/08 Spacetime Technologies 2 A1449 4111 Bolt-nut package $3.55 4,600 $16,330.00 25 10/05/08 10/19/08 Durrable Products 3 A1456 5454 Control Panel $220.00 500 $110,000.00 45 10/15/08 10/20/08 Durrable Products 3 A1457 4569 Bolt-nut package $3.50 3,900 $13,650.00 45 10/05/08 10/10/08 Durrable Products 3 A1567 1369 Airframe fasteners $4.20 15,000 $63,000.00 45 09/25/08 09/30/08 Spacetime Technologies 2 A3467 4111 Bolt-nut package $3.55 4,800 $17,040.00 25 09/05/08 09/20/08 Spacetime Technologies 2 A5689 4111 Bolt-nut package $3.55 4,585 $16,276.75 25 09/10/08 09/30/08 Durrable Products 3 B1234 7258 Pressure Gauge $90.00 100 $9,000.00 45 08/25/08 08/28/08 Durrable Products 3 B1345 7258 Pressure Gauge $90.00 120 $10,800.00 45 09/05/08 09/09/08 Durrable Products 3 B1468 1369 Airframe fasteners $4.20 14,000 $58,800.00 45 09/27/08 10/03/08 Durrable Products 3 B1589 5275 Shielded Cable/ft. $1.00 25,000 $25,000.00 45 10/25/08 10/30/08 Durrable Products 3 B1666 1369 Airframe fasteners $4.20 10,000 $42,000.00 45 09/29/08 10/04/08 Fast-Tie Aerospace 4 B2333 6321 O-Ring $2.45 1,300 $3,185.00 30 08/25/08 09/04/08 Fast-Tie Aerospace 4 B2345 6321 O-Ring $2.45 1,200 $2,940.00 30 09/12/08 09/23/08 Fast-Tie Aerospace 4 B2356 6321 O-Ring $2.45 2,500 $6,125.00 30 09/25/08 10/04/08 Fast-Tie Aerospace 4 B2367 6321 O-Ring $2.45 1,250 $3,062.50 30 10/12/08 10/21/08 Fast-Tie Aerospace 4 B2378 6321 O-Ring $2.45 1,500 $3,675.00 30 10/25/08 11/02/08 Fast-Tie Aerospace 4 B2498 5689 Side Panel $175.00 150 $26,250.00 30 11/01/08 11/09/08 Fast-Tie Aerospace 4 B2499 7268 Pressure Gauge $95.00 110 $10,450.00 30 11/01/08 11/12/08 Fast-Tie Aerospace 4 B2511 7268 Pressure Gauge $95.00 105 $9,975.00 30 11/05/08 11/16/08 Fast-Tie Aerospace 4 B2519 5462 Shielded Cable/ft. $1.05 22,500 $23,625.00 30 08/20/08 08/26/08 Fast-Tie Aerospace 4 B2528 5689 Side Panel $175.00 175 $30,625.00 30 11/05/08 11/15/08 Fast-Tie Aerospace 4 B2537 5462 Shielded Cable/ft. $1.05 21,500 $22,575.00 30 08/15/08 08/22/08 Fast-Tie Aerospace 4 B2566 5462 Shielded Cable/ft. $1.05 23,000 $24,150.00 30 08/10/08 08/15/08 Fast-Tie Aerospace 4 C0234 5166 Electrical Connector $1.25 5,650 $7,062.50 30 10/01/08 10/06/08 Fast-Tie Aerospace 4 C0423 5689 Side Panel $175.00 155 $27,125.00 30 10/25/08 11/03/08 Fast-Tie Aerospace 4 C0433 5462 Shielded Cable/ft. $1.05 22,500 $23,625.00 30 08/25/08 09/02/08 Hulkey Fasteners 1 C1212 1122 Airframe fasteners $4.25 19,500 $82,875.00 30 08/05/08 08/13/08 Hulkey Fasteners 1 C1313 3166 Electrical Connector $1.25 5,600 $7,000.00 30 08/25/08 08/29/08 Hulkey Fasteners 1 C2323 1122 Airframe fasteners $4.25 15,500 $65,875.00 30 09/04/08 09/12/08 Hulkey Fasteners 1 C2929 3166 Electrical Connector $1.25 5,500 $6,875.00 30 09/01/08 09/06/08 Hulkey Fasteners 1 C3232 1122 Airframe fasteners $4.25 18,000 $76,500.00 30 10/01/08 10/08/08 Hulkey Fasteners 1 C3434 1122 Airframe fasteners $4.25 12,500 $53,125.00 30 09/05/08 09/11/08 Hulkey Fasteners 1 C4545 1122 Airframe fasteners $4.25 15,000 $63,750.00 30 09/08/08 09/15/08 Hulkey Fasteners 1 C5656 1122 Airframe fasteners $4.25 14,500 $61,625.00 30 09/28/08 10/03/08 Hulkey Fasteners 1 C6765 5066 Shielded Cable/ft. $0.95 25,000 $23,750.00 30 09/05/08 09/12/08 Hulkey Fasteners 1 C7875 3166 Electrical Connector $1.25 5,650 $7,062.50 30 09/05/08 09/10/08 Hulkey Fasteners 1 C8854 3166 Electrical Connector $1.25 5,425 $6,781.25 30 09/10/08 09/15/08 Hulkey Fasteners 1 C8989 9966 Hatch Decal $0.75 500 $375.00 30 08/25/08 08/31/08 Hulkey Fasteners 1 D1212 5066 Shielded Cable/ft. $0.95 17,500 $16,625.00 30 09/15/08 09/22/08 Hulkey Fasteners 1 D2121 1122 Airframe fasteners $4.25 17,500 $74,375.00 30 10/25/08 11/03/08 Hulkey Fasteners 1 D3232 1122 Airframe fasteners $4.25 17,000 $72,250.00 30 10/11/08 10/19/08
Background image of page 1

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question