In this course students will learn to create Database Queries in Access as well as extensive editing of records, report generation and how to set up the Database Environment. When and how to create multiple database tables are also covered. Students will use the full potential of Access by joining up to three database tables and retrieving selected data. Forms and reports are generated from queries based on joined tables. Macros are introduced as a way to automate many of the daily database functions.
Tuition covers the course handbook and the use of a data disk for all hands-on exercises.
Introduction to MS Access - Office 97 or equivalent work experience. Classes will be held at Center for Employee Development. Map and directions will be included with receipt. This six-hour lab course is designed to introduce relational database management systems. Students will learn the basics of MS Access for Office 2000 including the design of database tables and how to prepare table structures.