Microsoft Access Queries
Creating and Using a Database (Cont'd)
and Quering the Database
Week 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:
Review the Introduction to databases presentation. In class demo on how to create and use a database in Microsoft Access or view the following presentation: Create an Access Database for a Client
Lab/Hands On:
- 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
Homework:
- Reading - Read AC4 - AC7 and AC50-AC53
