Access 2000: Advanced
Course length: 1 day
Course description
Overview: Students will build upon the
skills learned in Access 2000: Level 1
and Access 2000: Level 2, learning
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. This course meets the Microsoft Proficiency
Guidelines for Microsoft Access at the Expert level.
Prerequisites: To ensure your continued success,
students must have first completed the 
Software Training courses, Access 2000: Level 1 and Access 2000: Level 2 or have extensive
equivalent knowledge, and have a basic understanding of your computer's operating
system, and the Internet. For example, you should know how to launch an application,
create and save files, and copy files from CDs and other media. The
classes, Windows 98: Introduction, and Internet Explorer 5.x are designed to teach
these skills, though they are not required.
Delivery method: Instructor-led,
group-paced, classroom-delivery learning model with structured hands-on
activities.
Benefits: 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.
What's next: Access 2000: Introduction to Application Development, the next
course in this series, teaches students how to develop custom applications by
using Access.
Performance-based objectives
Lesson objectives help students become comfortable
with the course, and also provide a means to evaluate learning. Upon successful
completion of this course, students will be able to:
- Make
select queries more versatile and useful by using parameters; use action
queries to update data values and add or delete records.
- Generate
different query types by creating various types of joins between tables;
use crosstab queries to summarize data.
- Use
advanced form features including properties, functions, and design tools
to facilitate data entry and improve accuracy in forms; display table
information that has a one-to-many relationship by creating forms that
contain subforms.
- Automate
tasks by creating macros to open forms and control form properties.
- Make
forms more functional by using macros to provide user interaction and
automate data entry.
- Make
reports more concise and easier to understand by using properties and
functions in report controls.
- Use
Internet-related Access tools by inserting hyperlinks and using the Web
toolbar; integrate Access data with other Office 2000 applications.
Lesson 1: Parameter and Action Queries
Creating Parameter
Queries
Creating Action
Queries
Lesson 2: Query Joins and Crosstab
Queries
Joining Tables and
Working with Join Properties
Creating Crosstab Queries
Editing Limitations in
Query Datasheets
Lesson 3: Using Advanced Form Techniques
Organizing Field
Placement
Using Functions to
Control Data Entry
Adding an Option Group
to a Form
Using a Form as the
User Interface
Creating a Form that
Contains a Subform
Lesson 4: Creating Basic Macros to Automate Forms
Macro Basics
Attaching a Macro to a
Command Button
Revising a Macro
Lesson 5: Using Macros to Provide User Interaction and Automate
Tasks
Using a Macro to
Provide User Interaction
Using a Macro to
Automate Tasks
AutoKeys and AutoExec
Macros
Lesson 6: Using Advanced Report Techniques
Customizing the
Appearance and Functionality of a Report
Lesson 7: Web Capabilities and Data Integration
Using Hyperlinks
Data Integration
Appendix A: Replicating Databases
Appendix B: Encrypting Databases
Appendix C: Mailing Labels