Processing your application. Please be patient while we make sure we receive every piece of it.
Office 2007 Applications
Access 2007 Level 2
1 Day
Guaranteed To Run
Wednesday
Feb 22
Toronto
  $295
Thursday
Feb 23
Toronto
  $295
Thursday
Mar 02
Toronto
  $295
Thursday
Mar 09
Toronto
  $295
Tuesday
Mar 21
Toronto
  $295
Tuesday
Mar 28
Toronto
  $295
Wednesday
Mar 29
Toronto
  $295
Tuesday
Apr 18
Toronto
  $295
Wednesday
Apr 19
Toronto
  $295
Wednesday
Apr 26
Toronto
  $295
Thursday
Apr 27
Toronto
  $295
REQUEST
PRIVATE SESSION
COURSE DESCRIPTION
OVER
VIEW
+
OBJEC
TIVES
+
AUD
IENCE
+
PRERE
QUISI
TES
+
OUT
LINE
+
You have the basic skills needed to work with Microsoft® Office Access™ 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
Lesson1: Controlling Data Entry
Topic 1A: Restrict Data Entry Using FieldProperties
Topic 1B: Establish a Pattern for EnteringField Values
Topic 1C: Create a List of Values for aField

Lesson2: Joining Tables
Topic 2A: Create Query Joins
Topic 2B: Join Unrelated Tables
Topic 2C: Relate Data Within a Table

Lesson3: Creating Flexible Queries
Topic 3A: Set Select Query Properties
Topic 3B: Create Parameter Queries
Topic 3C: Create Action Queries

Lesson4: Improving Forms
Topic 4A: Design a Form Layout
Topic 4B: Enhance the Appearance of a Form
Topic 4C: Restrict Data Entry in Forms
Topic 4D: Add a Command Button to a Form
Topic 4E: Create a Subform

Lesson5: Customizing Reports
Topic 5A: Organize Report Information
Topic 5B: Format the Report
Topic 5C: Set Report Control Properties
Topic 5D: Control Report Pagination
Topic 5E: Summarize Report Information
Topic 5F: Add a Subreport to an ExistingReport
Topic 5G: Create a Mailing Label Report

Lesson6: Sharing Data Across Applications
Topic 6A: Import Data into Access
Topic 6B: Export Data
Topic 6C: Analyze Access Data in Excel
Topic 6D: Export Data to a Text File
Topic 6E: Merge Access Data with a WordDocument

SITE MAP