MOS: Access 2010 Level 1 for Windows

Description

In this course you will cover: basic database concepts and an exploration of the Access 2010 Level 1 for Windows environment, designing a database, building a database with related tables, managing data in a table, querying a database using different methods, designing forms and generating reports.

Prerequisites

Windows Level 1 or Equivalent Knowledge

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

Getting Started

Database Concepts
Exploring the Access Environment
Getting Help

Databases and Tables

Planning and Designing Databases
Exploring Tables
Creating Tables

Fields and Records

Changing the Design of a Table
Finding and Editing Records
Organizing Records

Data Entry Rules

Setting Field Properties
Working with Input Masks
Setting Validation Rules

Basic Queries

Creating and using Queries
Modifying Query Results and Queries
Performing Operations in Queries Using Forms
Creating Forms
Using Design View
Sorting and Filtering Records

Working with Reports

Creating Reports
Modifying and Printing Reports

Enrolled