India

Microsoft Access 2007

This Program is a comprehensive, performance-based certification preparation program that will validate your business computer skills using Microsoft Access 2007 software.
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)

Trainer name : Elizabeth Ann Nofs, Clair Dickinson

Duration : 120 Hours

Difficulty : Medium

Microsoft Access 2007

The Microsoft Access 2007 Online Training Program is a comprehensive, performance-based certification preparation program that will validate your business computer skills using Microsoft Access 2007 software. You'll not only gain basic knowledge of the software, including how to use and design tables, forms, and queries, but you'll also learn how to link information, automate data entry, and more! This online certificate program is offered in partnership with major colleges, universities, and other accredited education providers.

Objectives

By completing the Microsoft Access 2007 program, you'll:

  • Know how to use and design tables, forms, and queries
  • Create queries to find and select records by criteria, and write, test, and update those queries
  • Understand how to create forms with subforms to represent one-to-many relationships
  • Learn to use criteria, parameters, concatenation, and operators in query designs
  • Improve report designs with sorting and grouping
  • Know how to link information and automate data entry
  • Create a search form that uses a combo box to filter the records
  • Know how to use Microsoft Access and Word together in a mail merge
  • Be able to optimize a database for multiple users

If you wish to prepare for the Microsoft Certification Exam 77-605: Using Microsoft Office Access 2007, you'll find beginning lessons that demonstrate these required MOS topics here.

Requirements

This program is compatible with the Windows 7 and Windows 8 and later operating systems and IE 7 and later browsers.  You'll need the following Microsoft products already installed on your computer in order to take this program: Microsoft Word and Access 2007.

Hardware requirements:

  • IBM-compatible (PC) computer
  • Processor: 1 GHz 32-bit (x86) or 64-bit (x64)
  • RAM: 1 GB of system memory
  • Hard Drive: 40 GB with at least 15 GB of available space
  • Video: support for DirectX 9 graphics with WDDM Driver
  • 128 MB of graphics memory
  • Pixel Shader 2.0 in hardware
  • 32 bits per pixel
  • DVD-ROM drive
  • Audio output
  • Adobe Flash Player and Adobe Acrobat Reader are required for this course.
  • Internet Connectivity 
  • This program cannot be taken from a Mac computer.

Books included with this program:

  • The Beginning Guide to Microsoft Access 2007
  • The Intermediate Guide to Microsoft Access 2007
  • The Advanced Guide to Microsoft Access 2007
  • This program includes: Microsoft Office Access 2007 CourseNotes from Course Technology.

Prerequisites

Students who enroll in the Microsoft Access 2007 program should have the equivalent of six months of hands-on computer experience. You should be able to manage files, including saving, updating, and backing up files. 

This program is for you if you're an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Access skills immediately. This program is also suitable for you if you're looking 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 Syllabus

Beginning Guide to Microsoft Access 2007

  • Microsoft Access Database Tables
  • Microsoft Access Database Forms
  • Microsoft Access Database Queries
  • Database Maintenance
  • Microsoft Access Database Reports

Intermediate Guide to Microsoft Access 2007

  • Better Form Design
  • Form Controls and Switchboards
  • Modifying Form Properties
  • Software Testing
  • Sophisticated Queries

Advanced Guide to Microsoft Access 2007

  • Create a Search Form
  • Synchronized Forms and Controls
  • Office Automation
  • Linked Tables
  • Links to the Internet

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