Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Course Outline

Access 2016 Level 2

This is a 1 day, instructor-led course.

This course will build on some existing database design and/or user experience that may have been gained from our Microsoft Access 2016 Level 1 course.

People who intend to design databases at intermediate level or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.

Delegates should have an understanding of the Windows Operating System along with a working knowledge of the basic functions of Microsoft Access 2016. This can be obtained by attending our  Microsoft Access 2016 Level 1 course.

Access 2016 Level 2

This is a 1 day, instructor-led course.

This course will build on some existing database design and/or user experience that may have been gained from our Microsoft Access 2016 Level 1 course.

People who intend to design databases at intermediate level or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.

Delegates should have an understanding of the Windows Operating System along with a working knowledge of the basic functions of Microsoft Access 2016. This can be obtained by attending our  Microsoft Access 2016 Level 1 course.

Course Contents

Action Queries
Types Of Query
The Crosstab Query
The Make Table Query
The Append Query
The Delete Query
The Update Query

Customising Forms
Manipulating Data in the Form
Creating A New Form
Using the Form Wizard
Creating a Form with a Subform
Modifying and Redesigning the Form

Reports
The Report Wizard
Creating a Report with Summary Totals
Using the Label Wizard
Modifying and Redesigning the Report.
Publishing Access Data on the Web

Protecting desktop database with backup and restore processes
Why do I need a backup?
Creating a debase backup
Creating a Split Databases
Backing up back-end database and
front-end database
Restoring a database

Price per delegate

£249

Scheduled Classes

Indicia Training, Glasgow:

Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at info@indiciatraining.com

Contact Us