Access 1 2007

Download PDF

Next Dates:

Tue, 27. Mar. 2012
Wed, 28. Mar. 2012
Thu, 17. May. 2012
Fri, 18. May. 2012

Length:

2 days

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 470

Target audience & Prerequisites:

In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application. Participants should have basic knowledge of Windows, keyboard and mouse operations.

Learning objectives:

You will create and modify new databases and their various objects.

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