Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Access 2010 - Level 1 / Intro

New – Learn how to use Access 2007/2010.

GK# 6696

Course Overview

TOP

Students will learn how to use the Access 2007/2010 interface to create a simple database, tables, forms, queries and reports.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

In this course, you will learn how to use Access 2010 to manage your data, including creating a new database, how to construct tables and design forms and reports, and how to create queries to join, filter, and sort data.

Outline

TOP
Viewing outline for:

Classroom Live Outline

The New Interface

  • Using the Quick Access Toolbar
  • Basics of Tabs
  • The Home Tab
  • The Create Tab
  • The External Data Tab
  • The Database Tools Tab

Creating a Database

  • Creating a Database
  • Understanding the Different Objects
  • Using the Getting Started Window
  • The Trust Center
  • Getting Help

Tables

  • Creating a Table
  • Creating Fields
  • Naming Fields
  • Type of Data
  • Field Description
  • Primary Key
  • Saving a Table
  • View Table Relationships

Queries

  • The Queries Window
  • Basic Queries
  • Multi-Table Queries

Forms

  • Creating a Default Form
  • Creating a Form in Design View
  • Adding Controls
  • Formatting a Form
  • Form Design Tool
  • Form Properties
  • Adding Felds to a Form

Reports

  • Creating a Report
  • Using the Report Wizard
  • Creating a Report in Design View
  • Formatting a Report

Additional Tools

  • Sorting and Filtering Data
  • Viewing Data
  • Printing a Database Object

Prerequisites

TOP

Students should be familiar with Windows 7 or 8 and Microsoft Office.

Who Should Attend

TOP

Individuals and organizations that need to collect and manage large amounts of data.

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Request this course in a different delivery format.
Enroll