Microsoft Access 2016 - Level 1 / Intro (AA-ACC16INT)


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

Course Outline

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

Course Objectives

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

Course 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 Information

Length: 2 day

Format: Lecture and Lab

Delivery Method: n/a

Max. Capacity: 16



Schedule

Contact Us

UPCOMING COURSES
Date
Geography & Location
Days
Cost
CLC
GTR
Oct 22, 2024 - 2 day(s)
Oct 22, 2024
AMER
Remote-EST
AMER, Remote-EST
2
$690 USD
$690 USD

Do you have more questions? We're delighted to assist you!

1-877-797-2799
info@firefly.cloud

Who Should Attend

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.