Access 2010: Intermediate

Building on the skills you developed in the introductory lesson, this intermediate course will teach you how to improve your Access 2010 databases with features like table relationships and advanced queries. To begin, you’ll learn about the 3 different types of table relationships and when to use them. Then, you’ll learn how to use field data types and tools like validation rules and input masks to keep entered data consistent. Discover how to use action queries to update and delete data more efficiently, as well as how to create calculated and parameter queries. Lastly, the course explains how to enhance your forms and reports with practical controls.
This course is the second part in a 3-part series on Access 2010. To take your skills to the next level, watch the next course in the series, Access 2010 Advanced.