Microsoft Access 2010: Basic

Pre-Requisites: Basic Windows XP/Vista/Windows 7 skills.

5-stars

Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

What you will learn

This course provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and their various objects. Students will learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2010 with other applications.

Benefits

This course is intended for students who wish to learn the basic operations of the Microsoft Access® 2010 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

Course content

Unit 1: Getting started

  • Topic A: Database concepts
  • Topic B: Exploring the Access environment
  • Topic C: Getting help

Unit 2: Databases and tables

  • Topic A: Planning and designing databases
  • Topic B: Exploring tables
  • Topic C: Creating tables

Unit 3: Fields and records

  • Topic A: Changing the design of a table
  • Topic B: Finding and editing records
  • Topic C: Organizing records

Unit 4: Data entry rules

  • Topic A: Setting field properties
  • Topic B: Working with input masks
  • Topic C: Setting validation rules

Unit 5: Basic queries

  • Topic A: Creating and using queries
  • Topic B: Modifying query results and queries
  • Topic C: Performing operations in queries

Unit 6: Using forms

  • Topic A: Creating forms
  • Topic B: Using Design view
  • Topic C: Sorting and filtering records

Unit 7: Working with reports

  • Topic A: Reports
  • Topic B: Modifying and printing reports

Course Number : MOUS-7-0400

Duration : 8 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder