MIS 300 Midterm (Take-Home)

Your exam is about finishing "Practice" from below each link. That is, you need to do the "Practice" from each link and then save it. Create a folder and store all the finished "Practice" in the folder. Then, create a compressed file (zip file) using the folder and submit thru the WebCT midterm exam submission link.

If there is any "Practice" that only requires to explore, you do not need to save and submit it.

You must turn in the midterm from Oct 21 (1:00am) Oct 24 (11:00pm).

Database Essentials

  1. Create tables for a new Access 2007 database
  2. Build relationships for a new Access 2007 database
  3. Create forms for a new Access 2007 database
  4. Create reports for a new Access 2007 database
     

Query Generation

  1. Queries I: Get started with queries
  2. Queries II: Create basic select queries
  3. Queries III: Use expressions and other criteria
  4. Queries IV: Use functions and calculated fields in your queries
  5. Queries V: Use "And", "Or", and "In" to set multiple conditions
  6. Queries VI: Use wildcards in queries and parameters
  7. Queries VII: Query multiple sources for data
  8. Queries VIII: Dealing with ambiguous joins