Word Processing Services in Toronto Ontario, Night School Toronto, Web Design School in Toronto, Graphic Design Schools in Toronto.
IT, Engineering & Executive Recruitment Specialists, Professional Resume Writing, Interview Coaching and Skills Development

Microsoft Access 2007 - Level 2

Duration: One Day(10AM to 4PM with One Hour Lunch Break)
                  (Weekdays & Saturday)

Cost: $699 +HST

Class Size: 1-3 Persons,Instructor lead training

Course Outline

Lesson 1: Structuring Existing Data
Analyze Tables
Create a Junction Table
Improve Table Structure
Lesson 2: Writing Advanced Queries
Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Lesson 4: Making Effective Use of Forms
Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot
Lesson 6: Maintaining an Access Database
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

For more information please call us at (647) 271-3330 or Email us at: support@writing4careers.com



2010 | All rights reserved | Webmaster: Rachel Ma