Course overview
This course is aimed at the new user and aims to provide the knowledge and confidence to create and amend Access databases, input forms, produce basic reports and manipulate data. Throughout the workshop you are encouraged to explore the software to enhance common errors and how to diagnose them.
Topics covered
Fundamentals
- Getting started
- Database terminology
- Access screen tour
- Access objects
- Creating a blank database
- Create from a template
- Ribbon menu
- Working with a window
- Getting help
Queries
- Locate specific records
- Creating and running queries
- Finding information
- Create query joins
- Parameter queries
- Multi table queries Refining results
Tables
- Add/edit tables
- Data entry
- Design and working mode
- Filtering/sorting information
- Modifying
- Primary and foreign keys
- Input masks
- Indexed and data types
Forms and reports
- Create a form/report
- Modify and design
- View and edit
- Moving, deleting and resizing
- Formatting controls
- Prepare to print
- Enhance the appearance
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
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
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
