ACC13INT: Microsoft Access 2013 - Level 1 / Intro

$710.00
$710.00
$710.00
$710.00
$710.00
$710.00
$710.00
$710.00
Start Date Time Days Price GTR Availability
May 01, 2017 09:00 (EST) 2 $710.00 Register
May 01, 2017 09:00 (EST) 2 $710.00 Register
June 12, 2017 09:00 (EST) 2 $710.00 Register
June 12, 2017 09:00 (EST) 2 $710.00 Register
July 24, 2017 09:00 (EST) 2 $710.00 Register
July 24, 2017 09:00 (EST) 2 $710.00 Register
September 11, 2017 09:00 (EST) 2 $710.00 Register
October 23, 2017 09:00 (EST) 2 $710.00 Register

Duration: 2 days

Course Description
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. 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, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

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

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

Audience
For individuals and organizations needing to collect and manage large amounts of data.

Course Content

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, past
  • Format Painter

Sort & Filter

  • Find & 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