Tables, Fields & Entries in Access 2019 for Windows

IN THIS COURSE

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