X

Access 2016 Beyond the Basics

Course Overview

This course is designed to provide students with information about maintaining a database, improving functionality of a database for the end user, and working with external data.

Who Should Attend

This course is designed for Access users who have a more advanced understanding of basic database concepts and who want to improve the effectiveness of the database structure, connect to external data, and work with maintenance tools inside Access.

Course Objectives

The goal of this course is to provide students with the knowledge and skills they need to work with maintenance tools and navigation and startup options for multiple users. In addition, students will learn about the process of normalization and how they can use the table analyzer to possibly improve the performance of their database. Students will learn how to import data into their databases and how to export data from the database to an external source.

Course Outline

1 - Lessons

  • Normalizing Data in Access - Learn about the normal forms in an Access database.
  • Creating Database Navigation - Learn how to build a Navigation form and how to use Startup Options to limit access for the end user.
  • Maintaining a Database - Learn about maintenance tasks such as backing up, documenting, and compacting a database.
  • Working with External Data - Learn how to import data and how to link to data from an external source.
  • Exporting Data - Learn how to export data to an external source such as a PDF or Excel file and how to save the export steps.

Price: $49.95

Class times are listed Eastern time.

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time Where How
11/06/2020 11:00AM - 12:00PM Online LIVE LNL
12/07/2020 4:00PM - 5:00PM Online LIVE LNL

Class times are listed Eastern time

This class is part of our LearnNow Pass. Click here for more details.