Call

Microsoft® Access® 2016: Level 1

< Back to Course Catalog

Duration:

1 Day (6.5 instructional hours)

Access 2016

Course Number: 091045S

Course Objective:

Upon successful completion of 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.

Target Student:

This course is intended for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Course Objective:

To ensure success, students will need to be familiar with using or have equivalent knowledge of: Using Microsoft Windows 10, and Microsoft Windows 10: Transition from Windows 7.

Course Outline

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Lesson 3: Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organize Report Information

Topic F: Format Reports

< Back to Course Catalog