Microsoft Access 2013 - Level 1 / Intro

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.

    Nov 10 2020

    November 10 - 11, 2020 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live

    Date: 11/10/2020 - 11/11/2020 (Tuesday - Wednesday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    Microsoft Access 2013 - Level 1 / Intro

    November 10 - 11, 2020 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Dec 3 2020

    December 3 - 4, 2020 | 11:30 AM - 7:30 PM (EST) | Virtual Classroom Live

    Date: 12/03/2020 - 12/04/2020 (Thursday - Friday) | 11:30 AM - 7:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    Microsoft Access 2013 - Level 1 / Intro

    December 3 - 4, 2020 | 11:30 AM - 7:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Dec 17 2020

    December 17 - 18, 2020 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live

    Date: 12/17/2020 - 12/18/2020 (Thursday - Friday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    Microsoft Access 2013 - Level 1 / Intro

    December 17 - 18, 2020 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

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

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 Advance Your Career?

CONTACT US NOW!