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.
Access 2013 Advanced will further build upon the topics covered in the Access 2013 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, using the Table Analyzer Wizard, Normalize tables, and creating Junction Tables, and how to maintain an Access database by creating backups, compacting and repairing, and using the Performance Analyzer Tool. Students will create and modify Switchboards for easier user navigation, configure security and multi-user environments by splitting a database and password protecting a database. In addition, students will automate processes with VBA (Visual Basic for Applications), and learn to use Table Events.
This course is an introduction to Microsoft Access 2013. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course.
This is the intermediate course in the Microsoft Word 2013 series. This course expands upon the topics covered in the Word 2013 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts.
This course is designed to be the intermediate level and increase knowledge of Excel 2013. Students will learn intermediate functions and formulas, including creating and using range names, and logical, lookup, date and time, and common text functions.
This course is designed to teach students intermediate level skills in Microsoft Access 2016. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2016 Advanced course.