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 2013 - Level 1 / Intro

New – Learn how to use Microsoft Office Access 2013.

GK# 6652

Course Overview

TOP

A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool, which means you can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization.

In this course, you will learn how to use Access 2013 to manage your data by creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Schedule

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

$

What You'll Learn

TOP

In this course, you will be given the tools to become an Access 2013 power user. Learn in-depth methods to manage data and data entry, create forms and dialog boxes, split databases, create and use pivot tables and charts, and utilize Add-Ons and SQL.

Outline

TOP
Viewing outline for:

Classroom Live Outline

Getting Started

  • Starting Out
  • Using the Getting Started Window
  • Getting Help

Opening a Database

  • Navigating to the Database
  • Pinning a Database for Quick Access
  • The Trust Center

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

  • Planning a Database
  • Creating a Database
  • Using Database Options

Working with Records

  • What is a Record
  • Working with Record
  • Modifying Table Data
  • Emailing Records
  • Printing Records

Formatting Text

  • Using Zoom
  • Select Data
  • Cut, Copy, Paste
  • Format Painter

Sort and Filter

  • Find and Replace
  • Sort Ascending and Descending
  • Selection Sort
  • Advanced Sort

Tables

  • Creating a Table
  • Table Properties
  • Formatting Fields
  • Input Mask
  • Entering Data into a Table
  • Formatting a Table

Table Relationship

  • Create Table Relationship
  • Understanding the Relationship
  • Enforcing Referential Integrity
  • Cascade Update Related Fields
  • Cascade Delete Related Records

Forms

  • Creating Bound Forms
  • Creating Unbound Forms
  • Using the Wizard to Create Forms
  • Creating Navigation Forms
  • Using the Form Design Mode
  • Formatting a Form Using the Design Mode

Queries

  • What is a Query
  • Create a Simple Query
  • Create a Multi-Table Query
  • Create Action Queries

Reports

  • What is a Report
  • Create a Report Using a Wizard
  • Using a Report

Printing

  • The Print Menu
  • Print Preview
  • Print vs. Export

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