India

Microsoft Access 2010 Certification Training

Participate in the Microsoft Access 2010 online course to improve your level of knowledge with Microsoft Access functions, while you prepare to take the Microsoft Certification Exam
Temecula, CA P.O. Box 760,, Temecula, CA 92593
(951) 9723600

Course at a Glance

Mode of learning : Online - Instructor Lead(LVC)

Domain / Subject : Engineering & Technology

Function : Information Technology(IT)

Duration : 120 Hours

Difficulty : Medium

Microsoft Access 2010 Certification Training

Participate in the Microsoft Access 2010 online course to improve your level of knowledge with Microsoft Access functions, while you prepare to take the Microsoft Certification Exam. The book, The Complete Guide to Microsoft Access 2010 ebook includes both recall and authentic assessments to measure your understanding at an increasingly advanced level. You will work hands-on with the commands, as you complete sample projects to reinforce your learning. This course does not rely on abstract learning but on the program in context.

Objectives

By completing the Microsoft Outlook Online Training Program, you will be able to do the following:

  • Create and Manage databases
  • Create Tables, add Fields and specify the Data Type
  • Create Forms with a Wizard, Quick Parts and in Design View
  • Create Forms for data entry as well as list view
  • Use Queries to combine Fields, Group, Sort and Total
  • Create Reports and format the content, Header, Footer and layout
  • Manage and maintain an Access database
  • Create a strategy for archiving data with Action Queries

This program teaches the exam objectives for the following optional certification test, which is not required for MOS Certification:

  • Exam 77-885: MOS: Microsoft Office Access 2010. 

Requirements

This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with the Windows XP and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and e-mail account. You should also have the following full-retail version Microsoft Office 2010 Products already installed: Access, Word, and Excel.

It is recommended that you use the latest version of Internet Explorer in place of other Web browsers.Adobe Flash Player and Adobe Acrobat Reader are required for this program.

The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft Access 2010
  • Intermediate Guide to Microsoft Access 2010
  • Advanced Guide to Microsoft Access 2010

Prerequisites

Before you enroll in the Microsoft Access 2010 Certification Training program, you should have strong computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up your files. You should also be proficient in Microsoft Excel.

This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program will also suit you if you want to learn about this software and expand your job possibilities.

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace.

Course Content

  • Beginning Microsoft Access
    • Getting Started: How to use the online course
    • Hello, Access: Introduction to Tables
    • Tables and Table Design: Adding Fields
    • Table and More Tables: Design View
    • Forms and Form Design: Layout View
    • Designing for Real Users: Edit the Form Properties
    • Queries and Query Design: Ask questions
    • More Queries: Use Criteria and Parameters
    • Reports and Report Design: Layout View
    • Reports and More Reports: Use Design View
    • Managing Databases: Save and Save As
  • Intermediate Microsoft Access
    • Hello, Again, Hello: Introduction to one-to-many relationships
    • One-From-Many Relationships: Create a Combo Box
    • Forms and Subforms, Part 1: Representing one-to-many
    • Forms and Subforms, Part 2: Creating the Search Form
    • Forms and Subforms, Part 3: Link the Form and Subform
    • Meet the Stars: Create a Switchboard Form
    • The Opening Scene: Manage the database environment
    • Dress Rehearsal: How to TEST your software
    • Report Totals: Use a Query to calculate the Tota
    • Report Design Options: Use Design View
  • Advanced Microsoft Access
    • You say Goodbye, and I say Hello!: Normalize a database
    • Relating Tables in a Database: Key data
    • Primary Keys and Relationships
    • The Receipt Form, Part 1: Design the Subform
    • The Receipt Form, Part 2: Design the Form and link the two Forms
    • The Receipt Printout, Part 1: Design the Report
    • The Receipt Print, Part 2: Design the Subreport and link the two Reports
    • The Producers: Working with Dates
    • Prepare to Share: Visualize the results and export the Reports
    • Strategies for Archiving: Use Action Queries
    • The Performance Network: Optimize for Multi-Users

Photos

Write Your Own Review


Write your review here (required)


Consider:
Is the price of course overrated?
would you recommend this course to others?
Is duration of the course sufficient enough?
Did you like the faculties?
What would you prefer in future classroom or online learning?


Disclaimer: The contents of the course & Institute are obtained from the institute’s website by automated scraping or manual updates. For the latest information, please refer the institute website directly. For any discrepancies in the content, contact us at