Please choose the course you would like to do using the browser below.

  • Text search all courses
    Please enter a search term below i.e. white for Whitecard

  • Browse Short courses
    Campus
    Category
    Course

  • Browse Online / CD courses
    Category
    Course

    CourseAccess Learning CDs
    LevelIntroduction
    Version2003
    Duration (days)N/A
    Fee$315
  • Browse Qualifications and Traineeships
    Traineeships

  • Search by date
    Please enter a date range below to find available courses
    From  to 







Provider: 1816

Access Learning CDs 2003 Introduction

 
Course aim
This course aims to develop skills using Microsoft Access to produce and databases to an Introductry level.
Course outline
The CD course covers:

Introduction

Relational Databases
Flat System
Relational System
Database Components

Database Objects
Tables
Queries
Forms
Reports
Macros
Modules
Data Access Page

Database Planning
Naming Conventions
Convention Examples
Database Design
Plan Purpose
Plan Tables
Plan Fields
Field Names
- Plan Relationships

Examining Access
Starting Access
Table View
Switching Views
Query View
Forms View
Report View
Create New Database
Database Wizard

Creating Tables
File Format Considerations
Create Table
Data Type
Description
Assign Primary Key
Saving
Using the Table Wizard

Text Field Properties
Field Size
Format
Caption
Default Value
Required
Allow Zero Length
Numbered Text Fields
Input Mask

Number Field Properties
Number Field Size
Format Date
Validation Rule
Validation Text
Validation Data
End Date Validation Rule
Pre-requisites
None
CourseAccess Learning CDs
LevelIntroduction
Version2003
Duration (days)N/A
Fee$315
BrochurePrint version






OR

Call now on: 07 3510 8018

OR




Related courses
Classes


Online / Distance

 · Excel Learning CDs 2003 Intro-Adv
 · Outlook Learning CDs 2003 Advanced
 · PowerPoint Learning CDs 2003 Intro-Adv
 · Publisher Learning CDs 2003 Intro-Adv
 · Word Learning CDs 2003 Intro-Adv