Course Outline
Access - Advanced
Versions 97/2000/2002(XP)/2003/2007

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: This course will show the student how to develop an application and tie objects together using a Switchboard, Queries, Reports, Formatting Controls, Macros, and logical functions.

• Creating a Custom Switchboard
• Creating the Main Menu Form
• Linking Buttons to Other Objects
• Making Menu Show When Starting
• Maximizing a Form When it is Opened
• Displaying a Start Up Message
• Importing Data From Excel
• Linking Data Into Access
• Differences Between Importing and Linking
• Queries - Types of Queries
• Queries - Crosstab Queries
• Queries - Action Queries
• Queries - Make-Table Query
• Queries - Delete Query
• Queries - Update Query
• Change History
• Queries - Append Query
• Creating an Archive Table
• Queries - Creating a Query to Append Data
• Running a Query With a Macro

 

• Query Wizards
• Query Wizards - Find Duplicate Query
• Query Wizards - Find Unmatched
• Report Containing Multiple Queries
• Using Access Data in Word
• Macros With Conditions
• Macros - Creating a Sales Tax Macro
• Macros - Multiple Parameters
• Referencing Parameters in Reports
• Formatting Controls
• Formatting Controls - To Fit Property
• Formatting Controls - Size Property
• Formatting Controls - Align Property
• Sorting and Grouping in a Report
• Queries - Parameter Query with Wildcards
• Propagating Controls - Auto Expand
• Changing the Type of Control
• Can Grow and Can Shrink Properties
• Logical Function in Access - IF
• Changing the Starting Value of AutoNumber
• Networking Issues
• Security Issues