Access JumpStart 2.0 | Blog

A Rapid Development Framework for Microsoft Access

This is an experiment today. I don’t think I’ll get fully through what I would want to do today, but I want to start a little series on using TDD along with a form in Access.

What would the whole process look like from beginning to end?

I’m thinking something like this:

  1. Describe Test Driven Development in general. What is it? Why use it?
  2. Writing down what we want to accomplish.
  3. Transforming the end result into a series of testable requirements.
  4. Considering testing frameworks for Access VBA and running series of tests.
  5. TDD Cycle: Writing a test.
  6. TDD Cycle: Writing code to pass a test.
  7. TDD Cycle: Refactoring the code.
  8. Doing that over and over again. When are you done?
  9. A full example of Access VBA TDD using a form (probably something really simple like a login form).

You guys interested? Have you ever heard of TDD before? Have you ever tried using it? Do you use a testing framework? If so, which one? If you have used TDD, have you ever used it in conjunction with an Access Form or Report?

I’ll aggregate any responses I get via email and include them in tomorrow’s message!