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 - Controlling Data Entry
Controlling Data Entry
Field Properties
Input Masks
Input Mask Wizard
Lookup List Fields
Lookup Wizard
Demo - Field Properties
Demo - Input Mask
Demo - Lookup Fields
Lesson 1 Review
Lesson 2 - Joining Tables
Joining Tables
Query Joins
Inner Join
Left Outer Join
Right Outer Join
The Join Properties Dialog Box
Self Joins
The Alias Property
Demo - Inner and Outer join
Demo - Join
Lesson 2 Review
Lesson 3 - Creating Flexible Queries
Creating Flexible Queries
Select Query Properties
Parameter Queries
The Like Operator and Wildcards
Common Wildcards
Other wildcards
Append Query
Action Queries
Update Query
Delete Query
Make Table Query
Demo - Query Properties
Demo - Parameter Queries
Demo - Action Query
Lesson 3 Review
Lesson 4 - Improving Forms
Improving Forms
Design Tools
Layouts
Types of Layouts
Control Padding – Narrow, Medium or Wide
Sort Data Within Forms
Anchor & Form Controls
Control Grouping and Ungrouping
Conditional Formatting
Control Wizards
Combo Box Control
List Box Control
Option Group Control
Command Buttons
Subforms
Demo - Modify Form
Demo - Sorting and Filtering
Demo - Format Form
Demo - Option Buttons
Demo - Subforms
Lesson 4 Review
Lesson 5 - Customizing Reports
Customizing Reports
Report Design
The Group, Sort and Total Pane
The Totals Feature
The Field List Pane
The Rich Text Support Feature
Report Pagination
Summarize Report Information
Subreports
Demo - Create a Report
Demo - Group Sort
Demo - Format Report
Demo - Pagination
Demo - Subreports
Lesson 5 Review
Lesson 6 - Sharing Data Across Applications
Sharing Data Across Applications
Options for Importing Data
Delimiters
Exporting Data
Mail Merge Task Pane
Demo - Import Excel
Demo - Import Export CSV File
Lesson 6 Review
Course Closure