Summary

In this chapter we've covered the important aspects of building code into useful sequences of statements, decision structures, and loops . In the previous chapter we showed variables and their use - here we've looked at putting those variables into practice, and used them to help us control procedures.

In particular we've looked at:

• Using the If and Select statements to make decisions. These allow us to make our code change its behavior according to user input.

• Using loops to avoid unnecessarily repeating statements of code, and allowing actions to continue until user input decides otherwise .

• Using arrays to store several pieces of information of the same type. This allows the program to be flexible in allowing any number of user defined inputs.

Now that we've spent a while building these fundamentals it's time to start delving into Access, and the objects it controls.