| Access 2000:
Advanced Course
specifications
Course number: 011 312
Software version number: 9.0
Course length: 1 day
Course description
Overview:
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. This course meets the Microsoft Proficiency Guidelines for
Microsoft Access at the Expert level.
Prerequisites:
Access 2000: Introduction and Access 2000: Intermediate or equivalent
knowledge.
Delivery method:
Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits:
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.
Target student:
Students enrolling in this course should be able to work with Access at an
intermediate level and understand Access terminology.
What's next:
Access 2000: Application Development, the next course in this series,
teaches students how to develop custom applications by using Access.
Access 2000:
Advanced
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a
means to evaluate learning. Upon successful completion of this course, students will be
able to:
- Create and use an advanced form by adding a tab control, an option group control,
and a subform.
- Create and use a macro to open database objects and attach a macro to a command
button.
- Create and use macros to automate user-interaction by using the Condition column
and SetValue action.
- Use Structured Query Language (SQL) to create queries in Access.
- Use hyperlink and data access pages to link an Access database to the Internet or
an intranet.
- Secure a database by setting a password and specifying permissions.
|