ACC16INT: Microsoft Access 2016 - Level 1 / Intro

Start Date Time Days Price GTR Availability
August 28, 2017 09:00 (EST) 2 $710.00 Register
August 28, 2017 09:00 (EST) 2 $710.00 Register
October 10, 2017 09:00 (EST) 2 $710.00 Register
October 10, 2017 09:00 (EST) 2 $710.00 Register

Duration: 2 Days

Course Description

Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. You can use it as a personal data management tool, or you can use it to develop applications for a department or an entire organization. In this course, you will use Access 2016 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

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

Course Objectives

In this course, you will learn how to use Access 2016 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 with Access

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access

Working with Table Data

  • Modify Table Data
  • Sort and Filter Records

Querying a Database

  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Using Forms

  • Create Basic Access Forms
  • Work with Data on Access Forms

Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports