Microsoft Access XP - Intermediate
This course will enhance your skills using the Access program. You will learn to: edit database files, set up queries to analyse data, create forms, filter data and design reports.
* Note : This course continues on from the first course - you will need to have completed the entire first course and assignments as you will be building on to these files.

Table of Contents
Create a Table
Default Values
Fields
Creating a Form from Blank
Calling a Toolbar
Adding Headers and Footers
Working with a Form Area
Adjusting the Header Area of a Form
Calling and Moving the Toolbox
Labels
Font, Bold, Size, Center
Background and Text Colour
Form View
Borders and Lines
Properties Window
Moving and Resizing Windows
Inserting and Moving Fields
Field Labels
Deleting Field Labels
Index Tab
Upper and Lower Case Conversion
Calculating Fields
Queries
Creating
Joining Tables
Adding Fields
Setting Criteria's
Creating a Report from Blank
Inserting Pictures
Text Boxes
Date Formula
Sorting and Grouping in Reports
Sum Formula
Page Breaks
Currency Format
Printing
Assignment