Access 2016/2019/365 Advanced

Microsoft Access Expertise – Queries, Forms, Reports, and Macros

In this seminar, participants will learn advanced techniques for working with Microsoft Access. The focus is on creating and using action queries, designing complex forms and reports, and using macros to automate database processes. Practical exercises demonstrate how to manage, analyze, and present data efficiently.

Our experienced trainers will show you:

• How to use action queries to edit data effectively
• How to design advanced forms for data entry, selection, and analysis
• How to create structured reports with totals and running sums
• How to automate processes with macros

Your Benefits at a Glance

• Deep dive into advanced Access functions
• Practical exercises for real-world database scenarios
• Efficient workflows through automation with macros
• Professional techniques for forms, reports, and queries
• Participation available on-site or live online

Seminar Contents

Action Queries – Targeted Data Editing

• Adding, updating, or deleting records
• Working with select, append, and delete queries

Forms – Data Entry, Selection, and Analysis

• Creating and customizing simple data entry forms
• Designing complex forms for selection, analysis, and calculations
• Setting up a start form as a control center for the database

Reports – Structured Data Presentation

• Adjusting and adding groupings
• Creating subtotals and grand totals
• Calculating running sums

Macros – Automating Processes

• Introduction to the macro catalog and its applications
• Creating simple macros and entering action arguments
• Setting conditions for macro execution

Target Audience

This seminar is designed for:

• Users who want to make their databases more efficient with advanced form and report functions
• Anyone who wants to automate processes and optimize their work with Access using macros

Prerequisites

• Participation in the Access introduction seminar or equivalent knowledge
• Practical experience with your own databases