Related Services

Introduction to Internet
Introduction to Word
Introduction to Database
Introduction to Excel
Introduction to Publisher
Introduction to Computers

Introduction to Access

Would you like to learn about databases?

This instructor-led course, through lecture and hands-on experience will provide the skills needed to implement your own relational database, define forms, add and edit records, create queries to extract information in Microsoft Access.

Gold colour of setting sun on canvass in Victoria square

Time Table

???day: ?am - ?pm

Benefits:

Participants will be awarded a Certificate of Attendance upon successful completion of the course.

Learn at your own pace with individual coaching by our expert course facilitators.

Create professional looking database and records that will bring the desired results and impact to your personal household and business contacts and expenditures.

Focuses on real tasks that reflect on how the software is used in professional situations.

Course Contents:

Basics of an Access Database

What is a Database?

Opening and Reviewing a Database

Reviewing Important Screen Elements

Understanding the Main Database Objects

Steps to Designing a Database

Ceating an Access Database

Creating a New Database

Creating New Tables and Defining Fields

Opening a Table

Modifying a Table?s Structure

Relating and Linking Tables

Entering Data and Working with Tables

Adding New Records

Using Data Entry Shortcuts

Editing Information and Undoing Changes

Customising the Datasheet

Closing a Table

Entering Related Data into a Child Table

Deleting Records

Creating Forms to Help Enter Data

Creating a Form Using the Form Wizard

Opening, Closing and Customising Forms

Understanding Form Sections

Navigating Between Records on a Form

Adding and Deleting Records

Printing Information on a Form

Creating Queries to Extract Information

Reviewing Data Types and Criteria Examples

Building a Query

Specifying the Fields

Writing Criteria in Yes/No Fields

Viewing or Running the Query

Opening and Modifying a Query

Sorting Query Results

Printing Results of a Query

Specifying Criteria in a Text Field

Using Wildcards when Specifying Criteria

Writing Criteria in a Numeric Field

Writing Criteria in a Date/Time Field

Using the 'OR' Criteria

Creating Basic Reports

Creating a Report base on a Query

Modifying and Customising Reports

Understanding report Section

Modifying Page Setup Options

Changing the Title of a Report

Inserting Additional Fields

Saving, Closing, Opening and Printing a Report

Creating Mailing Labels

Finding, Sorting and Filtering Records

Navigating Through a Table

Finding a Specific Record

Sorting Records

Filtering Records

Time Table:

Time: ??am - ??pm
Days: ??
Duration: ? Days
Location: ??

Round 1

???

Round 2

???

Our computer Training Room has 12 new computers with broadband Internet access and the latest version of Microsoft Office.

Funded by the Department of Futher Education, Employment, Science & Technology