CS105 Access Lab



In this lab you will use an existing access database containing a simplified college record set. You will import records, updating existing records, add forms, write queries and generate reports from those queries. Because several of you are management students, and one of the duties of lower level management is to translate between the plain every-day speech of a customer or upper manager and the formal capabilities of the tools you are using (access in this case) I have given you your task in plain english, and then given you hints and some instructions for doing the task in access afterwards.


Data Analysis:

Your supervisor, an administrator at the college, has asked you to work up an analysis of the data to answer some questions asked by the Deans of the college. You are asked to write up a quick summary report in Microsoft word that answers the questions in brief, and then gives the name of the query or report in the database to use in case the supervisor needs to see more information. You need to answer the following questions:

  1. Which courses are least popular (which courses have the lowest enrollment) if there is more than one course with the same low enrollment, list them all.
  2. Which courses are the most popular, list at least the top 3, including any ties. (feel free to cut and paste these name if you like.)
  3. Which courses make the college the most money this semester. Show at least the top 3 money makers and any ties.
  4. According to the post-september 11 international student rules, the college must keep a list of all foriegn exchange students. Please make a report including all such students, ordered by last name, and mention it in the summary document.
  5. Since the registrar's office is busy, you have been asked to help generate some of the class lists. Please generate the class lists for the following courses (using the actual course names, so that the Deans can read the report:

If your first name begins with: