Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5

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 Start Date: Nov. 8
  • Location: Ottawa (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 2 Days
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Microsoft Access Training Seminars and Courses

Course Outline

Course Length: 12hrs (2 Days)
In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft 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:

Section 1: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: Using the Getting Started Window
Lesson 1.3: The Trust Center
Lesson 1.4: Getting Help

Section 2: The New Interface
Lesson 2.1: Using the Quick Access Toolbar
Lesson 2.2: Basics of Ribbons
Lesson 2.3: The Home Ribbon
Lesson 2.4: Create Ribbon
Lesson 2.5: External Data Ribbon
Lesson 2.6: Database Tools Ribbon

Section 3: Creating a Database
Lesson 3.1: First Steps
Lesson 3.2: About Records
Lesson 3.3: Creating a Table
Lesson 3.4: Formatting Text

Section 4: Doing More with Your Database
Lesson 4.1: Creating Forms
Lesson 4.2: Creating Queries
Lesson 4.3: Reports
Lesson 4.4: Sorting and Filtering Data
Lesson 4.5: Viewing Data
Lesson 4.6: Printing a Database Object

Section 1: Advanced File Tasks
Lesson 1.1: Using My Computer within Access
Lesson 1.2: Database Management
Lesson 1.3: Saving Your Files
Lesson 1.4: Exporting Files
Lesson 1.5: Linking Files

Section 2: Working with Tables
Lesson 2.1: Customizing Tables
Lesson 2.2: Formatting Tables
Lesson 2.3: Controlling Table Data Entry
Lesson 2.4: Managing Table Data Entry

Section 3: Working with Forms
Lesson 3.1: Basic Form Controls
Lesson 3.2: Advanced Form Controls
Lesson 3.3: Formatting Your Form
Lesson 3.4: Formatting Controls
Lesson 3.5: Formatting Records

Section 4: Working with Reports
Lesson 4.1: Organizing Report Data
Lesson 4.2: Formatting Reports
Lesson 4.3: Common Report Tasks

Section 5: Working with Queries
Lesson 5.1: Basic Queries
Lesson 5.2: Multiple Table Queries
Lesson 5.3: Advanced Queries
Lesson 5.4: Management (Action) Queries

Prerequisites & Certificates

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

Certificates offered

Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support

Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.

Map & Reviews
[ View Provider's Profile ]

CompuEase Training Classroom
130 Albert Street
Suite 801

Ottawa, ON
Canada   K1P 5G4

Good Course ~ Thank you :)
Reviewed by 2014
The course was great! Enjoyable and everything it said it would be.
Reviewed by 2012
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 2011
8-November-2018 $695 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 21 times.