major projects for IT training crown software and compter consultancy

Microsoft Access Introduction Course Outline

Course Aims

This one-day course is designed to give you an understanding of some of the major features and functions within Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.

Course Outline

Course Basics
Toolbars
File Management

Introduction to Microsoft Access
What Is Access?
What is a Database
Computerising a Database
Designing an Access Database
Defining a Data Store
Creating Files

Access Interface
Access Workspace

Standard Toolbar
Using the Standard Toolbar

Task Pane
New File
New Database
New From existing file
New from Template
Menu Features

The Database Window
The Database Menu Bar
The Database Window Toolbar

Tables
Table Design
Creating a Table

Working with Tables
Queries
Select Queries
Selecting Queries
Selecting Fields
Sorting Records in a Query
Refining Results of a Query
Performing Calculations with Queries
Joining Tables Within a Query

Forms
Using and Creating Forms
Displaying and Linking Images
Replacing Images

Reports
Creating Reports
Using Auto Report
Creating a Report in Design Mode
Totals in Reports
Saving a Report
Printing a Report

Target Audience

New, recent or intending users of MS Access who have little or no existing database knowledge.

Assumed Knowledge

A working knowledge of PCs and Windows is assumed, gained from the workplace or by prior attendance on an "MS Windows User Introduction" course.

Related Courses

Access Intermediate and Advanced; Windows; other MS Office Applications

IT training microsoft office lotus smartsuite

For further information e-mail:info@major-projects.co.uk
All site content is © Major Projects Limited | Website design is © Ambrow Limited