Main: 01633 256482 info@nilc.co.uk

Microsoft Access Intermediate

✓  Wales’ leading Access training provider

✓  Free detailed course notes with every classroom course

✓  Expert instructors with 5 Star customer ratings

✓  Onsite training courses available

✓  ReAct Government Funded Accepted

Course Type

Classroom

Duration

1 day

Accredited

No

Exam

Not Available

Course Information

This Microsoft Access Intermediate level training course is designed for students who are already able to create, edit, and print Access databases on Windows. In this course, students will learn advanced formatting, use Access tools, create and manage tables, and work with database queries.

  • Table Lookup Fields
  • Modifying Lookup Fields
  • Setting Table Default Values
  • Table Mandatory Fields
  • Referential Data Integrity
  • Examining Northwinds Database Table Relationships
  • Database Documenter
  • Creating a Simple Wizard Query
  • Creating a Query in Design View
  • Setting Query Criteria
  • Manipulating Queries (Sorting, Hiding Fields)
  • Creating Action Queries (Make Table, Update, Append, Delete)
  • Using the Query Builder
  • Creating Calculation Queries
  • Creating a Cross Tab Query
  • Total Grouping Queries
  • Creating Parameter Queries

There is no formal assessment available for this course. Delegates knowledge will be tested in class through a series of informal exercises. 

  • Day 1 –  09:15am – 16:30pm 

This course includes:

  • Training from an experienced Microsoft trainer
  • Computer / Laptop to use for the duration of the course
  • Detailed course notes and sample exercises
  • Officeskills full colour course manual (if available)
  • Free online training videos (if available)
  • Refreshments

Dates and Prices for Microsoft Access Intermediate

Choose your location

Cardiff
January 15, 2020 £205.00
Available
Enquire
Cardiff
March 11, 2020 £205.00
Available
Enquire
Cardiff
May 13, 2020 £205.00
Available
Enquire
Cardiff
July 8, 2020 £205.00
Available
Enquire
Cardiff
September 14, 2020 £205.00
Available
Enquire
Cardiff
November 9, 2020 £205.00
Available
Enquire

Can’t find the course dates or location you’re looking for?

Please note all published prices are exclusive of VAT for consumers who pay no VAT or can recover VAT. The current rate of VAT is 20% for consumers that are required to pay VAT. All public classroom course bookings are subject to availability and minimum course numbers.

Why Choose NILC For Your Microsoft Access Training?

 

Industry Expert Trainers

Highly skilled trainers with real world Access and database experience

Highly Rated

We are highly rated with 5 stars from Trustpilot

Online Video Support

Detailed course notes supplied with every classroom based course

Multiple Locations

Courses available at our venues or your offices

Our registered office and postal address is 50 Commercial Road, Newport, Gwent, NP20 2PE

All quoted prices are exclusive of VAT for consumers who pay no VAT or can recover VAT. The current rate of VAT is 20% for consumers that are required to pay VAT.
All course bookings are subject to availability.