Tables, Fields & Entries

Access 2019 (Windows)    |    Intermediate
  • 9 Videos | 33m 30s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 50 Likes 50
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.

WHAT YOU WILL LEARN

  • understand the key features of a database
    create a table
    organize database items
    insert fields into a table
    format database fields
  • edit database field properties
    link data in different tables
    manage data relationships
    visualize object dependencies

IN THIS COURSE

  • Playable
    1. 
    Understanding your database
    4m 3s
    UP NEXT
  • Playable
    2. 
    Creating a table
    3m 14s
  • Locked
    3. 
    Organizing your database items
    5m 3s
  • Locked
    4. 
    Inserting fields in your table
    3m 17s
  • Locked
    5. 
    Formatting your database fields
    3m 4s
  • Locked
    6. 
    Editing your database field properties
    3m 39s
  • Locked
    7. 
    Linking data in different tables
    4m 17s
  • Locked
    8. 
    Managing data relationships
    3m 51s
  • Locked
    9. 
    Visualizing object dependencies
    3m 2s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 266 Likes 266  
Likes 97 Likes 97  
Likes 12 Likes 12  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 16 Likes 16  
Likes 84 Likes 84  
Likes 97 Likes 97