Microsoft Access Diploma

£149.00

Category:

Description

Microsoft Access databases have been used by several organisations to create HR systems and other corporate systems. Our Microsoft Access Diploma   includes Beginner to Advanced training. The Diploma is CPD Accredited and online. It means that you can work flexibly online and gain both career skills and a professional qualification.

Microsoft Access Diploma

Course Format

This is an online course that can be started at any time. It is completely flexible and available at any time. The training is provided in partnership with Microsoft Learning Partners. Their training systems contains a virtual tutor function that instructs you, provides worked examples, gives you exercises and marks your exercises.

Course Content

Beginner Module

  • Getting started with the Database Management System
  • Opening a database
  • Database objects
  • Overview of Access ribbon
  • Maintaining Database records
  • Entering, Replacing, Editing, Finding, Delete and Sorting records
  • Moving around in a datasheet/form
  • How to use of the data
  • Print Preview data
  • Margins and orientation for printing any object
  • Running a query in your database

Intermediate and Advanced Module

  • 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
  • Creating a database
  • Converting a database
  • Protecting a database
  • 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
  • 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

Average learning hours are 25 hours. This average is based on past student study times. Your aptitude and background can cause learning times to vary. You have up to one year to complete the training, but you can complete in a far shorter time.

Course Requirements

The Course can start from beginner level, so there are no special entry requirements.

Benefits

  • Training written by senior Microsoft Partners
  • User friendly
  • We can offer CPD Certification which is internationally recognised, because we are a Microsoft Certified Academy.
  • Build your CV with the Certification
  • flexible study that is still interactive

Additional information

date-of-course

2nd – 4th March 2020, London, 4th – 6th May 2020, London

number-of-attendees

1, 2, 3, 4, 5