Tables, Fields & Entries in Access 2019 for Windows
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 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 3sBefore 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 14sIn 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 Windows5m 3sYour 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 Windows3m 17sA 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 Windows3m 4sEach 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 Windows3m 39sIn 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 Windows4m 17sIn 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 Windows3m 51sThere 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 Windows3m 2sIf 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.
