ACCESS / IT · 2 Days

Microsoft Access Advanced

At the end of this course you will be able to use advanced features in the design of all major Access objects, apply simple automation to database objects using macros, use built-in database tools to manage a database, and work with external data to import, export and link data.

Duration: 2 Days From £550/day (up to 8 learners) 1-to-1 or Groups of up to 8 Learners (Larger by Arrangement) M365 (Desktop & Web) · Office 2021/2024 Certificate · Manuals · 1-Year Support

Complete Course Syllabus

Advanced Table & Query Design

  • Advanced field and table properties, lookup fields, and naming conventions
  • Managing inner joins, outer joins, and self-joins in queries
  • Summarising and grouping data using Totals queries

Action, Crosstab & Parameter Queries

  • Creating interactive Parameter Queries with prompts
  • Building Action Queries: Make-Table, Append, Update, and Delete queries
  • Summarising multi-dimensional data with Crosstab Queries and Find Duplicates/Unmatched queries

Advanced Forms, Subforms & Macros

  • Enhancing forms with combo boxes, option groups, command buttons, and calculated controls
  • Creating linked subforms, start-up forms, and custom Navigation Forms
  • Automating tasks with single macros, submacros, conditional macros, and event triggers

Importing, Exporting & Database Maintenance

  • Importing from and exporting to Excel, CSV, and other databases
  • Linking external tables and managing the Linked Table Manager
  • Object Dependencies, Database Documenter, Performance Analyzer, Compact & Repair, and database security
Copied to Clipboard ✓

Ready to Share