Computer Training & Development Australia
Home
Training
Services
Course Schedule
Course Outlines
Affiliates
Contact Us

Book a CourseAccess 2002-2003

Introduction Level Course

Description
This course aims to provide participants with the skills and knowledge to build multi-table databases in Access. It is a complete course at the end of which participants will have constructed a working, practical database application.

Learning Outcomes

Upon completing this course, participants will be able to:

  • Start Access and understand the interface
  • Plan and understand the structure of a database table
  • Design a database structure
  • Create the database file and tables for a relational database
  • Set relationships between tables
  • Add records to tables
  • Import data from other sources into a database
  • Work with records in a table
  • Perform table data validations
  • Create queries in a relational database
  • Create a wide range of Select queries

Pre-requisites

  • Understanding of computers and the ability to use them comfortably. 

Course Content

Access Orientation
Overview of Access 
Starting Access 
The Access Screen
The Database Window
Working With Database Objects
Working With The Menus
Using Keyboard Shortcuts
Short and Long Menus
Exiting From Access 
Database Theory
Overview Of Databases
How Access Stores Data
Spreadsheets Versus Databases
The Advantage of Tables
Database Objects in Access 
Database Design
Designing a Relational Database
Scoping The System
Determine The Inputs
Normalise The Table
First Normal Form
Second Normal Form
Third Normal Form
A Series of Related Tables
Creating The Database
Creating A Database Application
Creating A New Database File
Creating A New Table
Creating A Primary Key
Saving The Table
Modifying A Table Structure
Creating A Table From A Shortcut
Working With Numbers
Creating The Additional Structures
Setting Relationships
Table Relationship Overview
Accessing The Relationships Window
Creating Relationships
Saving The Relationships
Editing A Relationship
Printing The Relationships
Adding Records
Data Entry Overview
Adding Records Directly To A Table
Adding Records With An AutoForm
Data Entry Key Violations
Data Integrity Violations
Importing Records
Overview Of Importing Records
Importing From A Spreadsheet
Importing From A Text File
Backing Up A Table
Importing And Key Violations
Deleting An Unwanted Table
Data Integrity Issues
Working With Records
Managing Data Overview
Navigating Records In A Table
Editing A Record
Deleting Records
Finding And Replacing
Undoing An Error
Compacting A Database
Tables And Sub Datasheets
Assigning A SubDatasheet
Validating Data
Data Validation Overview
Default Values
Required Fields
Validation Rules And Text
Creating A Look-Up
Testing The Validations
Creating Relational Queries
Querying Overview
Creating A Query Design
Understanding The Query Design Window
Selecting Fields For Output
Adding Tables To A Query
Working With Fields In A Query Grid
Selecting Records
Saving And Reusing A Query
Modifying A Saved Query
Select Queries
Overview of Select Queries
Creating AND Queries
Creating OR Queries
Creating Ranges
Opposite Values
Using Wildcards
Problem Selects
Duration 1 day (9:00 am - 4:30 pm)
Venue 3-5 Bennett Street (Gr. Fl.)
East Perth WA 6004
Telephone 08 9221 0688
Facsimile 08 9221 0687

Home | Training | Services | Course Schedule | Course Outlines | Affiliates | Contact Us