Phone 1300 793 951 or visit www.odysseytraining.com.au

Odyssey Training Logo
Microsoft Access Advanced Training Course

Microsoft Access Advanced

1 Day Training Course

Book a public course

Venue – Melbourne

Odyssey Training
Level 7, 31 Queen Street
Melbourne VIC 3000
View map and directions

Times and Dates

14 Feb 2018
1 Day     9:00 am – 4:00 pm

Need your training approved?

Computer Course Inclusions
 

This course is ideal for

This course has been developed for the Access “Power User” who requires advanced skills in manipulating and presenting data in Access to create an application front-end for other users.

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.

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

Topics covered in this training course

  • Database actions
    • Compact and repair
    • Split a database
    • Tabbed window interface
  • Queries and SQL
    • 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
  • Macros
    • Macro security
    • Create a macro
    • Write submacro libraries
    • Add error handling
    • Attach macros to buttons
  • VBA modules
    • VBA vs macros
    • Creating a module
    • Writing a procedure
    • Attaching code to a button
    • Writing a VBA function
    • Convert a macro to a module
  • VBA and form events
    • Attach VBA to validate data
    • Attach VBA to hide and show controls
    • Attach VBA to control how a form loads
    • Cascading combo boxes
  • Creating a menu system
    • Create a menu
    • Setting form properties
    • Add buttons
    • Button placement
    • Set code builder as the default
    • Add logos to the background
  • Database startup procedures
    • 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?

Home > Microsoft Access Training > Access Advanced Course > 2010

Our Training Courses

- +
Subtotal
Special offer