START
 

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

Access Advanced Course

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 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)
Alan Fisher   |   18/09/2016
Was really interesting. Learnt alot in one day but it felt laid back so was easy to concentrate.
          (5)
Ian Lynam   |   23/07/2016
Ben has written all our nonstandard programes and nothing was too much trouble.
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 course - simply fill out your details:

 
Find more courses here

 
Have your say:

apprenticeships