Need help?

+44 20 7248 8987

Advanced Microsoft Access Course – CPD Accredited

£79.00

Short Description

500 in stock

SKU: ACADV Category:

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

Objective

To gain CPD Accredited Certification in Microsoft Access Advanced; 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

Course Format

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
If you have a database to create, pay particular attention to the design of your tables:

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

Forms for entering data
You have a well-designed table and a lot of data to put in it. You will find it easier to enter the data via a form

  • 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
Think of controls as containers for your data. If you are creating a form, position them to simplify typing.

  • 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 setlist of values
  • Creating a list of values from an existing table/query

Controls: getting the presentation right
Some simple techniques for the presentation of controls, to ensure that your forms and reports are attractive

  • 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
The better your reports look; the more impact your data will have.

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

Find out more
Calculations, statistics, all sorts of queries… get to know some of Access’ less known functions.

  • 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. It is recommended that you take your assessment within six months in order to obtain a CPD Accredited Microsoft Access Advanced Certificate (included in the price). You have access to the training program for 1 year.

Online Advanced Access Course

Course Requirements

The intermediate level of MS Access is beneficial for this Advanced level. If you don’t have this level already, you can take the Intermediate Access Course here.

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
  • Flexible training can be at home or at our academy or a mix
  • 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.

Related Courses