Tables, Fields & Entries

Access 2019 (Windows)    |    Intermediate
  • 9 Videos | 33m 30s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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
    FREE ACCESS
  • Locked
    4. 
    Inserting fields in your table
    3m 17s
    FREE ACCESS
  • Locked
    5. 
    Formatting your database fields
    3m 4s
    FREE ACCESS
  • Locked
    6. 
    Editing your database field properties
    3m 39s
    FREE ACCESS
  • Locked
    7. 
    Linking data in different tables
    4m 17s
    FREE ACCESS
  • Locked
    8. 
    Managing data relationships
    3m 51s
    FREE ACCESS
  • Locked
    9. 
    Visualizing object dependencies
    3m 2s
    FREE ACCESS

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

BOOK Access 2019 Bible
BOOK Access For Dummies
BOOK Introducing Microsoft Access Using Macro Programming Techniques: An Introduction to Desktop Database Development by Example

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Databases
Likes 97 Likes 97  
COURSE Customizing Forms
Likes 16 Likes 16  
COURSE Expert Insights on Adapting to Change
Likes 1331 Likes 1331