
Course Outline
Access 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 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 2016 Level 1 course.
Access 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 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 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
£350
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