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
    LevelAdvanced
    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 Advanced

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

Select Queries

Creating in Design View
Sorting
Adding Additional Tables
Changing Relationship Type
The Show Box

Filtering with Criteria
- Exact Entries
- Comparison Operators
- Filter Range
Null/Not Null
Using "And" Statements
Either "Or" Statements
Unique Values

Calculations
Formulas
Group By
Concatenation

Intro to Forms
Creating Auto Forms
Form Components
Working with Controls
Aligning Controls
Removing Controls
Adding Controls
Using the Forms Wizard

Working in Forms
Formatting Forms
Control Properties
Navigating a Form

Data Access Pages
Save Form As
Using the Page Wizard
Apply Themes
Preview in Browser

Working with Reports
Creating Auto Reports
Using the Reports Wizard
Report Controls & Sections
Modifying Controls
Changing Sorting & Grouping
Controlling Page Breaks
Report Output Options
Exporting to Word

Maintaining Database
Using Compact & Repair
Backing up Data
Convert Database
Pre-requisites
None
CourseAccess Learning CDs
LevelAdvanced
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