Access 2016 Level 1
CLASS DATE(s):
5/18/2020
7/20/2020

COURSE LENGTH: 1 Day

COURSE COST: $495.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. 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 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.

You will:

Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
Organize and manage data stored within Access tables.
Use queries to join, sort, and filter data from different tables.
Use forms to make it easier to view, access, and input data.
Create and format custom reports.

AUDIENCE AND PREREQUISITES

This course is designed 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.

To ensure your success in this course, you should have end-user skills with any current version of Windows, including:

  • Being able to open and close applications.
  • Navigate basic file structures.
  • Manage files and folders.

FOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware $ 24.65. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions. Course is subject to a minimum enrollment. Course may run as a virtual instructor led course if minimum enrollment is not met.



You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

COURSE TOPICS:


Lesson 1: Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data
Modify Table Data
Sort and Filter Records

Lesson 3: Querying a Database
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query

Lesson 4: Using Forms
Create Basic Access Forms
Work with Data on Access Forms

Lesson 5: 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