Training and Certifications > Course Outline

Access 2016 - Part 1

This course is an introduction to Microsoft Access 2016. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course.

Skip to Available Dates

Learning Objectives

In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

 

Course Details

Course Outline

1 - GETTING STARTED WITH ACCESS 2016
  • Topic A: Launch Access and Open a Database
  • Topic B: Use Tables to Store Data
  • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
  • Topic D: Use Forms to View, Add, and Update Data
  • Topic E: Use Reports to Present Data
  • Topic F: Get Help and Configure Options in Microsoft Access
    • 2 - CREATING TABLES
  • Topic A: Plan an Access Database
  • Topic B: Start a New Access Database
  • Topic C: Create a New Table
  • Topic D: Establish Table Relationships
    • 3 - CREATING QUERIES
  • Topic A: Create Basic Queries
  • Topic B: Perform Calculations in a Query
  • Topic C: Sort and Filter Data in a Query
    • 4 - CREATING FORMS
  • Topic A: Start a New Form
  • Topic B: Enhance a Form
    • 5 - CREATING REPORTS
  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout

    • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    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.

    Other Prerequisites

    The recommended pre-requisite for this course is basic computer skills. Knowledge of basic database concepts is helpful but not required.

    Access 2016 - Part 1

    Call
    Course Length : 2 Days

    There are currently no scheduled dates for this course. Please contact us for more information.

     PDF Outline With Dates     PDF Outline

    Need Help Picking the Right Course? Give us a call! +359 2 421 0040