MICROSOFT OFFICE 2003 – DATABASES INTERMEDIATE

Module 2 – Intermediate - Microsoft Access

SECTION 1 – REPORTS

The Purpose of a Report

Creating a Report Using the Wizard

Creating an AutoReport

Creating a Blank Report

Amending Report Design

Printing A Report

SECTION 2 – SUB FORMS

SubForms

Using the Subform/Subreport Wizard

Using an Existing Form as a Subform

Using the Form Wizard to create a Form with Subform

SECTION 3 – ENHANCING FORM PRESENTATIONS

Enhancing Form Presentation

SECTIONs

Rulers and Grid

Sizing a Control

Moving a Control

Deleting a Control

Adding Text Labels

Changing the Appearance of a Control

Changing Properties

Changing the Tab Order

Adding Command Buttons

SECTION 4 – ACTION QUERIES

Action Queries

Update Query

Make Table Query

Delete Query

Append Query

Calculated Fields in Queries

Creating Calculated Field

Using the Expression Builder

Update Query – New Field

Cross Tab Query

SECTION 5 – PARAMETER QUERIES

Parameter Queries


 

 

539 Lawmoor Street
Glasgow
G5 0TT

phone: 0870 112 4899
fax: 0870 443 2651
email: info@elitetc.co.uk