Microsoft Access Level 1
1 or 2 day course depending on experience and requirements

This course is designed for anyone new to Access as well as people who are using Access but are struggling to understand or change existing databases. At the end of the course the learner will be able to create their own database containing tables, forms, queries and reports and confidently understand existing databases. During the course the learner will practice their skills with skill reviews and exercises. An evidence of learning form will be completed during the course and verified by the trainer. This can be used to prove competency in the areas covered by the learner. A certificate of completion will also be issued.

• What is a Database?
• Exploring Database Terminology
• Understanding Database Structure
• Creating a Database Table in Design View and using the Wizard
• Understanding Key Fields
• Editing an Existing Database Table
• Changing Table Field Names, Properties and Structure
• Creating a Form in Design View and Using the Wizard
• Editing an Existing Form
• Add, Move and Delete Controls in a Form
• Using the toolbox to add to a Form
• Using the Format Painter and Navigation Bar in a Form
• Creating a Report in Design View and using the Wizard
• Designing a Report and the functions that can be used
• Using Bound and Unbound Controls in a Report
• Grouping and Sorting within a Report
• Understanding and Creating Sections within a Report
• Creating a Query in Design View and using the Wizard
• Creating Multi-table Queries
• How to Manipulate Tables within the Query Window
• Understanding Calculating Fields
• Creating, Editing and Deleting a Switchboard

Microsoft Access Level 2
1 or 2 day course depending on experience and requirements

This course is aimed at delegates who understand the structure of Access databases and how to create and edit basic Tables, Forms, Queries and Reports. At the end of the course the learner will be able to customise Access and use advanced features to create professional and efficient queries and reports. During the course the learner will practice their skills with skill reviews and exercises. An evidence of learning form will be completed during the course and verified by the trainer. This can be used to prove competency in the areas covered by the learner. A certificate of completion will also be issued.

• Customising Access Menus and Toolbars
• Creating a Subform
• Removing a Form Header and Footer
• Customising a Form
• Creating Nested Subforms
• Creating Expressions in Forms
• Calculating Totals in a Subform
• Creating Custom Calculations
• Using Aggregate Functions with Calculated Fields
• Using Dates in a Query
• Creating Calculated Date Fields
• Creating a Parameter Query
• Creating a Crosstab Query
• Creating an Append Query
• Creating a Select Query
• Customising a Report
• Adding Background Pictures and Colour to a Report
• Creating Command Buttons
• Adding a ScreenTip

Microsoft Access Level 3
1 or 2 day course depending on experience and requirements

• Customising Access Menus and Toolbars
• Importing and Exporting Data
• Setting Access Options Including Error Checking and Macro Security
• Creating, Editing and Assigning Macros
• Exploring Advanced Macros including Using the Visual Basic Editor
• Creating Data Access Pages and using Existing HTML Pages
• Modifying Data Access Pages by Adding Themes
• Creating PivotTables and PivotCharts
• Editing PivotTables and Charts
• Using and Setting Up Parameter Queries
• How to Create and Use Cross Tab Queries
• Establishing Referential Integrity
• Using Cascade Update and Cascade Delete
• How to Define Fields for Indexing
• Exploring Advanced Reporting Features
• Setting up Advanced Queries and Normalizing Your Data

« Back