Access 1 2003

Download PDF

Next Dates:

Thu, 23. Aug. 2012
Wed, 22. Aug. 2012
Wed, 30. May. 2012
Thu, 31. May. 2012
Mon, 16. Jul. 2012
Tue, 17. Jul. 2012

Length:

2 days

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 470

Target audience & Prerequisites:

This Course is designed for participants who have little or no knowledge of MS Access. Participants should have basic knowledge of Windows, keyboard and mouse operations.

Learning objectives:

On completion of course, participants will be able to design and modify tables, create relationships, use queries, design and modify forms and reports.

Course Outline:

THE BASICS

Database Concepts and Terminology
Creating a Database
Converting Access Files
Working with Objects

TABLE DATA

Table Concepts
Viewing Data in a Table
Changing the Datasheet Appearance
Entering and Editing Data
Applying a Filter

TABLE DESIGN

The Table Wizard
Changing the Table Design
Creating a Table in Design View

DATA ENTRY

Data Entry Concepts
Data Formats
Adding records

RELATIONSHIPS

Understanding Relationships and the primary key

CREATING AND USING FORMS

Creating and Opening Forms
Changing a Form Design

QUERIES

Building Queries
Selecting and Sorting in a Query

REPORTS

Creating and Previewing Reports
Modifying Report Design

PRINTING

Printing Objects
Page Setup Options

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List