Fully Customizable Courseware For Trainers
Microsoft Access 2010: Part Two
Deliver high-impact training with professionally designed, fully editable courseware you can brand, customize, and deliver in-person or online
$795.00
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
 Select the format that works best for your organization or learners
Instructor-Led Training Kits
Complete training kit with everything you need to facilitate.
- Instructor Guide
- Participant Manual
- PowerPoint Slides
- Print-Ready Files
- Editable in Word/PowerPoint
- More
SCORM eLearning Courses
Ready-to-deploy eLearning for any SCORM-compliant LMS.
- SCORM 1.2 Package
- LMS Compatible
- Completion Certificates
- Progress Tracking
- Mobile Responsive
Storyline Source Files
Editable .story files for full customization in Articulate 360.
- Editable Source Files
- Articulate 360 Format
- Brand Customization
- Content Editing
- Interactive Elements
mos3010
What You Get
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.
