Microsoft Access 2016 Level 2

Microsoft Access 2016 Level 2


To build on some existing database design and/or user experience that may have been gained from the Introduction course.


1 Day

Target Audience

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.


This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.


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

2; 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

3; 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

4; Protecting desktop databases with backup and restore processes
Why do I need a backup?
Creating a database backup
Creating a Split Database
Backing up back-end database and front-end database
Restoring a database

Appendix A; Backwards Compatibility
E-mailing Database Information

Course Details

Course Ref:


Course Duration:

1 Day

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at