Intermediate Level Access Course – CPD Accredited

79.00

test product

SKU: accessintermediate Category:

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; linking and transferring 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 on a flexible basis and you can start at any time.

Prerequisites for the course

Basic Level Knowledge. CLICK HERE to get Beginners 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 a mix
  • Easy-to-use system to make you professionally effective with this software
  • Access to training program for one year.

Title

Go to Top