Hello, Optima Training has detected that you are using an outdated version of Internet Explorer. If possible we strongly urge you to update your browser or switch over to Chrome or Firefox so you can enjoy the full user experience of our website and avail of all the features!
Close This Message'

Microsoft Access Advanced

This Microsoft Access Advanced training course is a 1 Day public programme, designed as an entirely ‘hands on’ course that will give participants a further understanding of database design principles, advanced forms, reports and advanced query design, including using calculations. Customisation of the database through command buttons, macros and customised menus, and Internet publishing.

Product Code:
1 Day
Cost Includes:
Training course materials and after-training support
Contact Name:
Sinead Landers
X €190.00
Make an Enquiry
Attendee(s), if more than one seperate with a comma
Course Content
Intended Audience
Method Of Delivery

Microsoft Access Advanced Course Outline

• About Queries
• Update Query
• Delete Query
• Make Table Query
• Append Query
• Crosstab Query
• Find Duplicates Query
• Find Unmatched Records Query
• One Variable Parameter Query
• Two Variable Parameter Query
• Using Wildcards In a Query
• Maximum or Minimum Values In a Query
• Using Calculated Fields That Perform Arithmetic Calculations
• Grouping Information In a Query using Functions

• Types of Form Controls
• Bound Controls Vs. Unbound Controls
• Text Box
• Combo Box
• List Box
• Check Box
• Limit to List
• Distinct Values
• Arithmetic Expressions
• Logical Expressions
• Modifying the Tab Order in a Form
• Creating a Sub-Form
• Linking a Sub-Form

• Formatting Arithmetic Calculation Controls
• Applying a Running Sum For a Group or Over All
• Concatenating Fields within a Report
• Inserting a Data Field In a Report Group
• Inserting a Data Field In a Report Page
• Inserting a Data Field In Report Headers and Footers
• Sorting and Grouping Records In a Report By Field(S)
• Forcing Page Breaks For Groups In a Report
• Creating a Linked Sub-Report

• Creating Macros
• Assigning a Macro to a Command Button
• Assigning a Macro to an Object
• Assigning a Macro to a Control

Linking Data
• Linking an Excel Workbook to a Database
• Linking External Text Data In a TXT File
• Linking External Text Data In a CSV File
• Linking External Data to a Database using Existing Database Files

Importing Data
• Importing an Excel file
• Importing a CSV Text file
• Importing a TXT file
• Importing an XML file
• Importing an Database File


This Microsoft Access Advanced training programme may be of interest to personnel who wish to gain a comprehensive overview of the more advanced features of Microsoft Access.

A good knowledge of Access or have completed the Procad Training Course entitled ‘Intermediate Access’.

Classroom based, instructor lead, practical hands on course with Computer / Laptop per person during the session

There are no reviews yet.

Be the first to review “Microsoft Access Advanced”