Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably (online classes start at a fraction of the cost of traditional classroom training).
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
Our Access 2010 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Access 2010 Exam 77-885, you achieve Microsoft Office User (MOS) status in Access 2010.
Microsoft Office Specialist MOS 2010 Requirements:
To earn the MOS credential, students must pass one (or more) of the individual Microsoft Office product exams listed below:
Exam 77-881 Using Microsoft Office Word 2010
Exam 77-885: Using Microsoft Office Access 2010
Exam 77-882: Using Microsoft Office Excel 2010
Exam 77-883: Using Microsoft Office PowerPoint 2010
Exam 77-884: Using Microsoft Office Outlook 2010
Exam 77-886: Using Microsoft SharePoint 2010
AUDIENCE PROFILE:
- All users of Access 2010
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Course Introduction
Instructor Introduction
Access Overview
Course Outline
Section 1: Access Basics
Section Overview
What Does Access Do?
Access Application Window
Database Objects
Basic Database and Table Management
Customizing Access
Keyboard Shortcuts
Section Review
Section 2: Designing a Database
Section Overview
Database Design Process
Normalizing Data
Setting Primary and Foreign Keys
Section Review
Section 3: Building a Database
Section Overview
Creating A New Database
Creating Tables
Inserting Field’s in Tables
Setting Up Field Properties
Formatting the Datasheet View
Creating Relationships
Keyboard Shortcuts
Section Review
Section 4: Managing Table Data
Section Overview
Updating and Deleting Records
Finding and Replacing Values
Adding a Total Row
Using Sub-datasheets
Sorting Data
Filtering Data
Keyboard Shortcuts
Section Review
Section 5: Creating Selection Queries
Section Overview
Creating Queries Using the Query Wizard
Creating Queries Using the Query Design View
Adding Criteria
Add Calculated Fields to Query
Section Review
Section 6: Creating and Managing Forms
Section Overview
Form Basics and Creating Forms
Contextual Tabs Design and Layout View
Managing Table Data with Forms
Modifying the Look and Design
Design Tab Controls
Section Review
Section 7: Creating and Managing Reports
Section Overview
Creating Reports, Report Views, and Managing Report Sections
Adding Calculated Fields and Formatting The Report Controls
Section Review
Section 8: Controlling Data Entry
Section Overview
Setting Field Properties
Validation Rules
Input Mask
Create Lookup Field
Review
Section 9: Finding and Joining Data
Section Overview
Inner and Outer Joins
Joining Unrelated Tables and Relating Data Within Tables
Section Review
Section 10: Creating Flexible Queries
Section Overview
Select Query Properties
Parameter Queries
Using Wild Cards
Creating Action Queries
Section Review
Section 11: Enhancing Forms
Section Overview
Using the Form Layout View and Improving Form Appearance
Restricting Data Entry
Command Buttons and Creating Subforms
Section Review
Section 12: Customizing Reports
Section Overview
Organizing Report Information and Setting Report Control Properties
Page Layout and Controlling Pagination
Summarize Info and Sub-reports
Mailing Labels
Section Review
Section 13: Sharing Access Data
Section Overview
Importing and Exporting Data
Sharing Data and Merging Data with Word
Section Review
Section 14: Structuring Existing Data
Section Overview
Analyzing Tables and Junction Tables
Improving Table Structure
Section Review
Section 15: Writing Table Queries
Section Overview
Multi Table Query
Creating Unmatched Queries
Create Duplicate Queries
Create Duplicate Queries and Grouping and Summarizing
Crosstab Query
Creating Pivot tables and Pivot Charts
Section Review
Section 16: Using Macros
Section Overview
Planning and Creating Macros
Attach Macros to Command Buttons
Restrict Records Displayed Using Where Condition
Require Data Entry with Macros
Automate Data Entry
Section Review
Section 17: Making Forms More Effective
Section Overview
Form Format Properties
Active X Controls and Tabbed Pages
Display Pivot Chart Table on Forms
Section Review
Section 18: Improving Reports
Section Overview
Include Chart In Report and Concatenating
Arranging Data In Columns, Grouping, and Parameter Reports
Report Events and Canceling a Blank Report from Printing
Section Review
Section 19: Creating a Startup Interface
Section Overview
Creating and Modifying a DB Switchboard
Setting and Modifying Startup Options
Section Review
Section 20: DataBase Maintenance
Section Overview
Database Maintenance Tools
Section Review
Section 21: Distributing and Securing a Database
Section Overview
Splitting a Database
Implementing Security and Trust center
Setting Passwords
Converting Files and Signing with Digital Signatures
Section Review
Course Review
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116