Need help?

+44 20 7248 8987

Intermediate Level Access Course – CPD Accredited

£79.00

Short Description

500 in stock

SKU: ACONC Category:

Training in Microsoft Access Intermediate is an in-depth program to gain professional knowledge which is much needed in any office where databases are important. The online training is delivered via user friendly state of the art system using the latest technology in interactive training. The training is through a virtual tutor who follows your progress and suggests /shows the correct way to perform a task.

Access Course

As a Microsoft Certified Academy, this course includes CPD Accredited Certification in Access Intermediate Level.

Objective

To learn the most efficient way to use Access; to gain a CPD Accredited Certificate at Proficient (Intermediate) level.

Course Format

Microsoft Access Intermediate level course, you can add on Beginner and / or Advanced units for a discounted fee . The training is delivered online, using a virtual tutor. The virtual tutor instructs, corrects and provides examples, to simulate having a personal IT trainer. This is a very effective and up to date method of delivering interactive online training.

Course Content

Objects and their datasheets
More about database objects and, in particular, all that you can do in a  datasheet.

  • Managing objects
  • Formatting/reorganising a datasheet
  • Filtering records by the value in a field
  • Filtering by a range of field values
  • Inserting a Total row into a datasheet

Database creation and protection
How to create, convert and protect databases.

  • Creating a database
  • Converting a database
  • Protecting a database

More about data
Storing data in tables, forms or reports; linking and transferring data… make the most of the possibilities available

  • Creating a table Primary key
  • Importing data from another application
  • Exporting data
  • Creating a form
  • Object dependencies
  • Selecting the records to print in a report

From question to query
Even if your database is a simple one, do not limit yourself to typing in and printing out your data.

  • Creating a Select query
  • Using the query design grid
  • Setting a selection criterion in a query
  • Setting criteria on multiple fields
  • Setting multiple criteria on the same field
  • Sorting the records in a query
  • Delete query
  • Make Table query
  • Update query

Dates and Duration

Please email or telephone to arrange a start date with induction.

It is recommended that you take your assessment within three months in order to obtain a CPD Accredited Microsoft Certificate (included in the price). You have access to the training program for 1 year.

Course Requirements

There is no special entry requirement.

Benefits

  • CPD Accredited Microsoft Certificate
  • Accredited qualification to boost your CV and job options
  • Being prepared for any assessment at job interview
  • Confidence in the use Access effectively at work
  • Work quickly because of this additional knowledge
  • Flexible training can be at home or at our academy or a mix
  • User friendly system to make you professionally effective with this software
  • Access to training program for one year.

Outcome

CPD Accredited Microsoft Access Certificate

Related Courses