In this eight parts leaning series you’ll see how Access 2013 is Microsoft’s database management software that allows users to enter, manage, and build reports on large amounts of data. Get to know the Access work environment, master tables, Data Fields, and Data Types; understand queries and create a simple select query; build a simple UI with forms; and learn how to create simple reports. Advanced topics include automating tasks with macros and Importing, linking, and exporting external data.
This course is designed to teach students intermediate level skills in Microsoft Access 2013. In this course, students will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Students will also learn how to automate processes with Macros, advanced form techniques using Conditional Formatting, Tab controls, Combo Box controls and Sub-Forms, and advanced report techniques using Sub-Reports, columns and inserting charts.