During the Spring 2010 term, we were asked to use Microsoft Access 2007 to create a database to manage skating lessons, instructors, students, students’ progress throughout various levels, and much more.  Each level requires that a student pass a variety of skills.  Just for fun,we used the names of Vancouver Canucks players for the students.  This project taught us how to properly set up relationships between various fields as well as build forms, reports, queries, switchboards, and more.  The image above displays one of many screens in the database – this screen is meant for selecting a student and seeing which levels he/she has completed, as well as how much revenue has been generated by that student, and how many levels have been attended.

Information on the project requirements can be found here.

You may click the following download icon to take a look at the Microsoft Access database, and you may also read the documentation in PDF format here.

Please note: When you download the database, you will receive a .DOCX (Microsoft Word format file) instead of the expected .ACCDB (Microsoft Access format).  Please rename the file extension to .accdb when reading it.  This blog has security settings which do not allow an .accdb file to be upload, so the file extension had to be changed.