Overview
In this assignment you create a database for a non-profit organization that connects teenagers with temporary jobs such as babysitting and yard work. The data is already in a workbook, so you will be import all the data from Excel, modifying the resulting tables, create a relationship, and create some queries.
You need a version of Access that can handle the .accdb file format (which is the default file format for Access 2010 and later). If you need a copy of Access and you have a Windows computer, then you can get a copy as part of the DreamSpark program that Kishwaukee CIS is a part of. What that means is that students currently enrolled in an active qualifying CIS course can download, install, and use a full copy of Access for their personal non-commercial use on their personal computer. You should have been sent an invitation to register for DreamSpark early in the semester. It was sent to your student email account. Contact the instructor if you have questions about DreamSpark.
This problem uses a number of features of Access and it is expected that there will be questions. Keep in mind that the CIS 123 website has a FAQ sheet for using Access, there will be a demonstration of Access in one of the optional class sessions, and there are many tutorials on how to use specific features in Microsoft Access on the Web. This is particularly useful if you want a question answered quickly outside of class time and you don't have an Access reference at hand.