Access Projects for MIS 213

Using Horizon (for MAC Users)
and PC users without Access on their machines


Videos to Help with Access Projects (modify your data entries to match the PDF and not the video data)

Project 2 - Build your first Tables and Queries  (Employee Names and Compensation)


  • Complete the instructions for Steps 1 to 45 only (end of page A-29).

  • Click here to download the Project 2/3/4 Tutorial PDF (note: you will not complete the entire PDF guide for Project 2)
  • For MAC users and PC users without Access, see the Guide for using Horizon
  • Do not delete your file when done as you will need it for projects 3 and 4.
  • Remember you can submit your project early for pre-grading!

Project 3 - Additional Queries (use your Project 2 database)


  • Complete the instructions for Steps 46 to 58 (end page A-35).

  • From the PDF you downloaded for Project 2, complete the Additional Queries portion.
  • Use your database from Project 2 as your starting Access file
  • First correct your tables for any feedback received in Entropy for Project 2. (You do not need to correct the queries).
  • Upload your completed database (.accdb) file to Entropy for Grading.
  • Again save this file for future use in Project 4.

Project 4 - Reports and Forms (use your Project 2 database)


  • Complete the instructions for Steps 59 to 92 (ends top of A-49).

  • From the PDF you downloaded for Project 2, complete the Input Forms and Reports portions.
  • Use your database from Project 2 as your starting Access file
  • Note: You do NOT need to do Section A.6.4 on Additional Formatting starting on page A-49.
  • Upload your completed database (.accdb) file to Entropy for Grading.

Project 5 - Download a new Database and Create New Queries