Microsoft Office Tutorials and References
In Depth Information
Topic A: Creating forms
Data is entered and stored by using content controls, which guide and restrict the user’s
actions and tell the user how to complete the form. For example, a drop-down list
control provides a specific list of possible responses. Users’ responses are limited to
only those options in the list. Content controls also provide text to instruct users, such as
“Click here to enter text,” as shown in Exhibit 4-2. Content controls can be used in
templates, forms, and other documents.
Exhibit 4-2: An uncompleted form showing content controls
Linking forms to databases
You’ve seen how macros can be created in Visual Basic for Applications (VBA) to
automate multi-step, repetitive, or complex tasks in Word. You can also use VBA to
link a Word form to a database. For example, you might want to automatically process
data from submitted forms by collecting it in a database, or you might want to use
information in a database to populate fields in a Word form.
Although the specifics are beyond the scope of this course, a skilled VBA programmer
could use Open Database Connectivity (ODBC) to create those interactions between
Word forms and databases. ODBC provides a set of standards by which VBA code can
communicate with a wide variety of database management systems or database
applications. It could be used, for example, to query a database management system,
such as Microsoft SQL Server, Oracle, or MySQL, or to query a desktop database
application, such as Microsoft Access or FileMaker.