START
 

Access Advanced Training

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

Querying with SQL

  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

Advanced queries

  • Creating crosstab queries
  • Creating parameter queries
  • Using action queries

Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

Advanced Macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

Importing, exporting, and linking objects

  • Importing objects
  • Exporting objects
  • Linking Access objects

Database management

  • Optimising resources

Security fundamentals

  • Protecting databases

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 Advanced Training.

  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)
Keri Johnson   |   15/09/2016
Ive had both in person and online webinar training from Ben. He's very clear and I value the after support and training materials.
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 Training 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