Microsoft Access Training - Foundation Course

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

Who Should Attend

The Microsoft Access training 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.

Venue & Duration

This is a two-day course held either at Smart Learning Solutions premises or on-site.