Byron Employment

Byron Employment. Over 154,200 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $880.00

Course Outline: Access 2002 - Level 1

Learning Method: Instructor Led

Duration: 2 Days

Overview:
Access 2002 - Level 1 is for the new user of Access and assumes no experience with relational databases. The topics cover creating databases in Access and working with the data by using tables, queries, forms, and reports.

Outline:
Lesson 1: Working with a Relational Database
- Identify Uses of a Relational Database
- Define Database Terminology
- Create a New Database Based on a Template
- Examine the New Database

Lesson 2: Planning a Database
- Identify Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize the Data
- Designate Primary and Foreign Keys
- Identify Table Relationships

Lesson 3: Building the Basic Structure
- Create a Blank Database
- Create a Table using a Wizard
- Compare Datasheet and Design Views
- Create Tables in Design View
- Create Relationships between Tables

Lesson 4: Working with Tables
- Modify a Table Design
- Work in Datasheet View
- Work with Subdatasheets

Lesson 5: Creating and Working with Select Queries
- Examine a Query
- Create a Query using a Wizard
- Work in Query Design View
- Select Records
- Edit Values in a Query Datasheet
- Add a Calculated Field to a Query
- Perform a Calculation for a Group of Records

Lesson 6: Creating and Using Forms
- Create AutoForms
- Create a Form Using a Wizard
- Modify the Design of the Form
- Use Forms to Work with Data

Lesson 7: Creating and Using Reports
- Create an AutoReport
- Create a Report Using a Wizard
- Examine a Report in Design View
- Create a Calculated Field
- Change the Format of a Control
- Change the Style of a Report
- Adjust Report Width

Lesson 8: Managing a Database and Data
- Import Data
- Maintain Record Integrity
- Exporting Data
- Documenting Table Relationships

Lesson 9: Controlling Data Entry
- Make Data Entry More Accurate
- Make Data Entry More Efficient
- Facilitate Data Entry

Lesson 10: Finding and Joining Data
- Find Data with Filters
- Get the Correct Data with Query Joins
- Building Bridges Between the Data
- Relating Data Within a Table

Lesson 11: Creating Flexible Queries
- Summarizing Data with Queries
- Enter Criteria on the Fly
- Maintain Data with Queries

Lesson 12: Improving Your Forms
- Enhance the Appearance of a Form
- Enhance the Usability of a Form
- Make Your Forms More Professional
- Display Form Data from Multiple Tables

Lesson 13: Customizing Your Reports
- Organize Report Information
- Enhance Data Layout
- Working with Report Pagination
- Summarizing Information
- Add a Subreport to an Existing Report
- Creating Mailing Labels

Lesson 14: Making Your Data Available on the Web
- Create a Data Access Page
- Improving the Look of a Data Access Page
- Editing Data Using a Data Access Page
- Group Records in a Data Access Page

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 8263 5906
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 8263 5906 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search