Lab #1:  Database Generation from Chapter 1

Date:    Thursday, September 7, 2006
Due:     Thursday, September 14, 2006

Our first lab assignment is to use Microsoft Access to produce the University database from Chapter 1 of the textbook (Figure 1-1 on page 4).  Create relations (i.e. tables) for each entity and populate these tables with the data contained in Figure 1-1.  Then use the Queries capability of Access to construct a query that produces a result that displays the student's name, the course and their grade for that course.  The Query Wizard is probably the easiest way to generate a query without knowing SQL.

Once you've produced a successful grade query, use the Report Wizard to generate a grade report.  Both queries and reports are based on SQL.  In future labs we will investigate doing these same steps entirely in SQL.

The details of how to use Microsoft Access for this purpose will be explained in class.  When you have your database working properly, save your work as a Microsoft database file (*.mdb format), zip it up into a *.zip file, and email it as an attachment to me at blessing@msoe.edu.  Be sure to zip your database files before sending them, since they compress well and large attachments are removed from our Email server.