Access 2013 Development LiveLessons (Video Training)

Access 2013 Development LiveLessons (Video Training)

Released October 2013
Publisher(s): Pearson
ISBN: 013355449X

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Learn everything you need to know in order to build powerful and robust Access applications!

  • Start-to-finish personal training on Access 2013 Development: just watch and learn!
  • Simple, quick video walkthroughs of the tasks you perform most often!
  • Great personalized training at a fraction of the cost...for everyone who doesn't have time to read a book!

These video lessons will ensure that you can harness the power of Access for development faster and more easily than ever before! In 19 thorough parts, Access 2013 Development LiveLessons shows you how to increase add finesse and polish to your databases so they look like the pros. Expert Alison Balter simplifies powerful features and tools so you can truly harness the power built into Access! Just watch: You’ll master high-powered skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Access 2013 Development fast!

Bestselling author and trainer Alison Balter provides the novice programmer with 9+ hours of hands-on step-by-step video training on the fundamentals of creating Access applications. Packed with real-world examples on how to put Access to use in everyday programming, you'll start with the basics, and learn how to build applications at your own pace.

About the Author:

Alison Balteris the president of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 27 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, University of Southern California, Massachusetts Institute of Technology, and others.

Alison specializes in teaching others how to develop Windows and Web applications. She is a leading author of 15 Microsoft Access books and SQL Server books, including Alison Balter’s Mastering Access 2003 Development, Alison Balter’s Mastering Access 2007 Development, Teach Yourself SQL Server 2005 Express in 24 Hours, Using Access 2010, and Access 2013 Absolute Beginners Guide. Alison is also featured in several training videos for both SAMS and Experts Exchange. Most recently, Alison was given the honor of Microsoft Access MVP 2012, an honor bestowed on a select few individuals who have donated their time to bettering the development community. She was also selected as 2012/2013 Ventura County Woman Business Owner of the Year. Alison can be reached at alison@techismything.com.

