Microsoft Office 2007: Access Basic

COURSE OVERVIEW

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.

With its Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge, Microsoft Office Access 2007 helps you track and report information with ease. Get started quickly with prebuilt applications that you can modify or adapt to changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Share information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals.

YOUR INSTRUCTOR

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.

FEATURES

Main Menu
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease.

Resume
Every course resumes where you finished during the previous session in case you forget where you stopped.

Live Demonstrations
Instructors provide live and "hands on" demonstrations to explain and show users how to complete tasks. This enables users to witness professionals perform everyday tasks in real world settings as often as they like.

Topic A: Creating Forms
A Sample Form
Form in Design View
Form Tools on the Design Tab
Form Tools on the Layout Tab
Demo A-1: Examining a Form
The Form Feature
A Basic Columnar Form
Demo A-2: Creating a Basic Form
The Form Wizard
Demo A-3: Creating a Form Using the Form Wizard
Topic B: Using Design View
Creating Forms in Design View
Demo B-1: Creating a Form in Design View
Adding a Control
Demo B-2: Addings Controls
Property Sheet
Modifying Section Properties
Demo B-3: Modifying Properties
Conditional Formatting
Demo B-4: Applying Conditional Formatting
Topic C: Sorting and Filtering Records
Sorting Records
Demo C-1: Using a Form to Sort Records
Filtering Records
Demo C-2: Using a Form to Filter Records
Unit 06 Review