MEA - MidAtlantic Employers' Association

PUBLIC SEMINARS

Back

COMPUTER SKILLS

Access 2003: Level 2^ - ONSITE ONLY

Description

Please contact MEA if you are interested in having our expert staff conduct this workshop on-site at your location for several of your employees. When we deliver a workshop on-site at your location, we will customize the course to meet your needs as part of our fee. If you would like to discuss your company's on-site needs with an MEA professional, please contact us at (800) 662-6238 or e-mail training@meainfo.org.

In this course you will learn how to design and create a new Access database, how to customize database components such as tables, queries, forms and reports, and how to share Access data with other applications.

Topics

Follow the steps required to properly design a simple database

Create a new database with related tables

Control data entry by modifying the design of a table to streamline data entry and maintain data integrity

Find and retrieve desired data by using filters and joins between tables and within a single table

Create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries

Enhance the appearance, data entry, and data access capabilities of your forms

Customize reports to better organize the displayed information and produce specific print layouts such as mailing labels

Use Access data in other applications, including Microsoft Word and Excel

^MEA is approved by the Pennsylvania Department of Education as a provider for Act 48 activity hours. This program has been approved for 6 credit hours.