Byron Employment

Byron Employment. Over 71,594 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $325.00

Course Overview

This course has been designed to introduce new users to Access 2003 databases.  Students will learn about the components of a database, and the necessary procedures to ensure the integrity of data is maintained in a database.

Prerequisites

Participants must have basic windows environment skills.

Duration

1 day

Delivery

Classroom

Course Outline

Working with Databases

  • Overview of relational databases
  • Spreadsheets -v- databases
  • How Access stores data

Starting Access

  • Opening an existing database
  • Screen components of the Access window

Working with Tables

  • Opening and closing a table
  • Understanding fields and records
  • Moving around records in a datasheet
  • Identifying records
  • Adding a new Record
  • Columns widths and Row heights
  • Moving and Hiding/unhiding columns
  • Freezing columns

Working with Forms

  • Overview of forms and their use
  • Opening a Form
  • Moving around fields in a form
  • Moving between records using a form
  • Adding new records with a form
  • Closing a form
  • Using different Form views
  • Switching between form view

Working with Data

  • Editing Data
  • Finding and Filtering Records
  • Deleting Records
  • Sorting Data
  • Using forms with subforms

Creating Tables

  • Table structures in Access
  • Planning tables
  • Standard naming conventions
  • Field names and descriptions
  • Understanding Primary Keys
  • Setting a Primary key
  • Changing the Primary key

Table Properties

  • Understanding and setting Field properties
  • Setting Data types
  • Formatting data
  • Using input validation rules to control input
  • Using an input mask to assist data entry
  • Entering data into a table
  • Using Shortcut keys for text entry
  • Printing data from a table

Editing Properties

  • Changing the data type of a field
  • Renaming a field
  • Adding a lookup field with the wizard
  • Finding a record

Other Courses in the Series - Microsoft Access 2000/2002/2003

CTS784 Access 2000/2002/2003 - Introduction (Creating Databases)
CTS785 Access 2000/2002/2003 - Intermediate
CTS787 Access 2000/2002/2003 - Advanced
CTS778 Access 2000/2002/2003 - Queries & Reports
CTS779 Access 2000/2002/2003 - VBA

Refer also Microsoft Access 2007 courses

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (07) 3210 0002
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (07) 3210 0002 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search