Microsoft Access 2007 Tutorials

Free sample tutorial: Security and trusted locations

MS Access Training Sign Up

Express training tutorials will activate instantly after sign up

 

MS Access 2007 Training Course Outline

Introduction tutorial

Basics of Microsoft Access 2007

What's database for?
database objects explained
Converting to Microsoft Access 2007

 

The New MS Access 2007 Interface

The Getting Started interface
Using a database template
The Navigation Pane
Using the Ribbon 1
Using the Ribbon 2
The Create tab
The External Data tab
The Database Tools tab
Using the Office button

 

Customising The Interface

The Quick Access Toolbar (QAT)
Editing the QAT
Access options explained
The Message Bar
Trusted Locations
The Object Window

 

The Navigation Pane

The object categories
The view methods
Searching database objects
Viewing object groups
Creating custom groups
Adding to custom groups
Hiding object groups

 

Tables

Introduction to tables
Creating a table by entering data
Using templates
Planning your database structure
Creating in design view
Data types
Data validation rules
Primary keys
Indexing

 

Relational Database

Viewing relationships
Creating relationships

 

Queries

Select query
Creating calculated fields
Sorting data
Using criteria
Querying multiple tables
Calculate totals

 

Advanced Queries

SQL view
Crosstab queries
Delete queries
Update queries
The Query Wizard

 

Forms

Introduction to forms
The form interface
The form wizard
Starting from a blank form
Designing in layout view
Editing in design view

 

Advanced Forms

Form properties
Form controls
  AutoFormats
  Subforms

 

Reports

Introduction to reports
Report wizard
Report views
Creating a new report
Conditional formatting
Grouping & sorting
  AutoFormats
Applying alternating colours

 

Advanced Reports

Report properties
Advanced editing
Sub-reports
Filtering
Creating mail labels

 

  Microsoft Access Macros

Introduction to Access macros
Macro actions
Macro arguments
The AutoExec macro
Embeding macros