Courses / Access 2000 Advanced
Access 2000 Advanced
- Provider
- Solveway
- Course ID
- 074 402
- Summary
- 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.
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
About the Course
- Target
- Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.
- Entry requirements
- Access 2000: Foundation and Access 2000: Intermediate or equivalent knowledge.
- Outcome
- Students will learn how to analyze 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
- Qualifications
- Certificate of attendance
- Content
- 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 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
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 - Cost
- Deals Available for Single and Group Bookings.
Please call 0203 015 4316 or email us at info@solveway.co.uk for our latest deals - Enrolment
Availability
- Duration
- 1 Day
- Provider
- Solveway
Venues/Contact
Training can be carried out at your own premises
Telephone 0203 015 4316
Email info@solveway.co.uk
Venue Notes All training can be carried out at your premises or at Solveway.
Training can be carried out at your own premises
Telephone 0203 015 4316
Email info@solveway.co.uk
Contact Keith Swain
Courses
Syndicate
