This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Homework 16 CS131 – Summer ‘08 This assignment continues where Lab 16 left off, with a couple examples of advanced queries 1. Open up your access database from Lab 16 2. First, we’ll populate the tables a bit more. a. Enroll yourself and two students into different classes (not cs131) for the Fall 2008 term. Save the database b. If you go to the Fall 2008 query, you will notice that the query we created earlier did not update. Lets fix that c. Go to design view for the query, then under “Query Tools->Design”, hit Run in the Results group. This will update the query d. Save a screenshot of the updated “Fall 2008 Classes” query in datasheet view 3. Now we want to count the number of students taking each class. We will use the COUNT function (refer to Chapter 13, Objective 14) a. Toggle “Totals” under Query Tools -> Design. At the bottom a “Total” row now shows.Toggle “Totals” under Query Tools -> Design....
View Full Document
This note was uploaded on 02/22/2010 for the course CMSY 103 taught by Professor N/a during the Fall '06 term at Howard County Community College.
- Fall '06