 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students attending this course should be able to work with Access at an intermediate level, and understand Access terminology.
Students will learn how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros, and become familiar with Internet-related Access tools.
Prerequisites:
Access 2000 Introduction and Access 2000 Intermediate, or equivalent knowledge.
Unit 1 : Parameter and action queries
- Creating parameter queries
- Creating action queries
- Joining tables and working with join properties
- Crosstab queries
- Editing limitations in query datasheets
Unit 3 : Using advanced form techniques
- Organising 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 containing a subform
Unit 4 : Creating basic macros to automate forms
- Macro basics
- Attaching a macro to a command button
- Revising macros
- Attaching a macro to an event in a form
- Using macros to provide user interaction
- Using macros to automate data entry
- AutoKeys and AutoExec macros
- Customising the appearance and functionality of a report
- Mailing and other types of labels
- Using hyperlinks
- Access tools for working on the Internet