Course Outline
Pre-Requisites
The prerequisites for this course are Access Level 1 or a solid working knowledge of Access or other database applications.
Microsoft Access 2016 - Level 1 / Intro
Lessons
WHAT YOU'LL LEARN
In this course, you will learn to create and manage an Access 2016 database. You will:
- Create Subforms
- Customize a form layout to improve usability and efficiency of data entry
- Organize data into appropriate tables to ensure data dependency and minimize redundancy
- Lock down and prepare a database for distribution to multiple users
- Create and modify a database switchboard and set the startup options
- Inserting Application Parts
- Using the Table Analyzer Wizard
- Creating Validation Rules
- Configuring Validation Messages
- Creating Lookup Fields
- Creating Value Lists
- Marking Fields as Required
- Marking a Field for Indexing
- Creating Input Masks
- Limiting User Access to a Form
- Adding Calculated Fields in a Form
- Using the Expression Builder
- Creating Checkboxes and Command Buttons
- Building Command Button Events
- Creating Event Procedures
- Using Hyperlinks in a Form
- Adding Links to Other Database Objects
- Inserting a Mailto Link in a Form
- Adding a Browser Control to a Form
- Exporting Your Form to XML
- Exporting a Form as a Word Document
- Exporting a Form as HTML
- Sending a Form as an E-mail Attachment
- Exporting a Form to Other Formats
- Creating Subforms
- Using Subforms
- Linking Subforms with Parent Forms
- Formatting a Subform within a Main Form
- Creating a Split Form
- Splitting an Existing Form
- Using a Split Form
- Fixing the Form Separator
- Creating a Navigation Form
- Adding Tabs to a Navigation Form
- Creating a Tab Hierarchy
- Displaying the Navigation Form When the Database Opens
- Creating and Using Parameter Queries
- Creating and Using Crosstab Queries
- Creating and Using Make-Table Queries
- Creating and Using Multiple Table Queries
- Creating and Using Append Queries
- Creating and Using Delete Queries
- Creating and Using Update Queries
- What is a Subquery?
- Creating a Subquery
- Subqueries with Aggregate Functions and Nested Subqueries
- Using the IN Keyword with Subqueries
- Adding Calculated Fields
- Adding Concatenated Fields
- Inserting Sub Reports
- Exporting Reports in Different Formats
- Backing Up the Database
- Splitting the Database
- COM Add-ins
- Digital Signatures
- Managing Your Database
- Customizing Access
- An Introduction to SQL
- Understanding SQL
- Using the Select Statement
- Using Subqueries
- Using SQL Joins
Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Training Location
Global Knowledge Ottawa
360 Albert Street
Suite 720
Ottawa,
Ontario
Canada