Table of contents

  1. Introduction
    1. Introduction to Access 2013 LiveLessons
  2. Lesson 1: Access As A Development Tool
    1. Learning Objectives
    2. Why Microsoft Access?
    3. What Types of Applications Can I Build with Microsoft Access?
  3. Lesson 2: VBA: The Basics
    1. Learning Objectives
    2. What Types of Modules are Available?
    3. Working with Variables
    4. Working with Constants
    5. Adding Comments to Your Code
    6. Using the Line Continuation Character
    7. Using VBA Control Structures
    8. Passing Parameters and Returning Values
    9. Executing Procedures in the Code Window
    10. The DoCmd Object: Performing Macro Actions
    11. Working with Built-In Functions
    12. Using Built-In Dialog Boxes
    13. Editor Tips and Tricks
  4. Lesson 3: Objects, Properties, Methods, And Events Explained
    1. Learning Objectives
    2. Understanding Access’s Object Model
    3. Understanding Objects, Properties, Events, and Methods
    4. Referring to Objects
    5. Declaring and Assigning Object Variables
    6. Differences Between Objects and Collections
    7. Passing Objects to Subroutines and Functions
    8. Determining the Type of a Control
    9. Special Properties That Refer to Objects
  5. Lesson 4: Debugging: Your Key To Successful Development
    1. Learning Objectives
    2. Avoiding Bugs
    3. Harnessing the Power of the Immediate Window
    4. Using Breakpoints to Troubleshoot
    5. Stepping Through Code
    6. Setting the Next Statement to Execute
    7. Using the Call Stack Window
    8. Working with the Locals Window
    9. Working with the Watch Window
  6. Lesson 5: Error Handling: Preparing For The Inevitable
    1. Learning Objectives
    2. Implementing Error Handling
    3. Using On Error Statements
    4. Using Resume Statements
    5. The Cascading Error Effect
    6. Raising an Error
    7. Using the Errors Collection
    8. Creating a Generic Error Handler
    9. Preventing Your Own Error Handling from Being Invoked
  7. Lesson 6: What Are Activex Data Objects And Data Access Objects And Why Are They Important?
    1. Learning Objectives
    2. DAO versus ADO – When to Use Each
    3. The Data Access Object Model
    4. Getting to Know DBEngine
    5. Using CurrentDB()
    6. Working with DAO Recordset Types
    7. DAO Recordset Properties and Methods
    8. Using DAO Code to Modify Table Data
    9. Using DAO Code to Modify Database Objects
    10. Examining the ADO Object Model
    11. Working with Connections
    12. Working with ADO Recordset Types
    13. ADO Recordset Properties and Methods
    14. Using ADO Code to Modify Table Data
    15. Using ADO Code to Modify Database Objects
  8. Lesson 7: Advanced Form Techniques
    1. Learning Objectives
    2. Form Events and When To Use Them?
    3. Order of Events for Forms
    4. Utilizing Section and Control Events
    5. Taking Advantage of Built-In Form-Filtering Features
    6. Switching a Form’s Record Source
    7. Power Combo Box and List Box Techniques
    8. Synchronizing a Form with Its Underlying Recordset
  9. Lesson 8: Advanced Report Techniques
    1. Learning Objectives
    2. Report Events and When to Use Them
    3. Order of Events for Reports
    4. Practical Applications of Report Techniques
  10. Lesson 9: Advanced Query Techniques
    1. Learning Objectives
    2. Self-Joins
    3. Union Queries
    4. Subqueries
    5. The Propagation of Nulls and Query Results
    6. Using User-Defined Functions with Queries
  11. Lesson 10: Macro Basics
    1. Learning Objectives
    2. The Basics of Creating and Running a Macro
    3. Harness the Power of Submacros
    4. Control your Macros Using Program Flow
    5. Run a Macro from the Macros Group of the Navigation Pane
    6. Trigger a Macro from a Form or Report Event
    7. Modify an Existing Macro
    8. Create an Embedded Macro
  12. Lesson 11: Advanced Macro Techniques
    1. Learning Objectives
    2. Create Data Macros
    3. Create a Drillthrough Macro
    4. Learn What Other New Features Are Available in Macros
    5. Debug a Macro
    6. Convert a Macro to VBA Code
    7. Create an AutoExec Macro
  13. Lesson 12: Advanced VBA Techniques
    1. Learning Objectives
    2. Working with Arrays
    3. Advanced Function Techniques
    4. Working with Empty and Null
    5. Creating and Working with Custom Collections
  14. Lesson 13: Exploiting The Power Of Class Modules
    1. Learning Objectives
    2. Creating and Using a Class Module
    3. Creating Multiple Class Instances
    4. More About Class Modules
    5. Class Modules in Use
  15. Lesson 14: Using External Data
    1. Learning Objectives
    2. Using Code to Import External Data
    3. Using Code to Link to External Data
    4. Refreshing and Removing Links
  16. Lesson 15: Automation: Communicating With Other Applications
    1. Learning Objectives
    2. Creating an Automation Object
    3. Controlling Excel from Access
    4. Closing an Excel Automation Object
    5. Creating a Graph from Access
    6. Controlling Word from Access
    7. Controlling PowerPoint from Access
    8. Controlling Outlook from Access
  17. Lesson 16: Exploiting The Power Of The Windows API
    1. Learning Objectives
    2. Declaring a Windows API Function
    3. Using a Windows API Function
    4. Getting Information About the Operating Environment
    5. Determining Drive Information
  18. Lesson 17: Developing Client/Server Applications
    1. Learning Objectives
    2. Understanding the Client/Server Model
    3. Deciding Whether to Use the Client/Server Model
    4. Roles Access Plays in the Application Design Model
    5. Defining an ODBC Data Source
    6. Upsizing an existing Access Database
    7. Working with Linked Tables
    8. Working with SQL Server Views
    9. Using Pass-Through Queries
    10. Executing Stored Procedures
    11. Working with SQL User-Defined Functions
    12. Building Client/Server Friendly Forms
    13. Building Client/Server Friendly Reports
  19. Lesson 18: Working With And Customizing Ribbons
    1. Learning Objectives
    2. Customizing the Ribbon
    3. Applying a Custom Ribbon when a Database Opens
    4. Associating a Custom Ribbon with a Form or Report
    5. Executing a Macro from a Ribbon
  20. Lesson 19: Putting It All Together – A Complete Application
    1. Learning Objectives
    2. Designing the Tables to Store Your Data
    3. Building the Queries to Extract the Data You Need
    4. Building the Forms to Edit Your Data
    5. Designing the Reports to Display Your Data
    6. Building the Macros Necessary to Automate Your Application
    7. Polishing Off Your Application with the Necessary VBA Code
  21. Summary
    1. Summary of Access 2013 LiveLessons

Product information

  • Title: Access 2013 Development LiveLessons (Video Training)
  • Author(s):
  • Release date: October 2013
  • Publisher(s): Pearson
  • ISBN: 013355449X