Microsoft Access 2016 Level 3

Microsoft Access 2016 Level 3

Overview

To build on a reasonable level of database design experience that may have been gained from the Introduction and/or Intermediate course.

Duration

1 Day

Target Audience

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

Prerequisites

This course assumes a reasonable level of database design principles.

Topics

1; Managing Relational Databases
Database Concepts.
Database Design
Normalisation
Database Integrity
Types of Relationship
Creating Table Links
Referential Integrity

2; Advanced Forms Customising
List And Combo Boxes
Check Boxes, Option & Toggle Buttons.
Option Groups
Command Buttons
Calculated Fields.
Using Form’s Input Values
Create A Form With Multiple Pages Or Tabs
Tab Order
Inserting Graphics in Forms or Reports
AutoFormat

3; Optimising and Administering Access
Optimising Performance
The Performance Analyzer
The Add in Manager
Compacting Your Database
The Database Documentor
The Database Splitter
Recovering Damaged Databases
Importing and Linking Tables

Appendix A; Backwards Compatibility
E-mailing Database Information

Appendix B; Introduction to SQL (fundamentals)
Introduction
Data Definition Language
Data Manipulation Language

Course Details

Course Ref:

MSA2016L3

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