Access 2019: Tables, Fields & Entries


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

To get the most out of Access 2019, one needs to understand the structure and main elements of a database. In this 9-video course, "Access 2019: Tables, Fields, and Entries," learners can explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties. Begin by learning the structure and key features of your database such as a table, field, value, query, and form. Then learn how to create a table automatically or manually in a database, and organize, filter, and hide database items. Examine how to insert fields into tables, format database fields, and edit database field properties, as each field in an Access data table has a particular format. In Access, you will often find that data values inserted into different tables are related, so discover how to link data in different tables to help visualize the relationship between records spread across multiple tables. Then move on to observing how to manage data relationships, and finally, to learning how to visualize object dependencies.



Expected Duration (hours)
0.6

Lesson Objectives

Access 2019: Tables, Fields & Entries

  • understand the key features of your data base such as table, field, value, query and form
  • create a table automatically or manually in a database
  • organize, filter and hide database items
  • insert fields into table
  • format database fields
  • edit database field properties
  • link data in different tables
  • manage data relationships
  • visualize object dependencies
  • Course Number:
    ds_msac2019_03_enus

    Expertise Level
    Intermediate