$710.00 CAD / 2 DAYS

1) Select Location for Dates in Your City:


Choose Date

Date is Guaranteed to Run

Notify me Click on date to Register Now or click Notify Me to receive an email notification when course is Guaranteed to Run. once the following courses become Guaranteed to run.

No available dates.
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,

Jump to Shopping Cart Continue shopping

ACC13INT: Microsoft Access 2013 – Level 1 / Intro

 

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