Course overview
This course is aimed at experienced delegates wanting to increase their skillset and knowledge of the Access package. The course will provide more complex tools to create Access databases and will allow the delegates to produce enhanced forms, reports and create relationships.
Topics covered
Intermediate table design
- Naming conventions
- Linking tables
- Data types
- Data validation
- Combo boxes
- Table properties
- Field properties
Custom reports
- Printing custom reports
- Sub reports
- Custom report creators
- Query based reports
Key features
- Delete queries
- Update queries
- Cross tab queries
- Temporary fields
- Database specifications
Intermediate form design
- Query based forms
- Tab controllers
- Relational forms
- Welcome forms
- Search forms
A soft introduction to Macros will be shown at the end of the course displaying how automation can enhance productivity.
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
