• Getting Started with VBA
• Introduction to VBA
• Variables, Constants, Inputs, and Outputs
• Decision Structures
• Repetition Structures
• Excel and VBA
• Forms and Controls
• Procedures and Functions for Form Controls
• Loan Payment Schedule and Disclosure Worksheets
• Access and VBA
• VBA in Access
• Working with Recordsets
• Forms, Reports, and Errors in VBA

ABOUT THE EXPLORING SERIES

• The How/Why approach helps students go from learning steps and performing tasks to gaining a true understanding of how to apply Microsoft Office skills.
  • White/Yellow Pages clearly distinguish the theory (white pages) from the skills covered in the Hands-On Exercises (yellow pages) so students always know what they are supposed to be doing.
  • Case Study presents a scenario for the chapter, creating a story that ties the Hands-On Exercises together.
  • Hands-On Exercise Videos–tied to each Hands-On Exercise–walk students through the steps of the exercise while weaving in conceptual information related to the Case Study and objectives.
• The Outcomes focus keep both students and instructors aware of the higher-level learning goals and how those are achieved through discreet objectives and skills.
  • Outcomes are presented at the beginning of each chapter, identifying the learning goals that will be achieved in the material ahead.
  • Enhanced Objective Mapping give students a learning path for the chapter, from the objectives list in the beginning through the exercises at the end.
    • Objectives List: a simple list of key objectives covered in the chapter, with page numbers so students can skip to the objectives where they need the most help.
    • Step Icons appear in the white pages and reference the step numbers in the Hands-On Exercises, providing a correlation between the two so students can easily find conceptual help when they are working hands-on and need a refresher.
    • Quick Concepts Checks appear at the end of each white page section. These questions cover the essential concepts students will need to be successful in working the Hands-On Exercises. Page numbers are included for easy reference to help students locate the answers.
    • Chapter Objectives Review, near the end of the chapter, reviews all the important concepts throughout the chapter.

• NEW! Chapter Objectives Review is redesigned in an easy-to-read bulleted format.
• Microsoft Office Specialist (MOS) Certification Guide directs anyone interested in prepping for the MOS exam to the specific locations to find all content required for the test.
• End-of-Chapter Exercises offer instructors several options for assessment, with 12—15 exercises ranging from multiple choice questions to open-ended projects: Multiple Choice, Key Terms Matching, Practice Exercises, Mid-Level Exercises, Beyond the Classroom Exercises, and Capstone Exercises.
  • NEW! Every chapter now includes a Key Terms Matching exercise, a Collaboration Case, and Soft Skills Case.
  • NEW! Key Terms Matching exercises require students to match key terms to their definitions. This requires students to work actively with important vocabulary and prove conceptual understanding.
  • Enhanced! Mid-Level Exercises
    • Creative Case (for PowerPoint and Word) allows students some flexibility and creativity, without being bound by a definitive solution.
    • Analysis Case (for Excel and Access) requires students to interpret the data they are using to answer an analytic question.
    • Discover Steps encourage students to use Help or to problem-solve to accomplish a task.
  • Application Capstone exercises allow instructors to test students on the entire contents of a single application.