Access Intermediate
- This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.
After completing this course you will be prepared to attend the Access Advanced training course.
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 213,060 people .
- Over 14,264 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
Our Microsoft Access Intermediate course is suitable for those with a basic working knowledge of Microsoft Access.
Training Course Content
What's new in Access
Creating relational databases
Database normalisingIntroducing relating tables
Adding referential integrity
Working with related tables
The lookup wizardChanging lookup fields
Inputting data to related tables
Defining data entry rules
Using input masksSetting a property
Setting a validation rule
Using advanced query features
How to join a table in queriesCreating a calculated field
Using an action query
Creating advanced queries
Summarise and group valuesCreate a crosstab query
Using a parameter query
Creating advanced form design
Working with graphicsWorking with calculations
Working with combo boxes
Working with unbound controls
Using advanced report features
Create customized headers and footersAdd a calculated value
Work with sub-reports
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 4.8
Based on 69 reviews.
Write a review!
Reviews are published according to our review policy.
Christopher
29 Jun 2023
Melanie
02 Mar 2023
Most useful topic: all of it
Andrew
27 Apr 2022
Most useful topic: learning about turning data into tables
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads
Everything came together from Tuesday and was a lot less overwhelming due to knowledge picked up in previous training