Access
Upgrade to 2007/2010 (from 2003
)

1 Day (9am to 4pm)
$ 275. or 1
Ticket

Other Access Course Levels

Introduction
Intermediate Level 1
Intermediate Level 2

Queries

Advanced

VBA Level 1

VBA Level 2

Version 2007/2010 Upgrade

Register Now

Contact Us

View PDF Course Outlines for All Access Courses

 

 

 

 

 


Locations

Toronto
20 Queen Street West, Suite 3306
(Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(Yonge St. & Mulock Dr.)

 

 

The release of Office 2007 brought a major change in the way Access databases are built. With the new Ribbon interface both Office 2007 and 2010 approach many tasks, even the simplest ones, in a new way. If you’re comfortable with older versions of Access, you may find yourself floundering for some time before you can become proficient in these new versions. Why not save yourself time and trouble by taking this course and getting Computer Help to show you how to transition to the new Office, rather than having to figure it out on your own?

 

Course Prerequisite:  Required:  This course is not intended for beginners.  An Intermediate or better knowledge of Access (versions 97, 2000, 2002 XP, or 2003) is essential.

 

 

Database

Creating New Database

Using Templates

Converting Existing Databases to 2007/2010

Converting 2007/2010 to older versions

Compact and Repair

 

General

New Interface

The Ribbon

Viewing Objects

Grouping Tables and Related Objects

Creating/Modifying Groups

Object Dependencies

Improved Help Viewer

 

Tables & Queries

Creating and Editing Tables

Alternate Row Colour

Adding Fields in Datasheet View

Field Templates

MultiValue Fields

Calculated Fields (2010)

Attachment Data Type

Choosing Dates with Calendar

Rich Text in Memo Fields

Navigating Records

Formatting Cells

Hiding & Freezing Columns

Totals Row

Sorting, Finding & Search

Multiple Field Indexes

New Filtering Tools

Filter by Form

Use Attachment Fields in Queries

Save Filter as Query/Load Filter from Query

Creating/Editing Queries

 

 

 

Forms

New Quick AutoForms/Auto SubForms

Layout View

Selecting Tools

Split Forms

Navigation Forms (2010)

Application Parts (2010)

Multiple Items

New Form Wizard

Add Logo

Add Title

Conditional Formats

Compare to Other Records (2010)

 

Reports

Report Wizard

New Quick AutoReports

Layout View

Sorting and Grouping

Totals, Counts, etc.

Add Logo

Add Title

Conditional Formats

 

Import/Export

Import from Excel

Saved Imports

Link from Excel

Linked Table Manager

Export to Excel

Saved Exports

Export to Word

Mail Merge with Word

 

 

Versions Toronto North York Mississauga Newmarket
2007 /2010 May 11

 

Mar 28 Apr 18 Feb 27

 

  

Computer Training Courses / SoftSkills Seminars  / Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416-494-4912, Fax: 416-494-9952

www.Computer-Help.ca

Question or Comment - Email Us