Description

We offer CPD Accredited Certification in Advanced Microsoft Access Course, an internationally recognised qualification. Certification and Assessment fees are included in the course fees.

Objective

To gain CPD Accredited Certification in Advanced Microsoft Access; to gain in-depth knowledge of MS Access Advanced level; to advance your career or job chances; to gain confidence in this application.

Advanced Microsoft Access Course

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

Tables: all about the design

  • Datasheet view
  • Design view
  • Restricting what can be entered in a field
  • Input masks
  • Lookup lists Indexing a table
  • Relationships between tables

Forms for entering data

  • Form properties
  • Preventing access to form fields
  • Changing the order of access to fields
  • Subforms
  • Using a form to enter data in several tables at once
  • Collecting and sharing data

Controls: positioning, organising

  • Creating a text box to represent a field
  • Selecting and deleting controls
  • Creating a check box/button
  • Creating an option group
  • Creating a label
  • Creating a calculated control
  • Calculating statistics in forms and reports
  • Creating a set list of values
  • Creating a list of values from an existing table/query

Controls: getting the presentation right

  • Moving and copying controls
  • Aligning and spacing controls
  • Changing the height of a section
  • Creating a rectangle/line control
  • Resizing controls
  • Formatting text in a control
  • Aligning text in a control
  • Formatting controls
  • Conditional formatting
  • Copying a format from one control to another
  • Grouping/ungrouping controls
  • Numbering pages in a report or form
  • Inserting a picture
  • Themes

Reports for communicating data

  • Sorting information in a report
  • Grouping records in a report
  • Printing groups on separate pages of a report
  • Mailing labels

Find out more

  • Calculated fields in a query
  • Statistics without grouping
  • Statistics on groups
  • Statistics on groups of pre-selected records
  • Parameter queries
  • Find unmatched query
  • Find duplicates query
  • Crosstab query
  • Creating a pivot table
  • Grouping records in a pivot table
  • Adding a totals
  • Pivot charts

Dates and Duration

You can start the course at any time and study when you prefer. You should take your assessment within six months to obtain a CPD Accredited Microsoft Access Advanced Certificate (included in the price). You have access to the training program for one year.

Course Requirements

This is an advanced-level course. To take the course, you must have the skills from the Intermediate Course.

Benefits

  • Training written by senior Microsoft Platinum Partners
  • User-friendly state-of-the-art system
  • CPD Accredited Microsoft Access Advanced Certificate – internationally recognised
  • CPD Accredited qualification to boost your CV and job options
  • Being prepared for any assessment at any job interview
  • Confidence in the use of Access effectively at work
  • Work quickly because of this additional knowledge
  • The flexible training schedule that can be taken online
  • Flexibility, so you can train in a shorter period if needed
  • User-friendly system to make you professionally effective with this software
  • Access to the training program for one year.