Microsoft Access 2013 - Level 1 / Intro Course Details:

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.

    No classes are currenty scheduled for this course.

    Call (919) 283-1674 to get a class scheduled online or in your area!

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

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

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.

Students should be familiar with Microsoft Windows and Office.

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

Ready to Jumpstart Your IT Career?

CONTACT US NOW!