Microsoft Access 2000 Advanced
Short course
In
Description
-
Type
Short course
-
Methodology
Inhouse
-
Duration
1 Day
Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.
Reviews
Subjects
- Microsoft Access
Course programme
Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.Microsoft Access 2000 Training Course (Advanced) Outline
- Parameter and action queries
- Creating parameter queries
- Creating action queries
- Query joins and crosstab queries
- Joining tables and working with join properties
- Creating crosstab queries
- Editing limitations in query datasheets
- Using advanced form technqiues
- 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
- 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
- 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
- Using advanced report techniques
- Customizing the appearance and functionality of a report
- Mailing and other types of labels
- Access 2000 and the Internet
- Using hyperlinks
- Access tools for working on the Internet
Microsoft Access 2000 Advanced