Who Done It? 

You are the local official for the area and you just learned how to use Microsoft Access.  You decided to create a database of known trouble makers in your district (just in case).  You will use the information you have entered into Microsoft Access to help solve a case of Who Done It.  You will be given a collection of information about trouble makers that you will include in the database, and it is your job to search the database to find out "Who Done It!"

To get started with this project, you must first create the database.  As you may recall from the Football database, one of the first steps to creating a database is saving it.  Save this database in your Access Folder with your last name followed by Who Done It, for example Jansen - Who Done It.  If you need assistance with the creation of a new Access database follow the links provided earlier. 

Click here to begin creating your database!

The next step is to create a form to put the trouble maker information in to.  Include all of the fields you created above and feel free to arrange the form in a manner that will make input easiest for you.  Then, input the trouble maker (aka - suspect) information into the database, using the form that you created.  Be sure to pay attention to detail so when try to determine "Who Done It" accurate information is being accessed from your database.

Click here to enter the suspects!

It is now time to determine Who Done It!  Follow the link below and read through the scenario.  Using your trouble maker database, you will create a query to do the detective work for you!  Remember to include all the important details in your query so that you get accurate results.  You will then report your results to the Chief Detective using a Word document to summarize your results.  Since you are hoping for a promotion, be sure to impress the boss...

Click here to begin solving the case!