Access Advanced
- At the end of this course you will have a complete understanding of the higher functions of Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources.
You will then be qualified to progress to the VBA course for Access.
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 advanced Microsoft Access training course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.
Training Course Content
Creating Advanced Forms
Designing a form based on joined tablesAutomating data entry
Grouped control
How to improve the user interface
Designing subforms
Macros
Create and run macrosAttach macros to events of database objects
Creating Advanced Macros
Create macros to provide user interactionCreate macros requiring user decision
Use AutoKeys and AutoExec macros
Exploring Access SQL
How to identify different clauses in an SQL statementWriting SQL statements
Attach an SQL statement to database objects
Integrating the Internet
Work with hyperlink fieldsManaging Databases
Work with database utilities to optimise resourcesCreate Front-end and Back-end database
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 5
Based on 21 reviews.
Write a review!
Reviews are published according to our review policy.
Nolan
20 Dec 2019
Nick
24 Apr 2019
Most useful topic: VBA
Tom
07 Oct 2017
Most useful topic: Queries
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: All topics were extremely useful