| Class Outline |
|
 |
Information &
Technology Services
Faculty and Staff Training |
Building Queries with Access
Once you have built your Microsoft Access database and it is populated
with data, you will need to create
queries in order to select records for
analysis or update. This class will teach you how that create queries to
select and/or update records.
Length:
2 hours |
Book:
Quick Reference Card
Optional Reference Book
Microsoft Access 2002 Illustrated Complete
0-6190-4508-6 |
Prerequisite Class or Equivalent Knowledge:
Get to Know Your Computer
Understand the Windows Desktop
Get Started Building Databases in Access
Create Tables in Access |
Course Content
Creating Multiple Table Queries
-
Understanding Table Relationships
-
Creating Select Queries
-
Using Query Wizard
-
Using Query Design view
-
Sorting a query on multiple fields
- Calculating values in queries
|
|
|
 |
