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 2003 - 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
Import Data
Analyze Tables
Create a Junction Table
Improve Table Structure

Lesson 2: Writing Advanced Queries
Create Unmatched and Duplicates Queries
Group and Summarize Records Using the Criteria Field
Summarize Data with a Crosstab Query
Create a PivotTable and a PivotChart
Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
Create a Macro
Attach a Macro to a Command Button
Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros
Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry

Lesson 5: Making Forms more Effective
Change the Display of Data Conditionally
Display a Calendar on a Form
Organize Information with Tab Pages

Lesson 6: Making Reports More Effective
Cancel Printing of a Blank Report
Include a Chart in a Report
Arrange Data in Columns
Create a Report Snapshot

Lesson 7: Maintaining an Access Database
Link Tables to External Data Sources
Back Up a Database
Compact and Repair a Database
Protect a Database with a Password
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