Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options
Checkout

Cart () Loading...

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

    $

Microsoft Access 2013 - Level 1 / Intro

Learn how to use Access 2013 to manage your data by creating a new database, constructing tables, designing forms and reports.

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 Microsoft Windows and Office.

Who Should Attend

TOP

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

Follow-On Courses

TOP
Training Exclusives

This Office course comes with extended access to the following benefits:

  • Concept Training
  • ClipTraining Video Library
  • Free Refreshers
  • Online Course Content
Learn More >
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

Request this course in a different delivery format.
Enroll