Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Access 2016 Level 1 Data Entry and Reports

Become familiar with introductory features and functionality relating to database design using Microsoft Access 2016.

GK# 5040

Course Overview

TOP

In this course, you will become familiar with introductory features and functionality relating to database design using Microsoft Access 2016.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 24x7 access for 60 days to online mentoring via chat from Microsoft Office experts.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Identify the components of a database, and work with those components
  • Open a table, find information stored there, and enter data
  • Create several query types, edit and run queries, and use action and calculation queries
  • Create several report types, enhance reports and print preview reports
  • Preview and print database objects, and change the page setup options

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. The Basics

  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access 2016 Files
  • Working with Objects
  • Using Access Help

2. Table Data

  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters

3. Queries

  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries

4. Reports

  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes

5. Printing

  • Printing Objects
  • Print Preview

Prerequisites

TOP

Experience working within a Microsoft Windows environment

Who Should Attend

TOP

Individuals new to Microsoft Access 2016

Vendor Credits

TOP

This course can be purchased using Cisco Learning Credits (CLCs).

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.
Enroll