Tables, Fields, & Entries in Access 2016 for Windows

Access 2016 (Windows)    |    Intermediate
  • 9 videos | 39m 25s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
To get the most out of Access 2016, you need to understand the structure and main elements of a database. Explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties.

WHAT YOU WILL LEARN

  • Understanding your database
    Creating a table
    Organizing your database items
    Inserting fields in your table
    Formatting your database fields
  • Editing your database field properties
    Linking data in different tables
    Managing data relationships
    Visualizing object dependencies

IN THIS COURSE

  • 5m 37s
    Before creating your database in Access 2016, 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
  • 2m 48s
    In Access 2016, 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 2016 for Windows
    4m
    Your database file is made up of a variety of different objects, including data tables, queries, reports and forms. In Access 2016, 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 2016 for Windows
    3m 46s
    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. You can, for example, use Access 2016 to create a table containing fields for inserting a customer's first name, last name, date of birth, and address. To do this, you will need to know how to create and format a field. FREE ACCESS
  • Locked
    5.  Formatting your database fields in Access 2016 for Windows
    3m 2s
    Each field in an Access 2016 data table has a particular format. This format is used to identify what sort of data value it should contain. You can, for example, created 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 2016 for Windows
    3m 33s
    In Access 2016, 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 2016 for Windows
    6m 43s
    In Access 2016, 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 and begin analyzing your data. You might, for example, find that a customer's reference number appears both in the customer data table and the table containing information on individual purchase orders that have been placed. FREE ACCESS
  • Locked
    8.  Managing data relationships in Access 2016 for Windows
    5m 40s
    There are a number of different relationships that can exist between different fields in Access 2016. These relationships depend on the nature of the data values in question and how these values are expected to interact together. You can, for example, create a one-to-many relationship, which is an unbalanced link in which one record can have multiple correspondences (such as a single customer who has placed multiple orders). Conversely, you can also have many-to-many relationships, such as when an item can feature in multiple orders and an order can contain multiple items. In this later case, you will need to create a junction table to manage the relationship. FREE ACCESS
  • Locked
    9.  Visualizing object dependencies in Access 2016 for Windows
    4m 18s
    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 2016 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.9 of 14 users Rating 4.9 of 14 users (14)
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 77 users Rating 4.4 of 77 users (77)
Rating 4.4 of 1162 users Rating 4.4 of 1162 users (1162)
Rating 4.1 of 218 users Rating 4.1 of 218 users (218)