Tables, Fields & Entries in Access 2019 for Windows

Access 2019 (Windows)    |    Intermediate
  • 9 videos | 33m 30s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 77 users Rating 4.4 of 77 users (77)
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

  • 4m 3s
    Before creating your database in Access 2019, it is a good idea to have an understanding of how it is structured. This will help you to get the most out of the program and ensure that you use each tool correctly. This includes understanding how primary keys function and how relationships are created between data tables and queries. FREE ACCESS
  • 3m 14s
    In Access, tables are used to store values and records. Each record - a single row - is organized into columns, which are known as fields. Each field is used to store a particular type of information. Knowing how to create new fields and how to add a record to your table are vital to using your database correctly. FREE ACCESS
  • Locked
    3.  Organizing your database items in Access 2019 for Windows
    5m 3s
    Your database file is made up of a variety of different objects, including data tables, queries, reports and forms. In Access, these objects can be sorted and organized, allowing you to easily find, manage and edit them. You can even filter your list to hide anything that you do not require at the time. FREE ACCESS
  • Locked
    4.  Inserting fields in your table in Access 2019 for Windows
    3m 17s
    A data table is made of records, fields, and values. Fields are individual columns used to categorize a particular data type. This organization is vertical and applies to all the records in your data table. This video will show you how to create and edit a field. FREE ACCESS
  • Locked
    5.  Formatting your database fields in Access 2019 for Windows
    3m 4s
    Each field in an Access data table has a particular format. This format is used to identify what sort of data value it should contain. You can, for example, create text-based, numerical and monetary fields. You can even adjust the number of decimal places that should be visible and the currency symbol used. FREE ACCESS
  • Locked
    6.  Editing your database field properties in Access 2019 for Windows
    3m 39s
    In Access, you can adjust how a field functions and the sort of information it is designed to hold by editing its properties. You can, for example, change a field's format, create a default value that is automatically added when you create a new record, and even place limits on what can be inserted. FREE ACCESS
  • Locked
    7.  Linking data in different tables in Access 2019 for Windows
    4m 17s
    In Access, you will often find that data values you have inserted into different tables are related. Linking these related values enables you to visualize the relationship between records spread across multiple tables. FREE ACCESS
  • Locked
    8.  Managing data relationships in Access 2019 for Windows
    3m 51s
    There are a number of different relationships that can exist between different fields in Access. These relationships depend on the nature of the data values in question and how these values are expected to interact together. FREE ACCESS
  • Locked
    9.  Visualizing object dependencies in Access 2019 for Windows
    3m 2s
    If you want to modify a field or table, you should check to make sure that the change you have planned is not going to cause problems for anything else in your database. Access features a number of different tools that you can use to visualize the relationships and dependencies that have been created between tables and other objects in your database. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.7 of 149 users Rating 4.7 of 149 users (149)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.1 of 218 users Rating 4.1 of 218 users (218)
Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
Rating 4.5 of 77 users Rating 4.5 of 77 users (77)