Access 2016: Intermediate

This intermediate course outlines how to improve the simple Access 2016 database you created in the introductory course by optimizing your tables, sharing data and using advanced queries. The course first explains how to use field properties to restrict the data that can be entered into your tables. Then, you’ll learn how to import and export information between Access and other applications. The course covers how to use action queries to update, append and delete data, and how to use advanced query types like parameter and calculated queries. You’ll also learn how to boost efficiency by automating various processes with macros and how to utilize more complex form and report features.
This course is the second part in a 3-part series on Access 2016. To take your skills to the next level, try out the next course in the series, Access 2016 Advanced.