Microsoft Access 2007 : New Features
 Instructor
Course Outline
|
  Online Delivery
$95
$95
DVD-ROM Delivery
$95
$95
 DVD Lending License
$238
$238
|
COURSE OVERVIEW
Sign up for our classroom training taught by expert trainers and never get behind or miss a single session. You determine when and where to complete training. We collaborated with leading certified instructors to create state-of-the-art training programs developed for individuals preparing for certification examinations.
Microsoft Office Access 2007 comes with interactive functions and the Microsoft Office Fluent user interface to simplify record keeping and tracking. It can be easily utilized by inexperienced users. It also comes with pre-built applications that can be easily altered to satisfy each organization's business needs. You can gather information through e-mail or import information from other sources. It's also possible to edit reports that organize, filter, or sort data with Access, making it possible for managers responsible for organizational decisions to make sense of large quantities of information. Transfer data by moving Access 2007 folders to a Windows SharePoint Services site, which makes it possible to retrieve deleted data, audit the revision history, periodically back up data, and set permissions for data access.
PACKAGE INCLUDES
- 1 DVD offering instructor demonstrations, video lectures, and audio
- Interactive labs with Step-by-Step Demonstrations
-
Exclusive LearningZone Live Mentor - ($695 Value)
Receive assistance whenever it's required! Exclusive LearningZone - Communicate online with certified trainers 24/7 - We emphasize practical solutions to everyday development issues
- 1 Year Upgrade for Free
YOUR INSTRUCTOR
Sandra Batakis - A+ Trainer, MCT, MCSE, CIW Sandra has more than 15 years experience developing IT training programs. She is also a Senior Microsoft Certified Instructor. Sandra has consulted with Fortune 500 companies about IT training. She also has years of real-world experience installing networking infrastructure, configuring Internet security gateways, WAN, and LAN, and transitioning to Microsoft Exchange 5, 2000, 2003, 2007, and 2010. Sandra has taught numerous classes about Adobe, CompTIA, and Microsoft products, and she has made presentations at online Boot Camps.
FEATURES
-
Main Menu
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease. -
PowerPoint
PowerPoint presentations improve instruction by displaying all types of information for users. They can better comprehend material by viewing graphs, definitions, charts, etc. -
Exclusive Learning Zone
Train anywhere in the world at any time. Certified online instructors are situated at international support centers in the United States, United Kingdom, Australia, and Singapore to offer support and answer technology-related questions 24 hours a day. In other words, no matter where you live, you can communicate with specialists at any time. This level of interaction between instructors and students makes it possible for students to get answers to specific questions at their convenience. -
Controls
Move ahead, review, or repeat previous topics and sections. A progress bar monitors progress as you complete exercises. -
Full Motion Video
Every course offers full-motion videos of classroom instruction. It's as if you're sitting in a classroom. Our one of a kind delivery mimics a one-on-one classroom setting for more personalized educational experiences. -
Study Guides
Users can print entire course study guides, permitting them to view and review course material at their convenience. -
Review Exercises
Every section contains a review quiz to assist and enhance learning by testing whether students comprehend course concepts before moving forward. -
Resume
Every course resumes where you finished during the previous session in case you forget where you stopped. -
Labs
This course offers interactive labs, making it possible for students to obtain hands-on learning. This setting enables you to use the software without buying it or installing it on a computer. -
Certificate of Completion
We are internationally recognized for our technology-centered IT training programs. Once you finish a program, you'll receive a Certificate of Completion.
COURSE OUTLINE
Lesson 1 - 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
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
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
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