Course Length:

1 Day

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.

Who Should Attend:

This course is for students wishing to learn the advanced features of Microsoft Access.

Benefits of Attendance:

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

Prerequisites:

To ensure your success with this course, we recommend that you first take the following courses or have equivalent knowledge: Access 2003: Level 1 and Access 2003: Level 2.

Course Outline:

• Parameter and action queries
  1. Creating parameter queries
  2. Creating action queries
• Query joins and crosstab queries
  1. Joining tables and working with join properties
  2. Creating crosstab queries
  3. Editing limitations in query datasheets
• Using advanced form techniques
  1. Organizing field placement
  2. Using functions to control data entry
  3. Adding an option group to a form
  4. Using a form as the user interface
  5. Creating a form that contains a subform
• Creating basic macros to automate forms
  1. Macro basics
  2. Attaching a macro to a command button
  3. Revising a macro
  4. Attaching a macro to an event in a form
• Using macros to provide user interaction and automate tasks
  1. Using a macro to provide user interaction
  2. Using macros to automate data entry
  3. AutoKeys and AutoExec macros
• Using advanced report techniques
  1. Customizing the appearance and functionality of a report
  2. Mailing and other types of labels
  3. Using hyperlinks
  4. Access tools for working on the Internet