Access 2003: Advanced (Model 2001)

Overview

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.

Prerequisites

To ensure your success with this course, we recommend that you first take the following Element K Content courses or have equivalent knowledge:

Access 2003: Level 1

Access 2003: Level 2

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; create mailing labels.
Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar

Hardware/software required to run this course

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:

This book was written for the Windows XP platform.
A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. (300 MHz is recommended.)
A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.
128 MB of RAM.
A 5 GB hard disk or larger, if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
A 3 GB hard disk or larger, if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
A floppy-disk drive.
A mouse or other pointing device.
An 800 x 600 resolution monitor.
Network cards and cabling for local network access.
Internet access (see your local network administrator).
A printer (optional).
A projection system to display the instructor's computer screen.
Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.
Microsoft Office Professional Edition 2003.

Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course duration

1 Day(s)

Course outline

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
Attaching a macro to an event in a form

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

Using a macro to provide user interaction
Using macros to automate data entry
AutoKeys and AutoExec macros

Lesson 6: Using advanced report techniques

Customizing the appearance and functionality of a report
Mailing and other types of labels

Lesson 7: Access 2000 and the Internet

Using hyperlinks
Access tools for working on the Internet

Appendix A: Replicating databases

Replicating databases

Appendix B: Using Access with other applications

Linking and importing data
Using the OfficeLinks tool