Microsoft Access 2007/2010: Advanced Skills

Course Overview

This course is designed for Access users with some experience. It can also be taken immediately following our Access Introduction course.

This Microsoft training course will help you stay competitive, sharpen your skills and could enhance your Microsoft career prospects.

Related Courses

• Microsoft Access 2010: Introduction for Beginners
• Microsoft Access 2010: Advanced Level 3
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Fundamentals
• Microsoft Access 2007/2010: Advanced
• Microsoft Access 2010: Specialised
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Advanced
• Microsoft Access 2007/2010: Introduction for Beginners
• Microsoft Access 2007 2010: VBA Programming

Skills Gained

This course is suitable for the 2007 and 2010 versions. After the course, you will be able to:

• Understand Action Queries
• Customise Forms
• Produce Complex Reports
• Manage databases
• Import and Export Data
• Use Macros
• Create Applications

Prerequisites

You must have good basic Windows skills, e.g. Mouse and Keyboard

Course Outline

Action Queries

• The Crosstab Query
• The Make Table Query
• The Append Query
• The Delete Query
• The Update Query

Customising Forms

• Form Wizard
• List And Combo Boxes
• Check Boxes, Option & Toggle Buttons.
• Option Groups
• Command Buttons
• Calculated & Derived Fields.
• Create A Form With Multiple Pages Or Tabs
• Tab Order
• Inserting Graphics in Forms or Reports
• Creating A Form With A Subform
• Form properties

Reports

• The Report Wizard
• Formatting Controls
• Calculated Totals
• Using Expressions
• Parameterised Reports
• Group & Interval Properties
• Page Properties
• Reports As Web Pages

Managing Relational Databases

• Database Concepts & Design
• Normalisation
• Database Integrity
• Types of Relationship
• Creating Table Links
• Referential Integrity

Data Import & Export

• Exchanging Data With External Access And Excel Files
• Linking To Another Access Database
• Linking To An Excel Workbook
• Linked table manager
• Export to various formats

Using Macros

• Creating Macros
• Adding Actions and Arguments
• Adding a Conditions
• Using Trigger Events
• Running Macros From Forms & Reports

Creating An Application

• Using The Switchboard Manager
• Format switchboard forms
• Create a Splash Screen
• Customise a ribbon
• Customise the Quick access toolbar
• Start-up Menu