|
|
|
Microsoft Access 2003
Introduction
Two Day Course |
|
| DESCRIPTION : |
This Microsoft Access 2003 Introduction 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.
Warning: Although summarised briefly below, there is a lot of material to cover in two days. |
| PRE-REQUISITES : |
This course is not recommended for new computer users. Participants should be familiar with the Windows operating system and have some experience with the other Microsoft applications such as Excel and Word. Participants need not have any prior knowledge of database concepts. |
| PDF : |
Click here to download a PDF version of this page. |
| |
|
TOPICS : |
Overview
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
|
|
|
|
|
