Customized Microsoft Office Access 2007 Training

Do know that you can have the Microsoft Access 2007 training the way you want it? Here is how:

Step 1) Highlight and email us the topics you are interested in;
Step 2) Include your preferred training format: hands-on or presentation-based and estimate number of attendees;
Step 3) Tell us your preferred training modality: onsite at your office, live online, off site at Solartech or third party locations.

The Fundamentals

Introduction to Databases

Starting Access 2007

The Getting Started Page and Opening a Database

What’s New in Access 2007

Understanding the Access Program Screen

Understanding the Ribbon

Using the Office Button and Quick Access Toolbar

Using Keyboard Commands

Using Contextual Menus

Using Help

Database Basics

Working with Database Objects

Tour of a Table

Adding, Editing and Deleting Records

Tour of a Form

Tour of a Query

Tour of a Report

Previewing and Printing a Database Object

Selecting Data

Cutting, Copying and Pasting Data

Using Undo and Redo

Checking Your Spelling

Using the Zoom Box

Exiting Access 2007

Creating and Working with a Database

Planning a Database

Creating a New Database

Creating a Table

Modifying a Table

Creating a Query

Sorting a Query

Using AND and OR Operators in a Query

Creating a Form with the Form Wizard

Creating a Report with the Report Wizard

Creating Mailing Labels with the Label Wizard

Converting an Access Database

Finding, Filtering, and Formatting Data

Finding and Replacing Data

Sorting Records

Using Common Filters

Filtering by Selection

Filtering by Form

Creating an Advanced Filter

Adjusting and Rearranging Rows and Columns

Changing Gridline and Cell Effects

Changing the Datasheet Font

Freezing a Column

Hiding a Column

Working with Tables and Fields

Understanding Field Properties

Indexing a Field

Adding a Primary Key to a Table

Inserting, Deleting, and Reordering Fields

Adding Field Descriptions and Captions

Changing the Field Size

Formatting Number, Currency, and Date/Time Fields

Formatting Number, Currency, and Date/Time Fields by Hand

Formatting Text Fields

Setting a Default Value

Requiring Data Entry

Validating Data

Creating an Input Mask

Creating a Lookup Field

Creating a Value List

Modifying a Lookup List

Creating Relational Databases

Understanding Table Relationships

Creating Relationships Between Tables

Enforcing Referential Integrity

Printing and Deleting Relationships

Understanding Relationship Types

Working with Queries

Understanding Different Types of Queries

Creating a Multiple Table Query

Creating a Calculated Field

Working with Expressions and the Expression Builder

Using an IIf Function

Summarizing Groups of Records

Display Top or Bottom Values

Parameter Queries

Finding Duplicate Records

Finding Unmatched Records

Crosstab Queries

Delete Queries

Append Queries

Make-Table Queries

Update Queries

Working with Forms

Creating and Using a Form

Understanding Form Views

Modifying a Form in Layout View

Form Design View Basics

Changing Tab Order

Working with Control Properties

Control Property Reference

Working with Form Properties

Form Property Reference

Changing a Control’s Data Source

Creating a Calculated Control

Changing a Control’s Default Value

Creating a Subform

Modifying and Working with Subforms

Working with Reports

Creating a Report

Working in Layout View

Adding a Logo

Working in Design View

Adjusting Page Margins and Orientation

Adding Page Numbers and Dates

Grouping and Sorting

Summarize Data using Totals

Understanding Report Sections

Formatting Forms and Reports

Formatting Fonts

Changing Text Alignment

Changing Colors

Applying Special Effects

Using Conditional Formatting

Adding Pictures, Lines and Gridlines

Working with Number Formatting

Using AutoFormat

Working with Macros

Creating and Running a Macro

Editing a Macro

Working with Macro Groups

Assigning a Macro to an Event

Creating Conditional Expressions

Assigning a Macro to a Keystroke Shortcut

Macro Action Reference

Advanced Topics

Importing Information

Exporting Information

Linking Information from an External Source

Using Hyperlink Fields

Displaying Database Object Dependencies

Setting a Password in Access

Compacting and Repairing a Database