Cart Subtotal: $0.00

Welcome Student!

  • Contact Us
  • (888) 840-2378
  • Tech Support: (866) 830-9276
  • Click here to chat!

Microsoft Office 2010 Access

Click on image to zoom

Be the first to review this product

SKU# 183300

Availability: In stock

$299.00

$99.00

Secure shopping trustmarks

Quick Overview

Microsoft Office 2010 Access

QuickCert Exam Pass Guarantee

QuickCert’s online IT training programs are guaranteed to get you certified – or we will pay for your make-up exam. Our quality online IT courseware, packed with instruction, exercises, practice exams and test simulators will ensure you pass the exam. Learn more.

Course Description

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 Certified Application Specialist (MOS) status in Access 2010.

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2010.

As a Microsoft Certified Partner, we follow the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  We are so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Syllabus

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

Instructor Bio

Ray Wagner, CISA, MOS, PMP

Ray began his IT education at James Madison University, where he excelled in the business school's Computer Information Systems program. Upon graduation, he began his career as a financial systems auditor where he was required to utilize and optimize the Microsoft Office applications. Once he mastered the applications, Ray began teaching co-workers how to effectively use their applications to increase their productivity. Life as an auditor also exposed Ray to project management fundamentals, and Ray was soon managing small auditing projects as a Senior Consultant. After a few years, Ray shifted gears and became a consultant for a project management contractor on a multi-million dollar government program where he was responsible for tracking program costs and schedules. Ray has since started a training company that allows him to manage a business as well as deliver application and project management training to a variety of clients.

Reviews
Write Your Own Review

You're reviewing: Microsoft Office 2010 Access

  •  
    1 star
    2 stars
    3 stars
    4 stars
    5 stars
    Value
    Quality
    Price

* Required Fields

Free Demo