Course overview
Our experts will provide the means to develop your skillset to an advanced level with this training course. We will focus on advanced tables, forms, reports and query design and show delegates how to provide automation to some levels.
Topics covered
Working with macros
- Assign macros to events
- Run macros
- Sub macros
- Conditional macros
- Macros from buttons
- Set value
- Run command
- Requery
Advanced query design
- Types of criteria
- Manage query joins
- Summarise data in queries
- Action queries
- Crosstab queries
- Self joins in queries
- Parameter queries
Advanced macros
- Macro names
- Refresh
- Maximum and minimum
- Set values
- Run command
- Open
- Macro or VBA
Advanced form design
- Forms controls
- Subforms and Link forms
- Form properties
- Command buttons
- Interface
- Start up and navigation forms
- Modifying form properties
Delivery methodology
(Face-to-face or virtual delivery available)
Small groups
Ideally 6-8 delegates to maximise engagement and interaction levels.
One-to-one
We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).
Tailored sessions
Talk to us about designing bespoke workshops for your team
