Tables, Fields & Entries
Access 2019 (Windows)
| Intermediate
- 9 Videos | 33m 30s
- Includes Assessment
- Earns a Badge
- CPE
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 databasecreate a tableorganize database itemsinsert fields into a tableformat database fields
-
edit database field propertieslink data in different tablesmanage data relationshipsvisualize object dependencies
IN THIS COURSE
-
1.Understanding your database4m 3sUP NEXT
-
2.Creating a table3m 14s
-
3.Organizing your database items5m 3s
-
4.Inserting fields in your table3m 17s
-
5.Formatting your database fields3m 4s
-
6.Editing your database field properties3m 39s
-
7.Linking data in different tables4m 17s
-
8.Managing data relationships3m 51s
-
9.Visualizing object dependencies3m 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.