"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

ACCESS LEVEL 3

 

Course Title MS Access 2010 Level 3

 

         Course Duration 1 Day

 

 
During this intermediate/advanced training day we concentrate on Macros, Database Utilities, Security, and create a Switchboard.
Prerequisites:
Attended MS Access 2010 Level 1 & Level 2 and has good working knowledge of MS Access database – or equivalent working knowledge.
Topics
 
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