Skip Maine state header navigation

Agencies | Online Services | Help

ACCESS Level II

(formerly Access Design I)

Cost:  $315.00


For those planning to write databases

PRE-REQUISITES: Complete comfort with file management in Windows Explorer, experience with an Access database (such as the NorthWind database in Office10\Samples), or completion of the Level I course.


(two day course)

October 22 & 23, 2008

November 17 & 18, 2008

Time Location
9 - 4

Computer Training Lab (rm 104)

Cross Office Building

Course Objective: You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications.

Performance-Based Objectives


Upon successful completion of this course, you should be able to:

  • 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.


Target Student: Microsoft® Access 2003: Level 2 is designed for the person who wishes to learn intermediate-level operations of the Microsoft® Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft® Word or Excel. This is a prerequisite to taking more advanced courses in Access 2003.

Enrollment Form


Updated 12/07