Microsoft Access 2007 Introduction

Course Overview

Introducing Microsoft Access

• Understanding Databases
• Starting Microsoft Access
• Opening and Closing a Database
• Creating a New Database
• Setting Tabbed Documents View

Working with Tables

• Designing Database Tables
• Creating a New Table
• Adding Records to a Table
• Opening a Table
• Editing Records in a Table
• Printing a Table

Managing Tables and Fields

• Switching between Views
• Changing Field Properties
• Adding and Removing Primary Keys

Managing Data in Tables

• Moving around the Datasheet
• Copying and Moving Information
• Finding Data in Tables
• Deleting Records
• Sorting Records
• Indexing Fields
• Creating Calculations in Tables
• Working with Filters

Managing Table Relationships

• Understanding Table Relationships
• Creating Table Relationships
• Editing Existing Table Relationships
• Deleting Table Relationships
• Understanding Referential Integrity
• Multi-Table Datasheet View
• Using the Table Analyzer

Working with Queries

• Understanding Queries
• Creating a Query
• Specifying a Sort Order and Criteria
• Excluding Fields
• Viewing the Dynaset
• Changing Queries
• Saving the Query
• Querying Multiple Tables

Working with Query Expressions

• Querying Records with Wildcard Characters
• Querying a Range of Records
• Specifying Multiple Criteria
• Creating Calculated Fields
• Formatting Fields in a Query
• Working with Parameter Queries

If booking for more than one delegate, please contact us on 01189 778560 for discounted prices.