START
 

Access Intermediate Course

Woodthorpe IT Solutions
Course summary
Length: 1 day
Price: 500 GBP excl. VAT
Language: English
Location: Nationwide
Next available date: Contact us to discuss dates (At your office) - Nationwide

Course Description

Access database course

Delivered at your office this practical training course has been designed to give up to 8 attendees a good springboard to produce database systems in Access 2007, 2010, 2013 and 2016.  The course is delivered in a fun and interactive format, and participants are encouraged to ask questions during the day.

Why Woodthorpe IT Solutions?

  • Each attendee will be provided with a laptop.  (Up to 8 people per session).
  • Questions encouraged.  Courses delivered by industry experts who do not read from a manual.
  • Notes provided in electronic format.
  • Attendees will be sent a tips email every 2 weeks.
  • Attend free webinar sessions after the course.
  • Post course support provided via email with no time limit.

Suitability - Who should attend?

Attendees should have some experience of building databases in Access or other relational database system before attending this course.

Our tutors are very patient and will ensure all attendees leave with increased confidence.

Outcome / Qualification etc.

Each attendee will be able produce more complex database systems after the course.  They will receive an electronic attendance certificate. 

Training Course Content

Access Intermediate Course

Relational databases

  • Database normalization
  • Relating MS Access tables
  • Implementing referential integrity

Working with related tables

  • Lookup fields
  • Modifying Lookup fields
  • Subdatasheets

Complex queries

  • Joining tables in MS Access queries
  • Creating calculated fields
  • Summarizing and grouping values

Advanced form design

  • Adding unbound controls
  • Graphics
  • Adding calculated values
  • Adding combo boxes

Advanced reports

  • Customized headers and footers
  • Adding calculated values
  • Sub-reports

Charts

  • Charts in forms
  • Charts in reports

PivotTables and PivotCharts

  • MS Access PivotTables
  • Modifying PivotTables
  • PivotCharts

Internet integration

  • Hyperlink fields

Expenses

The cost for this in-house training is £500+VAT per day.

What is included?

  • Reasonable travel to your site on UK main land (Except to central London).
  • Provision of 8 laptops.
  • Provision of a projector.
  • Customisation of course content if required.

What is not included?

  • If the tutor has to travel more than 2 hours to the training site hotel costs may be applicable.
  • If the tutor has to travel to Central London train and taxi costs may be applicable.

Get Inspired! Watch the Video

Woodthorpe IT Solutions specialise in delivering onsite Microsoft Office training and providing consultancy support to businesses. We are a small and dedicated team who travel the length and breadth of the country providing our service. We have worked, and continue to work for companies such as Burberry, DeBeers, LVMH, John Lewis, Asics and many more.

Provider: Woodthorpe IT Solutions

Microsoft Office Training

Woodthorpe IT Solutions - Microsoft Office Training and Consultancy

We are here to help you get the most from Microsoft Office, our industry experts entertain and teach during any day we deliver for you.  No question is too small or problem too big for us to help you with, we...


Read more and show all courses with Provider: Woodthorpe IT Solutions

Request information - obligation free

Fill out your details to find out more about Access Intermediate Course.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for Woodthorpe IT Solutions

Woodthorpe IT Solutions



4 Haycroft Close, Great Sutton
CH66 2GY Ellesmere Port, Cheshire

 Show phone number
www.woodthorpeitsolutions.co.uk

Reviews by course attendees

          (5)
Claire   |   28/09/2016
A great training experience by a very down to earth trainer which made the whole learning process a lot easier.
          (5)
Alex M   |   21/07/2016
Ben has been coming to our sites for a while now and always delivers exceptional courses that are tailored to suit our employees. Ben is always helpful and is a brilliant trainer, would recommend to anyone looking to improve their IT skill set.
Enter & win £50 voucher

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