Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2007 - Level 3 - presidio
Provided by: Last Minute Training

Access 2007 - Level 3 - presidio

Access

 Last Minute Training
Training Provided by Last Minute Training The Level 3 course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2007, and it is a prerequisite to take more advanced courses in Microsoft Office Access 2007.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:advanced
Duration:1 days
Training Presented in:English
Click here for more information or to take this course

Access 2007 - Level 3 - presidio Seminar Schedule

Date   Location    
25th Nov, 2009   Winnipeg, MB   [Register]
Access 2007 - Level 3 - presidio Lesson 1: Structuring Existing Data
Topic 1A: Analyze Tables
Topic 1B: Create a Junction Table
Topic 1C: Improve the Table Structure

Lesson 2: Writing Advanced Queries
Topic 2A: Create Subqueries
Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Group and Summarize Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab Query
Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D: Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms
Topic 4A: Display a Calendar on a Form
Topic 4B: Organize Information with Tab Pages
Topic 4C: Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective
Topic 5A: Include a Chart in a Report
Topic 5B: Print Data in Columns
Topic 5C: Cancel Printing of a Blank Report
Topic 5D: Create a Report Snapshot

Lesson 6: Maintaining an Access Database
Topic 6A: Link Tables to External Data Sources
Topic 6B: Manage a Database
Topic 6C: Determine Object Dependency
Topic 6D: Document a Database
Topic 6E: Analyze the Performance of a Database
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Click here for more information or to take this course
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2007 - Level 3 - presidio
Advertise With Us
Do you offer microsoft access 2007 training?
tcw11-gfc-v396M-11/06/09-22:29:05-()[A]-[B]-[A] -07:49:20