Description

Achieve Accredited Certification in Access; to gain in-depth knowledge of MS Access at an advanced level; to advance your career and gain confidence.

Course Format

The Advanced Microsoft Access Course 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.

Advanced Microsoft Access Course

Course Content

Tables: all about the design

Restructure a table in the Datasheet view.
Restructure a table in the Design view
Restrictions on what can be received in a field
Input masks
Lookup Lists Indexing a Table
Relationships between tables

Data Entry Forms

Form properties

Access to form fields
Change the restricted access to fields
Part forms
Using a form to enter data in several at once
Data collection and sharing

Control: positioning, organization

Create a text box to display a field
Selecting and Removing Controls
Create a checkbox/button, an option group
Tags and Calculated control
Calculate statistics in forms and reports
Create a fixed list of values
Create a list of values ​​from an existing table/query

Controls: a good presentation

Move and copy controls
Align and Spacing Controls
Change the height of a section
Create a rectangle/line element
Resizing Controls
Formatting text in a control
Align text in a control
Formatting Controls
Conditional formatting
Copy a layout from one control to another
Group/Group Controls
Number of pages in a report or form
Insert an image
Themes

Reports for sharing data

Sort information in a report
Group records in a report
Print groups on individual pages of a report
Send labels

Calculations, statistics, queries of all kinds… get to know some of Access’ lesser-known features.

Calculated fields in a query
Statistics without grouping, by groups and on groups of pre-selected records
Parameter queries
Search unpaired query
Find duplicate query
Crosstab query
Create a pivot table
Group records in a pivot table
Add totals
PivotCharts

Dates and duration

The course has a flexible start date, and you can study online anytime. You have up to 6 months to complete the course.

Prerequisites for the course

An intermediate level of MS Access is helpful for this Advanced level. CLICK HERE for Intermediate level training

Benefits of the Course

  • Training written by senior Microsoft Partners
  • User-friendly state-of-the-art system
  • CPD Accredited Microsoft Access Advanced Certificate – Internationally Recognized
  • Accredited qualification to boost your CV
  • Be prepared for any assessment during any job interview
  • Confidence in using Access effectively at work
  • Flexible training can be done at any time and from anywhere
  • Easy-to-use system to make you professionally effective with this software
  • Access to the training program for one year.