Return to 
Contact Us
Return to
Contact Us
Training participants will learn the essential skills needed to design new databases, improve existing Access databases, and convert databases made in other applications.
Higher level courses are ideal for individuals with experience of database design who are looking to design or improve databases at an advanced level.
Introduction
Learn how to:
Intermediate
Learn how to:
Advanced
Learn how to:
Module 1: Introduction to Databases
• Database Concepts
• Database Layout
• Launching Access
• The Access Menu System
• Dialog Boxes
• Getting Help
• Creating a New Database
• Creating an Access Web App
• Closing a Database (Vs Exit Access)
• Opening a Database.
Module 2: Tables
• Database Design
• Creating Tables Using The Table Wizard
• Creating Tables In The Datasheet View
• Creating Tables In The Design View
• Data Types
• Field Properties
• Data Display Format Vs Input Mask
• The Input Mask
• Data Entry Problems
• Moving And Copying Records.
Module 3: Working with Tables
• Pasting Records
• Sorting The Table
• Deleting a Table
• Table Layout Changes
• Find
• Replace
• Wildcards.
Module 4: Queries
• The Simple Query Wizard
• The Design View
• Modifying The Query
• Using Basic Criteria
• Additional Criteria
• Parameters
• Multiple Object Queries
• Custom Calculations In A Query
• Calculating Fields Continued
• Grouping Fields.
Module 5: Introduction to Reports
• Reports
• The Report Wizard.
Module 6: Introduction to Emailing Database Information
• E-Mailing Database Information.
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.
Module 1: Action Queries
• Types Of Query
• The Crosstab Query
• The Make Table Query
• The Append Query
• The Delete Query
• The Update Query.
Module 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.
Module 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.
Module 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.
Module 5: Backwords Compatibility
• E-mailing Database Information.
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. The course aims to build on some existing database design and/or user experience that may have been gained from the Introduction course.
Module 1: Managing relational databases
• Database Concepts
• Database Design
• Normalisation
• Database Integrity
• Types of Relationship
• Creating Table Links
• Referential Integrity.
Module 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.
Module 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.
Module 4: Backwards Compatibility
• E-mailing Database Information.
Module 5: Introduction to SQL (Fundamentals)
• Introduction
• Data Definition Language
• Data Manipulation Language.
This course assumes a reasonable level of database design principles. The course is designed to build on a reasonable level of database design experience that may have been gained from the Introduction and/or Intermediate course.