Access 2000: Advanced

Course Specifications:

Courseware: Access 2000: Advanced

Software: Microsoft Access 2000

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Course Objective:

Students will learn how to analyze data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros, and become familiar with Internet-related Access tools.

Target Student:

Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.

Prerequisites:

To ensure the successful completion of Access 2000: Advanced, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

  1. Access 2000: Introduction
  2. Access 2000: Intermediate

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Parameter and action queries

  1. Topic 1A: Creating parameter queries
  2. Topic 1B: Creating action queries

Lesson 2: Query joins and crosstab queries

  1. Topic 2A: Joining tables and working with join properties
  2. Topic 2B: Creating crosstab queries
  3. Topic 2C: Editing limitations in query datasheets

Lesson 3: Using advanced form techniques

  1. Topic 3A: Organizing field placement
  2. Topic 3B: Using functions to control data entry
  3. Topic 3C: Adding an option group to a form
  4. Topic 3D: Using a form as the user interface
  5. Topic 3E: Creating a form that contains a subform

Lesson 4: Creating basic macros to automate forms

  1. Topic 4A: Macro basics
  2. Topic 4B: Attaching a macro to a command button
  3. Topic 4C: Revising a macro
  4. Topic 4D: Attaching a macro to an event in a form

Lesson 5: Using macros to provide user interaction and automate tasks

  1. Topic 5A: Using a macro to provide user interaction
  2. Topic 5B: Using macros to automate data entry
  3. Topic 5C: AutoKeys and AutoExec macros

Lesson 6: Using advanced report techniques

  1. Topic 6A: Customizing the appearance and functionality of a report
  2. Topic 6B: Mailing and other types of labels

Lesson 7: Access 2000 and the Internet

  1. Topic 7A: Using hyperlinks
  2. Topic 7B: Access tools for working on the Internet