Course not currently available
Microsoft Access Advanced
Short course
In Redbourn ()
Description
-
Type
Short course
-
Duration
1 Day
To provide attendees with an understanding of the data analysis. Suitable for: Individuals who wish to create queries, build forms reports and macros.
Important information
Documents
- Access Advanced
About this course
Attendees need to have attended the Access Foundation course or have equivalent knowledge.
Reviews
Course programme
Microsoft Access Advanced Course Outline
Relationships and Specialist Queries
- Relational database design
- Creating many to many relationships
- Creating a query from related tables
- Inner and outer joins
- Parameter queries
- Summary queries
- Calculated queries
Action Queries
- Make table queries
- Delete queries
- Append queries
- Update queries
- Cross tab queries
Form and Report Design
- Features of forms & reports
- Working with sections
- Moving, resizing and deleting controls
- Working with controls
- Working with properties
- Using unbound and bound controls
- Creating subforms & subreports
- Using command buttons
Introduction to Macros
- Introducing Macros
- Creating Macros for command buttons
- Creating Macros for forms
- Creating a switchboard
- Switchboard display options
- Using hyperlinks
Microsoft Access Advanced