Midterm and Begin Microsoft Access
Week 6
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)
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: Creating and Using a Database
Practice Exercises from Book:
(Once you get your book, download exercise files here.)
- Access Chapter 1 - Lab 1 - Create the JMS TechWizards Database, PG AC 67
- Access Chapter 1 - Lab 2 -Create the Hockey Fan Zone Database, PG AC 68
- Access Chapter 1 - Lab 3 - ADA Beauty Supply Database, PG AC 69
Assignment/Reading:
- Reading - Read AC2 - AC6 on Database Creation and AC6-AC23 on Designing a Database.