side bar:  IT Training, computer training in Scotland, Edinburgh iTrain Scotland Logo:  Phone us on 07711 341 320. Superior computer training for microsoft word, excel, access, office 97, office 2000, office xp, macromedia dreamweaver, fireworks, web design side bar:  IT Training, computer training in Scotland, Edinburgh
Go Back to courses
   
Access 2000: Foundation

Overview & Prerequisite

This course is designed for new users of Access 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
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

| home | why choose us | courses | contact us | site map |
2000-2003 iTrain Scotland - Site Last Updated: 29 January, 2003 4:18 PM - Website problems e-mail: Support