Microsoft Access 2016 Level 2

Microsoft Access 2016 Level 2

Overview

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

Duration

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.

Prerequisites

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.

Topics

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:

MSA2016L2

Course Duration:

1 Day

Course Location:

Sunderland

Course Dates:

Please call for dates...

Course Price (Excl VAT):

£195

Course Downloads

Send course details to a colleague

Telephone

   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk