Microsoft Access Advanced

This course has been developed for the Access “Power User” who requires advanced skills in manipulating and presenting data in Access to create a interface for front-end users. Secure your spot in our course in Brisbane, Sydney or Melbourne by booking online today.

1 day course
4.58  (53 reviews)
What you will learn:
  • Create advanced queries, forms and reports
  • Manipulate simple SQL and VBA code
  • Create user friendly front end access using forms, buttons and drop-down lists
  • Use Macros and VBA to automate processes within your database
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Course prerequisites

Participants will need to have attended or have a good working knowledge of the topics covered in the Access Introduction and Intermediate level courses.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Topics covered in this training course
  • Compact and repair
  • Split a database
  • Tabbed window interface
  • Attach a query to a form
  • SQL union query
  • Write queries in form controls
  • Create a search field in SQL
  • Find duplicate records with SQL
  • Create a form from a query
  • Query system tables
  • Macro security
  • Create a macro
  • Write submacro libraries
  • Add error handling
  • Attach macros to buttons
  • VBA vs macros
  • Creating a module
  • Writing a procedure
  • Attaching code to a button
  • Writing a VBA function
  • Convert a macro to a module
  • Attach VBA to validate data
  • Attach VBA to hide and show controls
  • Attach VBA to control how a form loads
  • Cascading combo boxes
  • Create a menu
  • Setting form properties
  • Add buttons
  • Button placement
  • Set code builder as the default
  • Add logos to the background
  • Customise the application
  • Hide the navigation pane
  • Choose a form to load on open
  • Display a minimal ribbon
  • Open a restricted database
  • Access special keys
  • Hidden objects
  • Customise the navigation pane
  • What happened to database security?

This course does not currently have public course dates. You can click here to request an in-house training quote.

Need your training approved? Get a quote
4.58
4.58
from 53 reviews
5/5
“I think it was all good.”
R, May 2020
4/5
“Good insight to Power BI”
Leigh, May 2020
4/5
“Learn't how to do many things I couldn't previously do”
Kevin, May 2020
4/5
“Little tricks and ways of using tools that I didn't know before”
Juanita, May 2020