Microsoft Access Queries
Creating and Using a Database (Cont'd)
and Quering the Database
Lesson 7
Class Objectives:
Students will have mastered the material in this project when they can:
- Describe databases and database management systems
- Start Access
- Describe the features of the Access desktop
- Create a database
- Create a table and add records
- Close a table
- Close a database and quit Access
- Open a database
- Print the contents of a table
- Create and use a simply query
- Create and use a simple form
- Create and print a custom report
Lecture/Lab: (You need to be enrolled in Ecourse to view demos)
View the following demo tutorial: Querying a Database
Practice Exercises from Book:
(Once you get your book, download exercise files here.)
- Access Chapter 2 - Lab 1 - Steps 1-7 - Query the JMS TechWizards Database, PG AC 131
- Access Chapter 2 - Lab 2 - Steps 1-9 -Query the Hockey Fan Zone Database, PG AC 132
- Access Chapter 2 - Lab 3 - Part 1 and 2 - Query the ADA Beauty Supply Database, PG AC 134
Assignment:
- Reading - Read AC4 - AC7 and AC50-AC53