Data and Tables in Access

Get started with Access 2016 by learning the fundamentals of database features. This class will explore how to use Access efficiently and introduce you to the concepts of good Relational Database design. It’s a maxim that all data is stored in Tables in Access, but not all Tables are equal. You will learn the elements of the user interface and dig into the Table Object. You will use the Datasheet and the Design views and gain a strong understanding of how data is linked together.

  • Building a Database
  • Naming Conventions
  • Creating Tables
  • Importing Data
  • Understanding Relationships
  • Special Field Types
  • Data Integrity
  • Sorting & Filtering Data