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 - Exploring the Access Environment
Exploring the Access Environment
The Getting Started With Microsoft Office Access Window
The Microsoft Office Button
The Ribbon
ScreenTips
The Quick Access Toolbar
The Navigation Pane
Demo - Navigation
The Tabbed Document Window Viewing Feature
The Microsoft Office Window Frame
Galleries
The Home Tab
The Create Tab
The External Data Tab
The Database Tools Tab
Dialog Box Launchers
Contextual Tabs
The Access Options Dialog Box
Demo - Customize Options
Lesson 1 Review
Lesson 2 - Creating Tables and Forms
Creating Tables and Forms
The Field Insertion Feature
Data Types
Rich Text Memo Field
Auto Calendar
Field Templates Task Pane
Demo - Create a Table
Multivalued Fields
Alternate Background Color
Form Creation Tools
Demo - Create a Form
Demo - Modify a Form
Layouts
Types of Layouts
The WYSIWYG Interface
Lesson 2 Review
Lesson 3 - Creating Queries and Reports
Creating Queries and Reports
The Query Wizard
The Query Design Feature
Advanced Querying Options
Demo - Create a Query
Embedded Macros
The Report Design Feature
The Report Wizard
The Report Feature
Demo - Create and Format a Report
The Grouping Feature
Sort Data
The Totals Feature
Filter Data
The Rich Text Support Feature
Lesson 3 Review
Lesson 4 - Working with External Data
Working with External Data
Options for Importing Data
Demo - Import Excel Data
Demo - Import a CSV File
Options for Exporting Data
Demo - Export Data to Excel
Lesson 4 Review
Course Closure