START
 

Access Intermediate

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

Access Intermediate



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

Suitability - Who should attend?



Our Microsoft Access 2013 Intermediate course is suitable for those with a basic working knowledge of Microsoft Access.

Training Course Content



What's new in Access 2013

Creating relational databases

Database normalising
Introducing relating tables
Adding referential integrity

Working with related tables

The lookup wizard
Changing lookup fields
Inputting data to related tables

Defining data entry rules

Using input masks
Setting a property
Setting a validation rule

Using advanced query features

How to join a table in queries
Creating a calculated field
Using an action query

Creating advanced queries

Summarise and group values
Create a crosstab query
Using a parameter query

Creating advanced form design

Working with graphics
Working with calculations
Working with combo boxes
Working with unbound controls

Using advanced report features

Create customized headers and footers
Add a calculated value
Work with sub-reports

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 Intermediate.

  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)
Tessa Rowland; Technical Manager   |   08/06/2016
Most useful topic: Unions and multitab forms
          (5)
Katy Triggs; Administrative Assistant   |   08/06/2016

          (5)
Glenn Burke; FINANCE AND OPERATIONS ADMINISTRATOR   |   22/04/2016
Most useful topic: Creating forms
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 Intermediate course - simply fill out your details:

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
Find more courses here