Advanced Microsoft Access Course – CPD Accredited

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 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.

Advanced Microsoft Access Course

Course Content

Tables: all about the design

Restructure a table in Datasheet view.
Restructure a table in Design view
Restrictions 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
Create an option group
Create a tag
Create a 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 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
Statistics by groups
Statistics 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 at any time you like. You have up to 6 months to complete the course.

Prerequisites for the course

An intermediate level of MS Access is useful 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.