Access 2003 Introduction

Two Rivers Software Training
Gold Coast, QLD, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This Introduction Microsoft Access course is designed for users who would like to understand the processes involved with setting up a simple database from scratch. It will also help users to find their way around existing database applications within their workplace. Participants will learn how to input, navigate and locate data using tables and forms, filter large volumes of data and consolidate data on a printed report..

TOPICS :
Overview

General database concepts
Becoming familiar with the Access interface
Database Design

Understanding fields, records and tables
Understanding table relationships
Learning the basics of good database design
Introducing normalisation
Applying referential integrity
Tables

Opening and closing a table
Understanding fields and records
Using Design view vs Datasheet view
Moving around a table
Adding a new record
Creating a new table
Table structures
Naming conventions
Field names and descriptions
Setting and changing the primary key
Field properties

Data types
Formatting data
Input masks
Validating data.
Using the lookup wizard
Shortcut keys for data entry
Sorting, filtering and finding records
Changing the order and width of columns
Freezing and hiding columns
Printing data Queries

Using basic queries to filter data
Creating and editing a Select query
Working with criteria
Using query functions
Creating calculated fields
Introducing Make-Table and Update queries
Forms

The purpose of forms
Opening and closing a form
Moving between fields in a form
Browsing existing records using forms
Form design
Adding a new record
Creating a new form using the wizard
Finding records in a form
Using the form toolbox
Selecting, moving, resizing and aligning controls
Moving labels and controls separately
Setting colours
Changing the tab order
Reports

Opening, previewing, printing and closing a report
...''

Phone:0405 760 820

School Address:

PO Box 1354, Southport BC, QLD 4215, Australia

Jobs & Resumes: Gold Coast
Houses & Roommates: Gold Coast

Windows XP
Excel 2003 Introduction
Excel 2003 Advanced
Access 2003 Advanced
Powerpoint 2003
Publisher 2003
Microsoft Project 2003
Dreamweaver
MYOB

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.