Microsoft Access 2007 : Level 3 Training


Untitled Document

Package Includes:
  • 1 DVD-ROM featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Step-by-step hands-on-labs
  • Focused on practical solutions to real-world development problems
  • Free 1 Year Upgrade Policy
OURexpertText
Sandra Batakis

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 15 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000, 2003, 2007 and the new Exchange 2010. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features:

Explore our Training Features

Click on a Feature for more information! (popups must be enabled)
Course Outline TXT
Lesson 1 - Structure Existing Data
Structure Existing Data
First Normal Form
Demo - Table Analyzer
Second Normal Form
Functional Dependency
Third Normal Form
Transitive Dependency
Many-to-Many Relationships
Junction Tables
Demo - Junction Table
Demo - Modify Tables
Lesson 1 Review
Lesson 2 - Writing Advanced Queries
Writing Advanced Queries
Subqueries
Subqueries: Process
Demo - Subquery
SQL
Steps: Create a Subquery in SQL view
Unmatched Queries
Steps: Unmatched Queries
Find Duplicates Queries
Steps: Duplicate Query
Demo - Unmatched and Find Duplicates
Summarize Records using Criteria
Demo - Summarizing Records
Crosstab Query
Demo - Crosstab
PivotTable and PivotChart
PivotChart
Demo - PivotChart
Lesson 2 Review
Lesson 3 - Simplifying Tasks with Macros
Simplifying Tasks with Macros
Macro
Macros
Demo - Macro Form
The Macro Builder Window
Macro Actions
Action Arguments
Demo - Command Buttons and Expressions
Object Events
Macro Conditions
Steps: Restrict Records Using a Condition
Plan a Macro
Embedded Macros
Demo - Mandatory Data Entry and Message Box
Demo - Automate Data Entry
Lesson 3 Review
Lesson 4 - Making Effective Use of Forms
Making Effective Use of Forms
Active X Controls
Form Format Properties
Demo - Calendar Form
Tab Control
Demo - Tab Control
Demo - Pivot
Lesson 4 Review
Lesson 5 - Making Reports More Effective
Making Reports More Effective
Chart
Chart Types
Demo - Chart in Report
Demo - Column Report
Demo - Cancel Printing
Report Snapshot
Demo - Snapshot
Lesson 5 Review
Lesson 6 - Maintaining an Access Database
Maintaining an Access Database
Links to External Data Sources
Linked Table Manager
Demo - Link Tables
Managing a Database
Object Dependencies Task Pane
Demo - Compact and Repair Object Dependencies
Database Documenter
Performance Analyzer
Demo - Performance
Lesson 6 Review
Course Closure



Price: $79.00
Buy Product Online | Visit Store Home
   


 Other Items from Office Users

  Office 2003 MOUS Training - 
  Microsoft Publisher 2003 Training - 
  Microsoft FrontPage 2003 Training - 
  Microsoft Word 2007 : Level 1 Training - 
  Microsoft Word 2007 : Level 2 Training - 
  Microsoft Excel 2007 : Level 1 Training - 
  Microsoft Excel 2007 : Level 2 Training - 
  Microsoft Word 2007 Training - 
  Microsoft Excel 2007 Training - 
  Microsoft Access 2007 : Level 1 Training - 
  Microsoft Access 2007 : Level 2 Training - 

 

  Return To MCSE Training MCITP A+ Certification CCNA CEH Training IT Computer Training, Online, eLearning, Videos and CBT

 

 

shopping carts
Shopping cart powered by MonsterCommerce e-commerce software.