Save hundreds of hours in developing training materials. Download our proven content used by trainers in 164 countries worldwide.
Facilitate perfect workshops everytime with high-quality training material with all the training components you need.
Focus your attention on the training and we'll take care of the materials.
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
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
Activity 1-3: Creating a Subform
TOPIC D: Organize Information with 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
Activity 1-6: Inserting and Formatting Form Headers and Footers
TOPIC G: Apply Conditional Formatting
Activity 1-7: Applying Conditional Formatting
Lesson 2: Using Data Validation
TOPIC A: Form and Field Validation
The Input Mask Wizard
Input Mask Characters
Activity 2-1: Validating Data With a Field Property
TOPIC B: Data Validation Using Controls
The Combo Box Control
The List Box Control
The Option Group Control
Activity 2-2: Using Combo Box Controls in a Form
Lesson 3: Using Macros To Improve User Interface Design
TOPIC A: Create a Macro
The Macro Builder Window
Types of Macro Actions
Activity 3-1: Creating a Macro
TOPIC B: Restrict Records Using a Condition
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
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
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
Database Access Modes
The Compact and Repair Database Option
Activity 4-2: Managing a Database
TOPIC C: Determine 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
Activity 4-5: Analyzing the performance of a database
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
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
The Package and Sign Feature
Activity 5-5: Packaging a Database With a Digital Signature
Lesson 6: Managing Switchboards
TOPIC A: Create a Database Switchboard
Activity 6-1: Creating a Simple Switchboard
TOPIC B: Modify a Database Switchboard
Activity 6-2: Modifying a Database Switchboard
TOPIC C: Set Startup Options
Database Startup Options
Activity 6-3: Setting Startup Options
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
Keyboard Shortcut Quick Reference Sheet
What you get
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.
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.
Each Velsoft courseware title comes with a Lab Workbook loaded with activities and exercises to practice and reinforce the learners' understanding of the course objectives. 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.
Courseware from Velsoft is designed to give you everything you need for use in the classroom or workshop. This includes PowerPoint slides for classroom use, prepared for you in advance.
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes in two pages the most important elements in each courseware title.
Easily make any changes to the material you like. Simply open in MS Word or Google Docs and localize the content to meet your training needs.
Print only what you need, when you need it. Print as many copies at your location as you like - forever. This includes editing and printing.
Train as many people at your location as you like - forever. There is no per-user pricing or limit on the number of people that can be trained.
This course comes with a perpetual license which means once you purchase it you never have to pay anything ever again.
Courseware you can customize.
Available as an eLearning Course
eLearning you can customize.
Courseware you can customize.
Courseware you can customize.