Microsoft Access (2007, 2010) (Level 2 / Med.)

Microsoft Access 2007 Level 2 expands on the knowledge gained from the Level 1 course by teaching the student to customize tables, work with forms and form controls, work with reports, and create more advanced queries.

Course Outline

Microsoft Access 2007 Level 2 expands on the knowledge gained from the Level 1 course by teaching the student to customize tables, work with forms and form controls, work with reports, and create more advanced queries.

Course Outline
Section One Advanced File Tasks

• Using My Computer within Access
• Database Management
• Saving Your Files
• Exporting Files
• Linking Files

Section Two Working with Tables

• Customizing Tables
• Formatting Tables
• Controlling Table Data Entry
• Managing Table Data Entry

Section Three Working with Forms

• Basic Form Controls
• Advanced Form Controls
• Formatting Your Form
• Formatting Controls
• Formatting Records

Section Four Working with Reports

• Organizing Report Data
• Formatting Reports
• Common Report Tasks

Section Five Working with Queries

• Basic Queries
• Multiple Table Queries
• Advanced Queries
• Management (Action) Queries

Additional Details

Pre-Requisites

Microsoft Access 2007 Level 1/Introduction

Certificates offered

Certificate of Completion

Cancellation Policy

There is no consequence if you cancel/reschedule this registration with a minimum of 10 business days notice prior to the first day of this course. Full payment is required if you cancel/reschedule this registration within the non-cancellation period of 10 business days prior to the first day of the course. Substitutions are welcome.

Map & Reviews

ctc TrainCanada
[ View Provider's Profile ]

Ottawa Office
Suite 220, 350 Sparks Street
Delta Office Tower
Ottawa, Ontario
Canada   K1R 7S8

Reviews

 

   

This two-day training was jam-packed with information, with a good balance between demonstrations and exercises to verify that the students understood the subject matter. I do not believe that the instructor could have used the time more efficiently then he did.

Reviewed by Yves J. 2011