Microsoft Access Advanced


Date(s) - 17/02/2021
All Day

Glasgow Training Centre


Audience: This course is designed for existing Micrsoft Access users who need to start automating database tasks or simplify complex database sequences.

Course Duration: 1 day

Module 1: Creating Forms

  • Working in Form design view
  • Applying Form controls
  • Date Picker control
  • Adding Combo, List and Check Boxes to the Form
  • Creating forms using Mainform – Subform
  • Tabular forms
  • Using Conditional formatting
  • Additional Form topics

Module 2: Advanced Reports

  • Using the Report Wizard
  • Working with Report properties
  • Grouping Reports
  • Applying calculations in Reports
  • Additional topics

Module 3: Advanced Query Techniques

  • Working with Join properties
  • Unmatched data
  • Crosstab queries
  • Union queries
  • Action Queries
  • Find duplicates query
  • Find unmatched query

Module 4: Importing and Exporting Access Data

  • Importing a spreadsheet from Excel
  • Linking data tables to an Access database
  • Export a table to Excel and text files
  • Exporting reports
  • Export to HTML format
  • Export linked data source information to Excel (new)

Module 5: Access Macros

  • Developing macros with Macro Designer
  • Triggering data macros
  • Running a macro
  • Attaching a macro to a command button
  • Running a macro from field properties
  • Creating conditional macros
  • Using sub macros

Module 6: Customising Access databases

  • Database tools and utilities
  • Compacting a database
  • Hiding database objects
  • Start-up options
  • Create a user Switchboard

Module 7: Discussion Only (new)

  • Access Web App features in Access Services (coming for SharePoint 2016)
  • Cascading controls
  • Datasheet filter improvements
  • Related item control enhancements
  • Image storage and performance improvements
  • Office Add-ins integration with Access Web Apps
  • Additional packaging and upgrade functionality for Access Web App packages
  • On Deploy macro action for upgrade scenarios
  • Lock tables from editing functionality
  • Download in Excel feature for datasheet views



Bookings are now closed for this event.