About This Training Course

The skills and knowledge covered in this Access - Level 3 (Turning Ordinary Databases into Extra-Ordinary Databases) Training Course are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access 2003.

Subjects Covered

"
ÿ Splitting A Database
• Using The Database Splitter
• Working With A Split
Database
• Updating Database Links
ÿ Database Security
• Understanding Database
Security
• Creating A Workgroup
• Creating An Administrator
• Removing The Default Admin
User
• Logging On As The System
Administrator
• Securing A Database
• Adding Groups
• Adding Users
• Assigning Permissions
• Testing Database Security
• Joining Another Workgroup
ÿ Database Replication
• Understanding Database
Replication
• Creating A Replica
• Creating Additional Replicas
• Creating A Partial Replica
• Synchronising To A Replica
• Synchronising From A
Replica
• Synchronising To A Partial
Replica
• Aggregate Queries
• Creating An Aggregate Query
• Working With Aggregate
Queries
• Creating Queries With
Multiple Aggregates
• Modifying Aggregate
Headings
• Aggregating Calculated
Fields
• Applying Criteria To
Aggregates
• Creating A Query To Nest
• Creating An Aggregate From
A Query
ÿ Data Access Pages
• Creating A Data Access Page
• Applying Themes To Data
Access Pages
• Working With Data Access
Pages
• Using A Data Access Page
Outside Access
ÿ Data Access Page Techniques
• Creating A Data Access Page
Design
• Promoting And Demoting
Fields
• Working With Data Access
Page Fields
• Displaying Related Records
• Formatting A Pivot Table List
• Adding Columns To A Pivot
Table List
• Creating A Scrolling Marquee
• Formatting A Page
ÿ Macro Basics
• Macros Versus VBA
• Creating A Macro
• Running A Macro
• Modifying An Existing Macro
• Interacting With The User
• Documenting Macros
ÿ Macro Techniques
• Creating A Print Macro
• Using Conditions To Enhance
a Macro
• Creating A Sequence Of
Conditions
• Using The MsgBox Action
Statement
• The MsgBox Function
• Using MsgBox In A Condition
• Reconfiguring A Message Box
• Using The InputBox Function
ÿ Macros On Forms
• Creating An Event Macro
• Creating A Group Macro
• Attaching Macros From A
Group
• Creating A Group Macro For
Forms
• Attaching Macro

Training Course Outcomes

"At the completion of this Access - Level 3 (Turning Ordinary Databases into Extra-Ordinary Databases) Training Course, participants will be able to:
Split the tables from a database file
Create and maintain multiple copies of a database file
Create aggregated queries
Create a data access page
Create data access pages using the Design View
Create a macro for an option group to provide instant filtering
Write a simple procedure in VBA."

Prerequisites

This Access - Level 3 (Turning Ordinary Databases into Extra-Ordinary Databases) Training Course assumes that you can create a database file, store and manage data. It would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.

Other Information

"Advanced Training provides a range of computer training solutions offering flexible delivery methods, a cost effective approach, smooth implementation and an exceptional level of quality service.

Advanced Training Locations:

• Queen Street, Melbourne - Victoria
• Moore Street, Turner - Canberra
• York Street, Sydney - New South Wales
• Church Street, Parramatta - New South Wales
• Astor Terrace, Spring Hill - Brisbane, Qld
• Innovation House, Mawson Lakes - South Australia
• Patrick Street, Hobart - Tasmania
• St George's Terrace, Perth - Western Australia "