X

Access 2016 Building Dynamic Tables

Course Overview

This course is designed to provide a detailed overview of tables in Access. Students will learn how to build tables using different types of data, how to import data from external sources, how to create relationships between tables in an Access database, and how to add, edit, sort, filter, and search for records in a table. This course is ideal for anyone who has a general understanding of an Access database and would like to build or maintain a database in Access.

Who Should Attend

This course is designed to provide a more comprehensive look at working with tables in an Access database. A basic understanding of database concepts and/or beginner level experience using an Access database is recommended.

Course Objectives

The goal of this course is to provide students with the knowledge and skills they need to create and work with tables and table data in Access. Students will learn to create the structure of an Access table using various data types and fields, connect tables in a database to work together, and work with records in tables.

Course Outline

1 - Lessons

  • Creating Tables - Learn the components of a table and how to create a table using both datasheet view and design view.
  • Working with Data Types - Learn about the types of data used in an Access database, how to create a list of values with a Lookup Wizard, and how to add a calculated field.
  • Working with External Data - Learn how to import data from an external data source into a table in Access.
  • Creating Table Relationships - Learn how to relate tables using primary and foreign keys.
  • Working with Tables - Learn how to work with table data including adding and editing records, sorting and filtering, and searching for records.

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/10/2020 4:00PM - 5:00PM Online LIVE LNL
12/14/2020 11:00AM - 12:00PM Online LIVE LNL

Class times are listed Eastern time

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