Description

A Microsoft Certified Academy offers an interactive course with CPD-accredited certification in Access.

Course Format

You can extend the Microsoft Access Intermediate level course at a reduced rate for beginners and/or advanced students. The training is given online, with the help of a virtual teacher. The virtual teacher instructs, corrects and gives examples to simulate that you have a personal IT trainer. This is a very effective and modern method of delivering interactive online training.

Intermediate Level Access Course

Course Content

Objects and their datasheets.

  • Manage objects
  • Formatting/Reorganizing a Datasheet
  • Filter records by the value in a field
  • Filter by a range of field values
  • More about database objects and, in particular, everything you can do in a datasheet.
  • Inserting a Total Row in a Datasheet

Create and protect databases

  • Creating a database
  • Convert a database
  • Securing a database

More about data

  • Create a primary key table
  • Import data from another application
  • Export data
  • Create a form
  • Store data in tables, forms, or reports; link and transfer data… making optimal use of the available possibilities.
  • Object dependencies
  • Selecting the records to print in a report

From Question to Query – Create a Select query

  • Using the query design grid
  • Set a selection criterion in a query
  • Set criteria on multiple fields
  • Set multiple criteria on the same field
  • Sort the records in a query
  • Delete query
  • Create table query
  • Update query

Even if your database is simple, don’t limit yourself to typing and printing your data.

  • Make a query Select
  • Using the query design grid
  • Set a selection criterion in a query
  • Set criteria on multiple fields
  • Set multiple criteria on the same field
  • Sort the records in a query
  • Delete query
  • Create table query
  • Update query

Dates and duration

The course is taught flexibly, and you can start at any time.

Prerequisites for the course

You need to have already attained Beginner Level Skills. CLICK HERE to get Beginner’s Training.

Benefits of the Course

  • CPD Accredited Microsoft Certificate
  • Internationally accredited qualification to enhance CV
  • Confidence in using Access effectively at work
  • Work quickly through this extra knowledge
  • Flexible training can be at home or in our academy, or in a mix
  • Easy-to-use system to make you professionally effective with this software
  • Access to the training program for one year.