Each student, upon completion of the course, will receive a printable Certificate of Completion from RedWave Technology Group, LLC. This certificate will contain the date of completion, the course title, and the student name.
- SQL and Microsoft Access – This introductory module teaches students all about SQL and Access. Covered here is SQL, SQL statements and naming conventions, as well as SQL syntax.
- Using the SELECT Statement – The SELECT statement is used to find and display specific values from a set of data. It is very powerful, especially when used correctly. This module gives learners insight into selecting all data, selecting specific data, selecting conditional data, and using the ORDER BY statement.
- Using SQL Joins – Joins are used to combine data from separate tables. This module lets students learn how to create simple joins, use an alias, sort joins, and create outer joins.
- Using Subqueries – A subquery is a SELECT statement nested in another statement or subquery. Usually, subqueries are used to return data that will be used in the main query as a condition to help narrow down the data that is being retrieved. This module teaches students what subqueries are, how to create a subquery, how to create subqueries with aggregate functions and nested subqueries, and use the IN keyword with subqueries.
- Advanced Form Tasks, Part One – This is the first of three modules that looks at advanced form tasks, including limiting user access to a form, creating checkboxes and command buttons, building command button events, and creating event procedures.
- Advanced Form Tasks, Part Two – Picking up where the previous module left off, this module continues the study of advanced form tasks. It looks at how to use hyperlinks in a form, how to add links to other database objects, how to insert a mailto link into a form, how to add a browser control to a form, and how to perform calculations in a form.
- Advanced Form Tasks, Part Three – The third installment of this trilogy wraps up the riveting story of advanced form tasks. Here your students will learn how to export a form to XML, how to export a form as a Word document, how to export a form as HTML, how to send a form as an e-mail attachment, and how to export a form to other formats.
- Creating Split Forms – A split form is designed to give a user two views of data simultaneously. This module endows learners with the insight, skills, and tools to embrace this aspect of Access 2013. Learners will come away from this module knowing how to: create a split form, split an existing form, use a split form, and fix the form separator in place.
- Using Digital Signatures – A digital signature ensures that a digital file is authentic and provides information on who created it and if it has been altered in any way. This module teaches what a digital signature is, how to obtain a digital signature, how to attach a signature to a database, and how to remove a signature from a database.
- Using the Trust Center – The Trust Center is where you can find all of the security and privacy settings for Microsoft Office programs. This module advises students how to open the Trust Center, how to trust a database, how to configure macro security, and how to customize the Message Bar.
- Managing COM Add-ins – Add-ins are small programs you can install and enable to add custom commands and new features to Access 2013. Covered here is how to view add-ins; how to open the Add-in Manager; and how to install, disable, and uninstall add-ins.