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
    LevelIntermediate
    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 Intermediate

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

Working with Data

Moving Through Datasheets
Adding Records
Editing Records
Deleting Records
Keyboard Shortcuts

Working with Datasheets
Modifying Datasheet Format
Modifying Datasheet Font
Modifying Column Widths
Hiding/Showing Columns
Moving Columns

Manipulating Data
Sorting Data
Finding Data
Filtering Data
Filter Excluding Selection
Filter for Input
Filter by Form
Saving As Query

Working with Table Structure
Manipulating Fields
Changing Data Types
Deleting Fields
Moving Fields
Using Name Auto-Correct
Property Update Options
Creating Look-up Fields
Using Look-up Wizard

Dependencies & Datasheets
Checking Object Dependencies
Subdatasheets
Manipulating Subdatasheets

Shaping Up Tables
Copying
Renaming
Deleting
Printing Tables

Importing & Exporting
Importing
Import Spreadsheet Wizard
Exporting

Relationships
Understanding Relationships
Referential Integrity
Join Types
Understanding Join Types
Relationship Types

Creating Relationships
Relationship Setup
Adding Tables
Arranging Tables
Create Permanent Relationship
Printing Relationships
Pre-requisites
None
CourseAccess Learning CDs
LevelIntermediate
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