Fully Customizable Courseware For Trainers
Microsoft 365 Access: Part 2
DOWNLOAD A FREE SAMPLE
Microsoft’s flagship database application, Access 365 provides the ability to create and manage databases. The second part of Velsoft’s Microsoft Access 365 courseware builds on knowledge gained in the first part, giving an intermediate level of knowledge.
Lessons include: implementing advanced form design, using data validation, using macros to improve user interface design, using advanced database management, distributing and securing a database, and managing switchboards.
After completing this course, users should feel comfortable managing their databases, as well as carrying out simple database development and management. Users will understand how to find information about these databases and to use validation techniques to ensure the data collected is reliable.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How to Use This Book
Lesson 1: Implementing Advanced Form Design
TOPIC A: Add Controls to Forms
About Form Editing Modes
About the Types of Controls
Adding a Date Picker Control
About Quick Styles
About Tab Order
Using the Anchoring Tool
Activity 1-1: Adding Controls to Forms
TOPIC B: Set Form Controls
Moving Form Controls
Add Form Controls from the Field List
Remove Form Controls
Modify Data Sources
Set Form Control Properties
Activity 1-2: Managing Controls on a Form
TOPIC C: Create Subforms
About Subforms
Activity 1-3: Creating a Subform
TOPIC D: Organize Information with Tab Pages
Tab Pages
Activity 1-4: Organizing Information with Tab Pages
TOPIC E: Enhance Navigation with Forms
Creating a Navigation Form
Using a Navigation Form
Activity 1-5: Creating and Using a Navigation Form
TOPIC F: Format a Form
Insert Headers and Footers
Insert Images
Sort Records
Apply Themes
Insert Backgrounds
Change Margins
Activity 1-6: Inserting and Formatting Form Headers and Footers
TOPIC G: Apply Conditional Formatting
Conditional Formatting
Activity 1-7: Applying Conditional Formatting
Summary
Review Questions
Lesson 2: Using Data Validation
TOPIC A: Form and Field Validation
Field Properties
Input Masks
The Input Mask Wizard
Input Mask Characters
Lookup Lists
Expression Builder
Record Validation
Activity 2-1: Validating Data With a Field Property
TOPIC B: Data Validation Using Controls
Control Wizards
The Combo Box Control
The List Box Control
The Option Group Control
Activity 2-2: Using Combo Box Controls in a Form
Summary
Review Questions
Lesson 3: Using Macros To Improve User Interface Design
TOPIC A: Create a Macro
Macros
The Macro Builder Window
Macro Actions
Types of Macro Actions
Action Arguments
Object Events
Activity 3-1: Creating a Macro
TOPIC B: Restrict Records Using a Condition
Macro Conditions
The Where Condition
Activity 3-2: Using the Where Condition to Restrict Data
TOPIC C: Validate Data Using a Macro
Event Properties for Data Validation
Macro Action for Data Validation
Embedded Macros
Activity 3-3: Validating Data Using a Macro
TOPIC D: Automate Data Entry Using a Macro
Event Properties for Automating Data Entry
Macro Actions for Automating Data Entry
Activity 3-4: Automating Data Entry Using a Macro
TOPIC E: Convert a Macro to VBA
Macros and VBA
Activity 3-5: Converting a Macro to VBA
Summary
Review Questions
Lesson 4: Using Advanced Database Management
TOPIC A: Link Tables to External Data Sources
External Data Sources
The Linked Table Manager
Activity 4-1: Link Tables to External Data Sources
TOPIC B: Manage a Database
Exclusive Mode
Database Access Modes
Database Backup
The Compact and Repair Database Option
Activity 4-2: Managing a Database
TOPIC C: Determine Object Dependency
Object Dependency
Object Dependencies Task Pane
Activity 4-3: Viewing Object Dependency
TOPIC D: Document a Database
The Database Documenter
Activity 4-4: Documenting a Database
TOPIC E: Analyze the Performance of a Database
Performance Analyzer
Activity 4-5: Analyzing the performance of a database
Summary
Review Questions
Lesson 5: Distributing and Securing a Database
TOPIC A: Split a Database for Multiple User Access
Splitting a Database
The Database Splitter
Merging a Database
Activity 5-1: Splitting a Database
TOPIC B: Implement Security
Security Strategies in Access
The Message Bar
The Trust Center Dialog Box
Trusted Locations
Activity 5-2: Adding a Trusted Location
TOPIC C: Set Passwords
Password Protection Guidelines
Activity 5-3: Setting a Database Password
TOPIC D: Convert an Access Database to an ACCDE File
The ACCDE File Format
Activity 5-4: Converting a Database to ACCDE Format
TOPIC E: Package a Database with a Digital Signature
Digital Signatures
Digital Certificates
The Package and Sign Feature
Activity 5-5: Packaging a Database With a Digital Signature
Summary
Review Questions
Lesson 6: Managing Switchboards
TOPIC A: Create a Database Switchboard
Switchboards
Switchboard Manager
Activity 6-1: Creating a Simple Switchboard
TOPIC B: Modify a Database Switchboard
Switchboard Modification
Activity 6-2: Modifying a Database Switchboard
TOPIC C: Set Startup Options
Database Startup Options
Activity 6-3: Setting Startup Options
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson Lab 1-2
Lesson Lab 1-3
Lesson 2
Lesson Lab 2-1
Lesson 3
Lesson Lab 3-1
Lesson Lab 3-2
Lesson 4
Lesson Lab 4-1
Lesson Lab 4-2
Lesson 5
Lesson Lab 5-1
Lesson Lab 5-2
Lesson 6
Lesson Lab 6-1
Course Wrap-Up
Post-Course Assessment
Course Summary
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 Student Manual gives each participant the ?student? version of the course you will be teaching.
Exercise Workbook
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.
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.
