Specific Learning Outcomes

Access 2003 Orientation

1. Starting Access 2003
2. Opening an Existing Database
3. The Access 2003 Database Screen
4. The Database Window
5. Working with Database Objects
6. Using Menu Commands
7. Using Keyboard Shortcuts
8. Exiting from Access 2003

Database Theory

1. Understanding Databases
2. How Access Stores Data
3. Spreadsheets Versus Databases

Database Design

1. Designing a Relational Database
2. Scoping the System
3. Determining the Inputs
4. Normalising a Table
5. First Normal Form
6. Second Normal Form
7. Case Study
8. Third Normal Form

Creating Relational Databases

1. Creating a New Database File
2. Access 2003 Data Types
3. Creating a New Table
4. Changing Field Properties
5. Creating a Table from a Shortcut
6. Creating a Table with Numbers and Currency
7. Assignment - Creating Tables

Setting Table Relationships

1. Understanding Table Relationships
2. Accessing the Relationships Window
3. Table Joins in the Alpheius Case Study
4. Creating Table Joins
5. Assignment – Creating Relational Joins
6. Editing an Existing Relationship

Adding Relational Records

1. Adding Records an a Table
2. Adding Records Using an AutoForm
3. Assignment - Adding Records
4. Data Entry Key Violations
5. Data Integrity Violations

Importing Records

1. Importing From a Spreadsheet
2. Importing From a Text File
3. Backing up a Table
4. Importing and Key Violations
5. Deleting an Unwanted Table
6. Data Integrity and Importing

Working with Records

1. Navigating in a Table
2. Editing a Record
3. Deleting a Record
4. Deleting Several Records
5. Finding and Replacing
6. Undoing an Error
7. Compacting a Database
8. Printing Records
9. Assigning a Sub Datasheet
10. Working with Sub Datasheets

Relational Queries

1. Relational Queries - How they Work
2. Queries for Viewing Data
3. Creating a Query Design
4. Selecting Fields for the Query Grid
5. Different Views of a Query
6. Adding More Tables to a Query
7. Modifying Fields in a Query
8. Selecting Records Using a Query
9. Running a Query from the Database Window

Relational Select Queries

1. Creating AND Queries
2. Clearing the Criteria from a Query
3. Selecting Numeric Data
4. Selecting Dates in a Query
5. Creating OR Queries
6. Using a Range Expression
7. Selecting Opposite Values
8. Using Wildcards
9. Problem Selects

Creating Forms

1. Forms - How They Work
2. Creating a Single Table Form
3. Working with a Form
4. Creating a SubForm
5. Creating a Linked Form

Creating Reports

1. Reports - How they Work
2. Creating a Single Table Report
3. Previewing a Report
4. Creating a Multi-Table Report
5. Creating a Report From a Query

General Computer Usage

1. The Help Task Pane
2. Searching for General Help
3. Searching for Specific Help
4. Understanding a Help Window
5. Disabling Online Content
6. Enabling Online Content
7. Displaying and Using the Office Assistant
8. Customising the Office Assistant
9. Disabling the Office Assistant
10. Using What's This and Screen Tips
11. Setting up an Ergonomic Workstation
12. Breaks and Exercises

Printable Brochure
Self-Assessment Checklist
Request More Information