Tables, Fields, & Entries in Access 2016 for Windows

IN THIS COURSE

• 1.  Understanding your database in Access 2016 for Windows
  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
• 2.  Creating a table in Access 2016 for Windows
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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