Access 1 2007

Download PDF

Next Dates:

No dates available yet

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