Upgrade to Access 2007
1 Day Course

This course is designed for delegates that feel confident in Access but needs to adjust to the new 2007 interface. At the end of the course the learner will feel confident in using 2007 and understand where they can look for help as well as having learned some extremely useful time saving techniques. The course focuses on the areas of Access that have changed the most in 2007.  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.

• Using the Getting Started Window
• The Trust Center
• Getting Help in 2007
• The New Interface
• Using the Quick Access Toolbar
• Basics of Ribbons
• The Home Ribbon
• The Create Ribbon
• The External Data Ribbon
• The Database Tools Ribbon
• Viewing Data
• Printing a Database Object
• Exporting Files
• Exporting your Form
• Linking Files
• Referential Integrity
• Switchboards
• Using Microsoft Outlook and SharePoint with Access 2007

Microsoft Access Level One
1 or 2 day course depending or 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 Two
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, create PivotTables, create and edit Macros 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
• 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