Fully Customizable Courseware For Trainers
Microsoft Access 2016: Part Two
DOWNLOAD A FREE SAMPLE
Microsoft Office Access 2016 is the newest version of Microsoft’s popular database program. This is the second part of a two-level course, and it explores advanced Access features. Whether you’re using Access for the first time, or have been using it for years, this course will help you make the most of Access 2016’s features and tools.
Part Two builds on the training material presented in Velsoft’s Part One course, with lessons that cover:
- Implementing Advanced Form Design
- Using Data Validation
- Using Macros to Improve User Interface Design
- Using Advanced Database Management
- Distributing and Securing a Database
- Managing Switchboards
This customizable courseware package includes an instructor guide, student manual, PowerPoint slides, a quick reference guide, and exercise files.
Download a free sample designed just for this course.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1:
Implementing Advanced Form Design
Types of Controls
Command Buttons
Quick Start Fields
Calendar/Datepicker Control
Form Layouts
Quick Styles
Tab Order
The Anchoring Tool
Activity 1-1
Move Form Controls
Add Form Controls
Remove Form Controls
Modify Data Sources
Set Form Control Properties
Manage Labels
Activity 1-2
Subforms
Activity 1-3
Tab Pages
Activity 1-4
Navigation Control and Navigation Forms
Setting Navigation Options
Creating a Navigation Form
Using a Navigation Form
Activity 1-5
Insert Headers And Footers
Insert Images
Auto-Order Forms
Sort Records
Apply Themes
Insert Backgrounds
Change Margins
Activity 1-5
Conditional Formatting
Activity 1-6
Summary
Review Questions
Lesson 2:
Using Data Validation
Field Properties
Input Masks
The Input Mask Wizard
Input Mask Characters
Lookup Lists
Expression Builder
Activity 2-1
Form Validation
Control Wizards
The Combo Box Control
The List Box Control
The Option Group Control
Record Validation
Activity 2-2
Summary
Review Questions
Lesson 3:
Using Macros to Improve User Interface Design
Macros
The Macro Builder Window
Macro Actions
Types of Macro Actions
Action Arguments
Object Events
Macros in Access Web Apps
Activity 3-1
Macro Conditions
The Where Condition
Activity 3-2
Event Properties for Data Validation
Macro Actions for Data Validation
Embedded Macros
Activity 3-3
Event Properties for Automating Data Entry
Macro Actions for Automating Data Entry
Activity 3-4
Macros and VBA
Activity 3-5
Summary
Review Questions
Lesson 4:
Using Advanced Database Management
External Data Sources
The Linked Table Manager
Activity 4-1
Exclusive Mode
Database Access Modes
Database Backup
The Compact and Repair Database Option
Activity 4-2
Object Dependency
Activity 4-3
The Database Documenter
Activity 4-4
Performance Analyzer
Activity 4-5
Summary
Review Questions
Lesson 5:
Distributing and Securing a Database
Splitting a Database
Merging a Database
Activity 5-1
Security Strategies in Access 2016
The Message Bar
The Trust Center Dialog Box
Trusted Locations
Activity 5-2
Password Protection Guidelines
Activity 5-3
The ACCDE File Format
User Templates
Saving Databases as Templates
Activity 5-4
Digital Signatures
Digital Certificates
The Package and Sign Feature
Activity 5-5
Summary
Review Questions
Lesson 6:
Managing Switchboards
Switchboards
Switchboard Manager
Activity 6-1
Switchboard Modification
Activity 6-2
Database Startup Options
Activity 6-3
Summary
Review Questions
Lesson Lab 1-1
Lesson Lab 1-2
Lesson Lab 1-3
Lesson Lab 2-1
Lesson Lab 3-1
Lesson Lab 3-2
Lesson Lab 4-1
Lesson Lab 4-2
Lesson Lab 5-1
Lesson Lab 5-2
Lesson Lab 6-1
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
Index
Microsoft Office Access 2016 is the newest version of Microsoft’s popular database program. This is the second part of a two-level course, and it explores advanced Access features. Whether you’re using Access for the first time, or have been using it for years, this course will help you make the most of Access 2016’s features and tools.
Part Two builds on the training material presented in Velsoft’s Part One course, with lessons that cover:
- Implementing Advanced Form Design
- Using Data Validation
- Using Macros to Improve User Interface Design
- Using Advanced Database Management
- Distributing and Securing a Database
- Managing Switchboards
This customizable courseware package includes an instructor guide, student manual, PowerPoint slides, a quick reference guide, and exercise files.
Download a free sample designed just for this course.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1:
Implementing Advanced Form Design
Types of Controls
Command Buttons
Quick Start Fields
Calendar/Datepicker Control
Form Layouts
Quick Styles
Tab Order
The Anchoring Tool
Activity 1-1
Move Form Controls
Add Form Controls
Remove Form Controls
Modify Data Sources
Set Form Control Properties
Manage Labels
Activity 1-2
Subforms
Activity 1-3
Tab Pages
Activity 1-4
Navigation Control and Navigation Forms
Setting Navigation Options
Creating a Navigation Form
Using a Navigation Form
Activity 1-5
Insert Headers And Footers
Insert Images
Auto-Order Forms
Sort Records
Apply Themes
Insert Backgrounds
Change Margins
Activity 1-5
Conditional Formatting
Activity 1-6
Summary
Review Questions
Lesson 2:
Using Data Validation
Field Properties
Input Masks
The Input Mask Wizard
Input Mask Characters
Lookup Lists
Expression Builder
Activity 2-1
Form Validation
Control Wizards
The Combo Box Control
The List Box Control
The Option Group Control
Record Validation
Activity 2-2
Summary
Review Questions
Lesson 3:
Using Macros to Improve User Interface Design
Macros
The Macro Builder Window
Macro Actions
Types of Macro Actions
Action Arguments
Object Events
Macros in Access Web Apps
Activity 3-1
Macro Conditions
The Where Condition
Activity 3-2
Event Properties for Data Validation
Macro Actions for Data Validation
Embedded Macros
Activity 3-3
Event Properties for Automating Data Entry
Macro Actions for Automating Data Entry
Activity 3-4
Macros and VBA
Activity 3-5
Summary
Review Questions
Lesson 4:
Using Advanced Database Management
External Data Sources
The Linked Table Manager
Activity 4-1
Exclusive Mode
Database Access Modes
Database Backup
The Compact and Repair Database Option
Activity 4-2
Object Dependency
Activity 4-3
The Database Documenter
Activity 4-4
Performance Analyzer
Activity 4-5
Summary
Review Questions
Lesson 5:
Distributing and Securing a Database
Splitting a Database
Merging a Database
Activity 5-1
Security Strategies in Access 2016
The Message Bar
The Trust Center Dialog Box
Trusted Locations
Activity 5-2
Password Protection Guidelines
Activity 5-3
The ACCDE File Format
User Templates
Saving Databases as Templates
Activity 5-4
Digital Signatures
Digital Certificates
The Package and Sign Feature
Activity 5-5
Summary
Review Questions
Lesson 6:
Managing Switchboards
Switchboards
Switchboard Manager
Activity 6-1
Switchboard Modification
Activity 6-2
Database Startup Options
Activity 6-3
Summary
Review Questions
Lesson Lab 1-1
Lesson Lab 1-2
Lesson Lab 1-3
Lesson Lab 2-1
Lesson Lab 3-1
Lesson Lab 3-2
Lesson Lab 4-1
Lesson Lab 4-2
Lesson Lab 5-1
Lesson Lab 5-2
Lesson Lab 6-1
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
Index
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable manual gives each participant the student version of the course you will be teaching.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
