test product
Advanced Microsoft Access Course – CPD Accredited
€79.00
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.