"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
  • Microsoft/Microsoft Access Level 3 Course Duration: 1 day

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