Assessment Description: Please see the attachment file below. Thank you
FINAL PROJECT This project has two parts, you will be using Microsoft Excel, Access and Word to complete. Total for both parts is 50 points. -5 points for each error/omission of a completed step. When you are done with BOTH parts, attach and submit for grading in the Final Project link in Course Content. Part I – Importing MS Excel into MS Access You have an in -home hobby business, which has taken off very quickly. Your inventory and vendor information are in Excel spreadsheets but you are at the point that you need to move your information into an Access database. You want your information to be more consistent and easier to find. Your tasks include importing two existing worksheets from Excel as tables, additionally you will modify tables , creating queries , a form, and report. Both the Toys and Vendors workbooks are available open are availabl e in the Final Project Link in Course Content. Set up the Database File and Import the Excel Worksheets To start, you will need to create a database. You will be importing two tables from Excel, Toys and Vendors. The first field in both will be the pri mary key. a. Open Access. Create a database with the name Final Project Part I_YourFirstnameLastname.accdb. b. Import the Toys file from Excel using the External Data Ribbon. First row contains column headings. Choose Stock Number as the primary key and all other defaults including the Table Name Toys. c. Import the Vendors file from Excel. First row contains column headings. Choose Vendor ID as the primary key and all other defaults including the Table Name V endors . d. Delete Table 1 . Modify the Table Open the Toys table in design view. Verify the information below. Make any changes necessary. Save the structure of the Toys table. Field Name Data Type Field Size Stock Number Short Text 10 Description Short Text 20 Inventory Number Integer Cost Currency Selling Price Currency Vendor ID Short Text 4 No changes need made to the design of the Vendors Table. Create and Modify Data in a Form Create a form for the Toys table using the Form Wizard . Use all the defaults of creating the form in the Form Wizard. Add the following two records: 06598726 05987563 Dogs and Cats Puzzle Zoo Animals Puzzle 4 5 9.00 9.00 12.50 12.50 WT36 TT96 In either the form or the table, c hange the selling price of the Colored Shape Blocks to $75.00 and the Sports Car $20.00. Change the name of the form to Toys Inventory . (you cannot rename the Form if it is open) Creating Queries Create the following queries: a. Create a new query using the Toys table. Include the Stock Number, Description, Inventory, and Selling Price for all records. Sort by selling price in descending order. Save the query as Toys Query . b. Using the Toys table, create a query in design view. Display the Stock Number, Description, Cost, and Vendor ID for all products w hose Vendor ID is TT96 (CRITERIA UNDER Vendor ID) . Do not display the Vendor ID field. Save the query as TT96 Toys . c. Using the Vendor table, create a query that displays only the Vendor Name and Phone numb er. Save the query as Vendor Contact Number s. When you return to data sheet view, widen fields so all da ta is visible. Create a Report Use the Report Wizard to create a Report based on the Toys Table, have the fields Vendor ID , Stock Number, Description, and Inventory (in that order). Group by Vendor ID and use all other defaults of the Report Wizard . Save the report with the default name, close the report and then rename the Rep ort Toys by Vendor. Part II – Formatting a Brochure using MS Word For this part, you will be using Microsoft Word to make a brochure with 2 columns. Format the document as outlined in the instructions. Ignore any words that are coming up as misspelled. The Wonders document you need to open is available in the Final Project Link in Course Content. Open Wonders and save as Final Project Part II_YourFirstnameLastname. docx 1) Select the entire document and change the font and size to a readable font of your choice, 12 pt. 2) Change Paragraph Spacing after to 0 pt. 3) Set Line Spacing to 1.5” 4) Apply Heading 3 Style to all side headings. The first one is Ha Long Bay and the last on e is with Grand Canyon . There are 10 total side headings. 5) Change top, bottom, left and right margins to .75 . 6) Apply Heading 1 Style to the title Top 10 Natural Wonders of the World and Heading 2 Style to the text by Your Name . Center both lines after Heading Styles are applied. Replace Your Name with your actual first and last name. 7) Underline and bold the text: The Original Seven Wonders of the Ancient World , The Se ven Wonders of the Modern World , and The Seven Natural Wonders of the World. 8) Bullet the lists after The Original Seven Wonders of the Ancient World , The Seven Wonders of the Modern World , and The Seven Natural Wonders of the World with a bullet of your cho ice (you must change it, not use default bullet circle). Have all bullets in these three lists be the same. 9) Select the text starting with Our world is full of (beginning of first paragraph of document) and ending at the end of and made pilgrimages to it . (at end of document before three lists). Put this selected text into two columns with a line between. Keep all other defaults. 10) Place a hard page break at the beginning of Other Wonders of the World so it starts on a new page. 11) Apply Heading 1 Style to t he title Other Wonders of the World and then center it. 12) Insert a Page Number at the bottom center . 13) Look through the side headings in the text in the col umns. Pick two of the side headings (whichever two you want) and find an online image you can insert. Insert the image within the paragraph it represents, reduce its size so it looks good (probably no more than 1” by 1.5” or so) and use word wrap tight. Put the image for each in the top right of the beginning of the paragraph it represents.(For example if I want to use Iguazu Falls; I would go to Insert, Online Pictures, then in the search bar I would type Iguazu Falls, then pick one of the images that comes up.) Make sure there is no text on the right of the image. 14) Look at your page endings and column endings, make sure no side heading is at the bottom of a column with its text starting at the top of the next column. If you find one, just push the Ente r at the beginning of the side heading to move it down. 15) Apply a page border to the whole document with the Style that has three thin lines. End Instructions
