This course teaches the basics of working with databases by teaching how to use Microsoft Access tables.
During this introductory course on using Microsoft Access tables, we’ll teach you the basics for working with them – in both Microsoft Access 2010 and Access 2013.
What you’ll learn
- Creating database tables in Access 2010.
- Creating database tables in Access 2013.
- Relationship between tables.
- Relationship between tables and basic setup of relationships.
- Entering data types into tables.
- Changing table attributes.
- Copy, rename, and delete records.
Course Content
- Access 2010 Tables –> 7 lectures • 1hr 36min.
- Access 2013 Tables –> 7 lectures • 57min.
Requirements
During this introductory course on using Microsoft Access tables, we’ll teach you the basics for working with them – in both Microsoft Access 2010 and Access 2013.
We’ll start with some basic concepts to help you understand how a table organizes information into rows and columns. Then we’ll provide an easy to follow example using some fairly straightforward data. We’ll then move into some of the more advanced aspects of database tables including creating relationships between tables, one of the fundamentals concepts of database design and management.
Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.