Skills 2 Final Exam Review

Back

Access Review

  1. Go to files to copy in the skills 2 folder. Copy/paste the "inventory" folder to your Thawspace.
    • Zip folder available here if working from home
  2. Create a new database and name it last-first-inventory.mdb and save it in this inventory folder.
  3. Create the table named "furniture" using the image in inventory folder called inventory table design.jpg
  4. Open the Excel spreadsheet inventory-data.xls from the inventory folder.
  5. Copy/paste this data from the spreadsheet into your "furniture" table.
  6. Build the following queries:
    a) All fields and records - sort by date added
    b) All fields, find all lamps, sort by quantity
  7. Build a report for each query
  8. Copy/paste the database into the submissions folder when complete

 

Excel Review

  1. Using your 1st query from above, copy/paste the data into Excel
  2. Save the spreadsheet as: last first inventory -stats.xls
  3. Add 3 columns, Total Store Cost, Total Retail Value, and Profit
  4. Find theTotal Store Cost for each row (quantity*store cost)
  5. Find the Total Retail Value for each row (quantity*retail value)
  6. Find the Profit (Total Retail Value - Total Store Cost). This is how much money the store makes for each item of furniture.
  7. Find the totals under each column, Total Store Cost, Total Retail Value and Profit
  8. Build a bar or column graph comparing FURNITURE to PROFIT
    • Make sure this graph clearly shows:
      • Item that makes the most profit (and by how much)
      • Item that brings in the least (and by how much)
  9. Once you are done, UPLOAD YOUR COMPLETED SPREADSHEET TO GOOGLE DOCS
    • How did it turn out? Did the graphs come thru too?
    • Share this document with me
      • adkins_doug@spraguehs.com
  10. Open the auto-filter in the data page and sort data in various ways. Look at the graph when you are done.
  11. Filter for any lamp (it will require a custom filter). Check the graph when you are done.
  12. In class we will review the subtotal process as well.
    • Open your clothing sales spreadsheet and review the subtotal process
    • On the final if you can remember how to use the subtotal, it will save you a lot of work!!