Our Access VBA sample application will again be a combination application with Word being thrown into the mix along with Access. We're going to take a favorite verse from a poem by Lewis Carroll (of "Alice in Wonderland" fame) called, "The Walrus and the Carpenter" and copy it, line by line, into an Access database from a Word document. While this may not be a glowing business application, the basic ideas certain could be used in one. For example, saving comments from documents sent in by customers in a database. Besides, if you're a fan of Lewis Carroll as I am, sorting the lines of his poems randomly could make them make more sense.

To start our appplication, first create a blank Access database. Click New to create a single table with just a key field and a memo field in Design View. Here's the table you should create: