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
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- Face-to-Face and Online Instructor led .
- And more... .
Upcoming start dates
Choose between 50 start dates
Upcoming start dates
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
List price £330, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
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.5
Based on 1405 reviews.
Write a review!
Reviews are published according to our review policy.
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
Most useful topic: Unions and multitab forms