CS 100 Databases

Unit 2: Manipulating the Data in a Database

Objectives

At the end of this unit you will be able to:

• Sort and filter data.
• Create a query.
• Understand how queries are used in practice.

Lecture

Manipulating the Data in a Database

Skills

This unit's objectives are the following database skills:

• Lesson 4: Sorting and Filtering Records
• How do you sort records in Datasheet view?
• How do you filter records by selection?
• How do you filter records by form?
• Lesson 5: Creating a Database Query
• How do you create a query from a single table?
• How do you run a query?
• How do you create a query from multiple tables?
• How you specify sort order and selection criteria in a query?

Concepts

An understanding of certain concepts is necessary to succeed in the lessons. The following concepts are defined where applicable in the lesson text. You may also click on any concept listed here to see it defined.

1. What is a filter?
2. What are the different filter types in Microsoft Access?
3. Why would I want to sort records?
4. What is a query?
5. What role do queries have in good database design?
6. How is a query different from a filter?
7. What is a range of values?
8. What is a compound query?

Self-Check

Do you know how you can use a query? The following self-check will test your understanding of this and other concepts:

• DB Self-Check #2

Assignment

You must complete the following assignment associated with the lessons above to receive credit for this unit:

• Database Assignment 2

Copyright 1997 by the Curators of the University of Missouri