Understanding Tables, Fields, & Entries in Access 2010 for Windows
Access 2010 (Windows)
| Intermediate
- 9 videos | 52m 28s
- Earns a Badge
Within a database, data is stored and organized in tables. Discover how to create and manage tables, insert and edit fields and field properties, link table data, and manage relationships in Access 2010.
WHAT YOU WILL LEARN
-
Understanding your database
Creating a table
Managing your tables
Inserting fields in your table
Editing fields in your table -
Editing your database field properties
Linking data in different tables
Managing data relationships
Visualizing object dependencies
IN THIS COURSE
-
6m 41sIf you are unsure of exactly what constitutes a database, then this video tutorial is for you. In it, you will learn about the key terms and structures in a database. FREE ACCESS
-
4m 58sIn a relational database, your data is stored in different tables. A single database can be made up of multiple tables. In this video tutorial, you will find out how to create a table in order to begin inserting data into your database. FREE ACCESS
-
3. Managing your tables in Access 2010 for Windows6m 40sIn Access 2010, it is very easy to modify and manipulate your tables. This video tutorial will show you how to open and close your tables, how to rename them, how to import tables from external sources, and even how to delete entirely a table from your database. FREE ACCESS
-
4. Inserting fields in your table in Access 2010 for Windows4m 49sFields are used to hold different data components in your table. A single table will often contain multiple fields. In this video tutorial, you will find out about the different ways of inserting your data fields. FREE ACCESS
-
5. Editing fields in your table in Access 2010 for Windows7m 22sOnce a field has been inserted into your table, it can be modified at any time. This video tutorial will show you how to rename it, resize it and even hide it. You will also find out how to change its data type and apply default values that appear each time a new record is created. FREE ACCESS
-
6. Editing your database field properties in Access 2010 for Windows5m 57sIn order to avoid any mistakes when entering data into your table, you can place limits on exactly what sort of information can be inserted. In this video tutorial, you will find out how to modify a field's properties in order to adjust what sort of data it will accept. FREE ACCESS
-
7. Linking data in different tables in Access 2010 for Windows7m 1sIn a relational database, you can create links between different tables. This is extremely important if you want to be able to manipulate the different data records that you have created. This video tutorial will show you how to create links between the different fields and tables in your database. FREE ACCESS
-
8. Managing data relationships in Access 2010 for Windows4m 48sOnce you have created a relationship between two tables, you can begin to edit it. In this video tutorial, you will find out how to define what sort of relationship exists between your selected fields, and how to remove a link once it has become superfluous or undesired. FREE ACCESS
-
9. Visualizing object dependencies in Access 2010 for Windows4m 12sIf you want to quickly visualize exactly how your tables are linked, you can use the object dependencies function. Find out how to use this tool in this video tutorial. 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
Book
Access For Dummies
