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

IN THIS COURSE

• 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
• 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 your database. FREE ACCESS
• 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 delete entirely a table from your database. FREE ACCESS
• 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
• 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 default values that appear each time a new record is created. FREE ACCESS
• 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 in order to adjust what sort of data it will accept. FREE ACCESS
• 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 how to create links between the different fields and tables in your database. FREE ACCESS
• 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 link once it has become superfluous or undesired. FREE ACCESS
• 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