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
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- And more... .
Upcoming start dates
Choose between 49 start dates
Upcoming start dates
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
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 693 reviews.
Write a review!
5/5
Sheetal Kokate; Business Analyst
07 Jun 2016
Access Advanced
5/5
Caroline Tosh
16 May 2016
Access Advanced
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: Macros; Queries and Database management