Microsoft Access Advanced Course Overview

• Split the tables from a database file
• Completely secure a database file and its objects so that unauthorised access is
• Prevented
• 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 simple macros
• Use conditions in macros
• Create macros that used with forms
• Create a macro for an option group to provide instant filtering
• Write a simple procedure in VBA

Specific Topics: Microsoft Access Advanced Course

Splitting a Database

1. Using the Database Splitter
2. Working with a Split Database
3. Updating Database Links

Database Security

1. Understanding Database
2. Security
3. Creating a Workgroup
4. Creating an Administrator
5. Removing the Default Admin
6. User
7. Logging on as the System
8. Administrator
9. Securing a Database
10. Adding Groups
11. Adding Users
12. Assigning Permissions
13. Testing Database Security
14. Joining another Workgroup

Database Replication

1. Understanding Database
2. Replication
3. Creating a Replica
4. Creating additional Replicas
5. Creating a Partial Replica
6. Synchronising To a Replica
7. Synchronising From a Replica
8. Synchronising To a Partial Replica

Aggregate Queries

1. Creating an Aggregate Query
2. Working with Aggregate Queries
3. Creating Queries with Multiple Aggregates
4. Modifying Aggregate Headings
5. Aggregating Calculated Fields
6. Applying Criteria to Aggregates
7. Creating a Query to Nest
8. Creating an Aggregate From a Query

Data Access Pages

1. Creating a Data Access Page
2. Applying Themes to Data Access Pages
3. Working with Data Access Pages
4. Using a Data Access Page
5. Outside Access

Data Access Page Techniques

1. Creating a Data Access Page Design
2. Promoting and Demoting Fields
3. Working with Data Access Page Fields
4. Displaying Related Records
5. Formatting a Pivot Table List
6. Adding Columns to a PivotTable List
7. Creating a Scrolling Marquee
8. Formatting a Page

Macro Basics

1. Macros Versus VBA
2. Creating a Macro
3. Running a Macro
4. Modifying an Existing Macro
5. Interacting With the User
6. Documenting Macros

Macro Techniques

1. Creating a Print Macro
2. Using Conditions to Enhance a Macro
3. Creating a Sequence Of Conditions
4. Using the MsgBox Action Statement
5. The MsgBox Function
6. Using MsgBox an A Condition
7. Reconfiguring a Message Box
8. Using The InputBox Function

Macros on Forms

1. Creating an Event Macro
2. Creating a Group Macro
3. Attaching Macros From a Group
4. Creating a Group Macro For Forms
5. Attaching Macros to Form Events
6. Setting Form Properties
7. Testing Form Property Changes

Option Groups and Macros

1. Testing a Sample Option Button Macro
2. Creating an Option Group
3. Copying Toggle Buttons
4. Option Group Properties
5. The ApplyFilter Macro Action
6. Creating a Filter Macro Using the ApplyFilter Macro Action
7. Handling Exceptions Attaching a Macro to an Option Group

VBA Introduction

1. Introductory VBA Terminology
2. Writing a Simple Form Procedure
3. Examining a Simple Sub Procedure
4. The MsgBox and InputBox Functions
5. Editing an Existing Procedure
6. Creating a Standard Module
7. Project - Loan Simulator Code
8. Testing the Code
9. Modifying a Module
10. Creating a Button on a Form
11. Running a Procedure from a control
12. Navigating the VBA Editor

Printable Brochure
Self-Assessment Checklist
Request More Information