Homework 16 - Access2 - Homework 16 CS131 – Summer ‘08...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 3

Homework 16 - Access2 - Homework 16 CS131 – Summer ‘08...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online