Access 2000: Advanced

  • The page you requested does not exist. A search for Link OR Click OR aspx resulted in this page.
  • The page you requested does not exist. A search for Custom OR ELearning OR Curriculum OR Development resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR ELearning OR Resources OR tabid OR 142 OR Blog OR Date OR 2007 OR 11 OR 30 OR Date OR Type OR month OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR Learning OR Center OR Tips OR Traps OR tabid OR 137 OR Blog OR Date OR 2010 OR 06 OR 30 OR Date OR Type OR month OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Link OR Click OR aspx resulted in this page.
  • The page you requested does not exist. A search for Courses resulted in this page.
  • The page you requested does not exist. A search for Link OR Click OR aspx resulted in this page.
  • The page you requested does not exist. A search for Training OR Pricing OR Inquiry resulted in this page.
  • The page you requested does not exist. A search for Desktop OR Modules OR Blog OR Trackback OR aspx resulted in this page.

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