Overview & Prerequisite

This course is designed for new users of Access 2007 who have attended a Windows Foundation course or who have previous experience in the use of Windows. This course is aimed at those people who will be designing the database

Course content

Getting Started with 2007
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
The New File Menu

Getting Started
Concepts
Screen Layout
Toolbar
Views
Creating Tables
Wizard
New Table
Field Names
Data Types
Primary Key
Properties
Save Table
Print Definition

Datasheet view
Record Entry
Cancel Record
Modify Record
Delete Record
Format Datasheet
Print/Preview
Hide/Show
Sort
Find

Filters
Edit/Sort
Apply
Field Selection

Form
Wizard
Create
Auto Form
Add Record
Views
Design Form
Design Layout
Toolbars
Controls
Selection Techniques
Align Control
Align Text
Vertical Spacing
Horizontal Spacing
Grids
Colour Palette
Adjust Tab Entry

Enhancing the Form
Adding Fields
Combo Boxes
List Boxes
Calculated Fields
Modify Properties

Basic Query
Select Query
Totals
Print Query

Basic Reports
Using Wizards