O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Access 2013 Development LiveLessons (Video Training)

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