Access - Building Dynamic Tables

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

 

Upcoming Class Dates and Times

Sep 20, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 17, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • 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.