Understanding Tables, Fields, & Entries in Access 2010 for Windows

Access 2010 (Windows)    |    Intermediate
  • 9 videos | 52m 28s
  • Earns a Badge
Likes 5 Likes 5
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

  • Playable
    1.  Understanding your database in Access 2010 for Windows
    6m 41s
    If 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
  • Playable
    2.  Creating a table in Access 2010 for Windows
    4m 58s
    In 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… FREE ACCESS
  • Locked
    3.  Managing your tables in Access 2010 for Windows
    6m 40s
    In 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… FREE ACCESS
  • Locked
    4.  Inserting fields in your table in Access 2010 for Windows
    4m 49s
    Fields 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
  • Locked
    5.  Editing fields in your table in Access 2010 for Windows
    7m 22s
    Once 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… FREE ACCESS
  • Locked
    6.  Editing your database field properties in Access 2010 for Windows
    5m 57s
    In 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… FREE ACCESS
  • Locked
    7.  Linking data in different tables in Access 2010 for Windows
    7m 1s
    In 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… FREE ACCESS
  • Locked
    8.  Managing data relationships in Access 2010 for Windows
    4m 48s
    Once 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… FREE ACCESS
  • Locked
    9.  Visualizing object dependencies in Access 2010 for Windows
    4m 12s
    If 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.