Fully Customizable Courseware For Trainers
Microsoft Access 2010: Part Two
DOWNLOAD A FREE SAMPLE
Microsoft Access 2010: Part Two is the second half of this two-part series which will allow students to finish preparing for the Microsoft Office Specialist Exam on Access 2010 (77-885). It?focuses on advanced training areas, such as:
- Building custom forms
- Using advanced database management tools
- Managing switchboards
- Leveraging tools to validate data
Velsoft training materials are guaranteed to be top-quality, comprehensive, customizable, and easy to use.
download a free sample today and view the?first lesson of Microsoft Access 2010: Part Two courseware!
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Advanced Form Design
TOPIC A: Add Controls to Forms
Types of Controls
Command Buttons
Quick Start Fields
Calendar/Datepicker Control
Form Layouts
Quick Styles
Tab Order
The Anchoring Tool
Activity 1-1
TOPIC B: Create Subforms
Subforms
Activity 1-2
TOPIC C: Organize Information with Tab Pages
Tab Pages
Activity 1-3
TOPIC D: Display a Summary of Data in a Form
PivotTables
PivotCharts
Activity 1-4
TOPIC E: Apply Conditional Formatting
Conditional Formatting
Activity 1-5
TOPIC F: Form Options
Form Design Options
Form Arrange Options
Form Format Options
Activity 1-6
Summary
Review Questions
Lesson 2: Field and Record Validation
TOPIC A: Field and Record Validation
Field Properties
Input Mask Wizard
Input Mask Characters
Lookup Lists
Expression Builder
Record Validation
Activity 2-1
TOPIC B: Form Validation
Control Wizards
The Combo Box Control
The List Box Control
The Option Group Control
Activity 2-2
Summary
Review Questions
Lesson 3: Using Macros to Improve User Interface Design
TOPIC A: Create Macros
Macros
The Macro Builder Window
Macro Actions
Types of Macro Actions
Action Arguments
Object Events
Activity 3-1
TOPIC B: Restrict Records Using a Condition
Macro Conditions
The Where Condition
Activity 3-2
TOPIC C: Validate Data Using a Macro
Event Properties for Data Validation
Macro Actions for Data Validation
Embedded Macros
Activity 3-3
TOPIC D: Automate Data Entry Using a Macro
Event Properties for Automating Data Entry
Macro Actions for Automating Data Entry
Activity 3-4
TOPIC E: Convert a Macro to VBA
Macros and VBA
Activity 3-5
Summary
Review Questions
Lesson 4: Advanced Database Management
TOPIC A: Link Tables to External Data Sources
External Data Sources
The Linked Table Manager
Activity 4-1
TOPIC B: Manage a Database
Exclusive Mode
Database Backup
The Compact and Repair Database Option
Activity 4-2
TOPIC C: Determine Object Dependency
Object Dependency
Activity 4-3
TOPIC D: Document a Database
The Database Documenter
Activity 4-4
TOPIC E: Analyze the Performance of a Database
Performance Analyzer
Activity 4-5
Summary
Review Questions
Lesson 5: Distributing and Securing a Database
TOPIC A: Prepare a Database for Multiple User Access
Splitting a Database
Activity 5-1
TOPIC B: Implement Security
Security Strategies in Access 2010
The Message Bar
The Trust Center Dialog Box
Trusted Locations
Activity 5-2
TOPIC C: Set Passwords
Password Protection
Database Access Modes
Activity 5-3
TOPIC D: Convert an Access Database to an ACCDE File
The ACCDE File Format
User Templates
Activity 5-4
TOPIC E: Package a Database with a Digital Signature
Digital Signatures
Digital Certificates
The Package and Sign Feature
Activity 5-5
Summary
Review Questions
Lesson 6: Managing Switchboards
TOPIC A: Create a Database Switchboard
Switchboard Manager
Activity 6-1
TOPIC B: Modify a Database Switchboard
Switchboard Modification
Activity 6-2
TOPIC C: Set Startup Options
Database Startup Options
Activity 6-3
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
Mapping to Microsoft Office Access 2010, Exam 77-885
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.
