Microsoft Access 2013 Expert
Course Length: 1 Day
This Microsoft Access 2013 Expert training course gives students a grasp of the tools they need to exploit the high-level user skills of this software. Over the course of a dozen modules learners are introduced to many vital skills they can make use of including: SQL, the SELECT Statement, SQL Joins, subqueries, advanced form tasks, split forms, digital signatures, the Trust Center, COM add-ins, and techniques for customizing Access.
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.
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 2010/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 2010/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.
All good things must come to an end as this course does right here. This final module shows students how to customize Access for their own purposes. Students will be introduced to the skills that will allow them to change user information, change the Office background and theme, and change the default database type and location.
Comments are closed