Microsoft Access 2007 : New Features

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.

Package Includes:

Featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Step-by-step hands-on-labs
Exclusive LearningZone Live Mentor - (Value at $195)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
Focused on practical solutions to real-world development problems
Free 1 Year Upgrade Policy

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 10 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 and the new Exchange 2007. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features:

Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.
Certificate of Completion
Our training is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Distance Education Certificate of Completion.

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