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



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


Relational Database

Viewing relationships
Creating relationships



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



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



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


Advanced Reports

Report properties
Advanced editing
Creating mail labels


  Microsoft Access Macros

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