Microsoft Office Tutorials and References
In Depth Information
The Six Types of Access Objects
lets you put
In addition to creating reports on normal paper, you can create reports for
printing on envelopes, labels, or other media. Access comes with report
wizards that make creating fancy reports easy. It can also print charts and
cross-tabulations (crosstabs) based on the data in your database.
You’re not limited to printing reports on paper; you can also save reports as
PDF (Portable Document Format) and XPS (Microsoft’s PDF equivalent) files
for e-mailing or posting on the web.
Book V covers how to create and print reports, charts, and crosstabs.
Macros for saving keystrokes
Access includes two separate programming languages: one for macros and
a separate one (Visual Basic for Applications) for larger programs. Macros
are programs that automate the commands you give when you use Access.
Every program in Microsoft Office enables you to write macros to work more
efficiently. You could write a macro, for example, that moves the cursor to
the last record in the Orders table whenever you open the Order Entry form.
(What are the chances that you’d want to edit your very first order? Most
of us are likelier to want to edit the last order or enter a new order.) Or you
could write a macro that moves the cursor to the next applicable blank in a
form, based on the entries you’ve made so far.
After you get some practice in creating macros, you can create buttons on
your forms that run the macros when you click them. You can also tell your
form to run a macro automatically whenever you move to a certain field
on the form or enter data in that field. Handy! Access 2013 enables you to
assign a data macro to a field in a table, too, so that you can trigger an action
whenever your data changes. You can automatically change other values to
match or validate other data against the values you just changed.
You don’t have to be a programmer to create macros; Access helps you
write them by providing menus of commands. Book VI explains how to
create nifty and useful macros to clean up data entry — and other items —