START
 

Access Advanced

STL
Course summary
Length: 1 day
Price: 199 GBP excl. VAT
Language: English
Provider: STL plus
Course type: Open / Scheduled
Next available date: 17/05/2017 09:30 - London
Course Dates
London
17/05/2017 09:30  (English)
199 GBP
08/09/2017 09:30  (English)
199 GBP
07/11/2017 09:30  (English)
199 GBP
08/01/2018 09:30  (English)
199 GBP
09/03/2018 09:30  (English)
199 GBP
10/05/2018 09:30  (English)
199 GBP

Access Advanced



Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... 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.

Suitability - Who should attend?



Our advanced Micorosoft Access training 2013 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



What's new in Access 2013

Creating Advanced Forms

Designing a form based on joined tables
Automating data entry
Grouped control
How to improve the user interface
Designing subforms

Macros

Create and run macros
Attach macros to events of database objects

Creating Advanced Macros

Create macros to provide user interaction
Create macros requiring user decision
Use AutoKeys and AutoExec macros

Exploring Access SQL

How to identify different clauses in an SQL statement
Writing SQL statements
Attach an SQL statement to database objects

Integrating the Internet

Work with hyperlink fields

Managing Databases

Work with database utilities to optimise resources
Secure data by database replication

Security Fundamentals

Protect databases

Expenses



List price £330 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with Provider: STL

Request information - obligation free

Fill out your details to find out more about Access Advanced.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional
Optional

Contact information for STL

STL



Greater London
2nd Floor, Cruising Association House, 1 Northey Street
E14 8BT Limehouse Basin

 Show phone number
www.microsofttraining.net

Reviews by course attendees

          (5)
Sheetal Kokate; Business Analyst   |   07/06/2016
Most useful topic: Macros; Queries and Database management
          (5)
Caroline Tosh   |   16/05/2016

          (5)
Jack Williams; Business Manager   |   16/05/2016
- An entire worksheet dedicated to exercises that didn't immediately tell us step-by-step how to do them was a good idea - it required us to apply our knowledge more unaided - I recommend for all future courses. - Course was extremely satisfactory
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Request information

Find out more about this Access Advanced course - simply fill out your details:

 
Find more courses here

 
Have your say:

apprenticeships