Make select
queries more versatile and useful by using parameters; use action queries to update data
values and add or delete records. Generate different query types by creating various
types of joins between tables; use crosstab queries to summarize data.
Use advanced form features including properties, functions, and design tools to
facilitate data entry and improve accuracy in forms; display table information that has a
one-to-many relationship by creating forms that contain subforms.
Automate tasks by creating macros to open forms and control form properties.
Make forms more functional by using macros to provide user interaction and automate
data entry.
Make reports more concise and easier to understand by using properties and functions in
report controls; create mailing labels.
Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar.