Microsoft Office Tutorials and References
In Depth Information
Section 12: Introducing the power of macros
12
Introducing the
power of macros
In this section:
Unlike Excel, which has a macro recording tool that creates code
Enabling macro commands and
disabling Trusted Documents
Linking together forms
Linking a form to a query
Validating data entered in controls
Making controls change other
controls
Executing a saved import/export
Processing data with action queries
that you can then edit in the VBA editor, Access has two separate
approaches to programming. The first is macro programming (there is no
recording tool), which comes equipped with a special macro designer and
set of macro commands. The second approach is VBA programming, which
has an editor and environment very similar to the Excel programming
environment. There is a crossover between the macro commands and VBA
programming—that is, macros can be converted to VBA, and VBA can
make use of macro commands.
Macros have many uses, including linking together user interface elements
like forms, queries and reports, performing complex data validation, or
executing sequences of operations to import and process sets of data.
In programming macros, you can save sequences of instructions either as a
stand-alone macro, which you can execute from the navigation pane, or as
an embedded macro inside a form/report.
Search JabSto ::




Custom Search