Microsoft Access 2000 Training Course Advanced
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
Course Duration: 1 Day
You may also be interested in:
Microsoft Access 2002 Training Course- Beginners
To see more details as to our Training Venues click one of the links below: Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester |