|
Access
2000: Advanced
Prerequisites: Access 2000 -
Introduction or equivalent knowledge.
Lesson 1:
Parameter and action queries
- Creating parameter queries
- Creating action queries
Lesson 2:
Query joins and crosstab queries
- Joining tables and working with
join properties
- Creating crosstab queries
- Editing limitations in query
datasheets
Lesson 3:
Using advanced form techniques
- Organizing field placement
- Using functions to control data
entry
- Adding an option group to a form
- Using a form as the user
interface
- Creating a form that contains a
subform
Lesson 4:
Creating basic macros to automate forms
- Macro basics
- Attaching a macro to a command
button
- Revising a macro
- Attaching a macro to an event in
a form
Lesson 5:
Using macros to provide user interaction and automate tasks
- Using a macro to provide user
interaction
- Using macros to automate data
entry
- AutoKeys and AutoExec macros
Lesson 6:
Using advanced report techniques
- Customizing the appearance and
functionality of a report
- Mailing and other types of
labels
Lesson 7:
Access 2000 and the Internet
- Using hyperlinks
- Access tools for working on the
Internet
|
