Access 2007 Level 1 (Introduction)

In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access(TM) 2007 relational database application.

Course Outline

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

Additional Details

Pre-Requisites

Participants should have basic knowledge of Windows, keyboard and mouse operations.

Certificates offered

Certificate of completion

Cancellation Policy

RESCHEDULING POLICY

Registrants who wish to reschedule their course may do so at least 5 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course. Otherwise, a 20% surcharge is applicable.

CANCELLATION POLICY

Notice received less than 5 working days prior to the course date is subject to a 20% service charge. If the notice is given within 48 hours of the course date, the course is non-refundable. Notice of cancellation must be received by CompuEase 5 working days prior to the confirmed date to obtain a full refund.

Map & Reviews

CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa, ON
Canada   K1P 5M9

Reviews

 

   

The smaller class size allowed for more one-on-one time with the instructor during the hands-on exercises, which optimized the learning experience. The course manual was a bit lacking, but luckily our instructor was a true expert in the field and was able to go into detail and even treat us to more advance applications when he saw that we were ready to take on the more advanced applications. I will certainly be taking another course with the training provider, especially if they continue to provide the student with such stellar instructors!

Reviewed by Cristiane P. 2011