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.
Explore our Training Features
Click on a Feature for more information! (popups must be enabled)
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