Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Access 2007 Course

Microsoft Access 2007 Self Paced Training Course

Course Description: Introduces the new features and functions of Access 2007, while training students on all the core, intermediate and advanced operations available in Access 07.

Price: 6-month User License: $99.00
Price: 12-month User License: $129.00

6-month license

12-month license

free demo

Microsoft Access 2007 Self-Paced Course Syllabus

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
Using Keyboard Commands
Understanding the Ribbon
Using the Office Button and Quick Access Toolbar
Using Contextual Menus
Using Help

Database Basics

Working with Database Objects
Tour of a Table
Adding, Editing, and Deleting Records
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
Developing 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
Using 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 the 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
Displaying 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
Changing a Control's Data Source
Form Property Reference
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

Special Offers!

Special Offer: Get this class, along with all of our other available Microsoft Office self-paced training courses for only $149. See what is included in the Microsoft Office value package.

Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)

Business Computer Skills BBB Profile