Course advisor's notes

This one day seminar looks further into Microsoft Access and will increase your skills in using this program. More information...

Email a friend

 

Seminar Content | Access Advanced

Parameter and Action Queries.
Query Joins and Crosstab Queries.
Using Advanced Form Techniques.
Creating Basic Macros to Automate Forms.
Using Macros to Provide User Interaction and Automate Tasks.
Using Advanced Report Techniques.
Web Capabilities and Data Integration.
Replicating Databases.
Encrypting Databases.
Mailing Labels.

Aims and Objectives

Make select more versatile and useful by using parameters; and use action queries to update data values and add or delete records.
Generate different query types by creating various types of joins between tables; and use crossstab queries to summarize data.
Use advanced form features including properties, functions, and design tools to facilitate data entry and improve accurancy in forms; and display table information that has a one-to-many relationships 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; and integrate Access data with other Office applications.

Target Audience

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

Prerequisites

To ensure your success with this course, we recommend that you first take an Element K Access content courses or have equivalent knowledge of this software.

Seminar Code

076402

::adCenter::