Microsoft Access Level 3 Course Duration: 1 Day
Course Overview
During this intermediate/advanced training day we concentrate on Macros, Database Utilities, Security, and create a Switchboard. Prerequisites: Candidates should have ideally attended Access Level 1 & Level 2 training or have equivalent working knowledge before attending this Access intermediate/advanced training day.
Course Content
Understanding Macro and trust settings
Macros
- Creating, editing, and deleting Macros
- Understanding events
- Macro Actions
- Safe vs. Unsafe macro actions
- Submacros
- Associating Macros with command buttons and other controls
- Embedded Macros
- AutoExec Macros
- Macro Conditions
- Referring to controls in macros
- Single-stepping through macros
- Data Macros
Database Utilities
- Compact & repair
- Splitting databases
Implementing Security
- Password protecting a database
- Employing user-level security
Creating a switchboard
Customising the Ribbon and Quick Access Toolbar
Microsoft Access Level 3 Course Duration: 1 Day
Course Overview
During this intermediate/advanced training day we concentrate on Macros, Database Utilities, Security, and create a Switchboard. Prerequisites: Candidates should have ideally attended Access Level 1 & Level 2 training or have equivalent working knowledge before attending this Access intermediate/advanced training day.
Course Content
Understanding Macro and trust settings
Macros
- Creating, editing, and deleting Macros
- Understanding events
- Macro Actions
- Safe vs. Unsafe macro actions
- Submacros
- Associating Macros with command buttons and other controls
- Embedded Macros
- AutoExec Macros
- Macro Conditions
- Referring to controls in macros
- Single-stepping through macros
- Data Macros
Database Utilities
- Compact & repair
- Splitting databases
Implementing Security
- Password protecting a database
- Employing user-level security
Creating a switchboard
Customising the Ribbon and Quick Access Toolbar
