| Access 2000 -
Introduction Course
specifications
Course number: 011 310
Software version number: 9.0
Course length: 1 day
Course description
Overview:
Students will learn the basic skills necessary to begin using Access 2000.
They will design and create databases, tables, queries, forms, and reports. This course
contributes toward the Microsoft Proficiency Guidelines for Access 2000.
Prerequisites:
Windows 95: Introduction; Windows 98: Introduction; or
Windows 98: Making the Transition, or equivalent knowledge.
Delivery method:
Instructor-led, group-paced, classroom-delivery learning model with
structured hands-on activities.
Benefits:
Students will learn how to create and use database objects, including tables,
queries, forms, and reports.
Target student:
Students enrolling in this course should understand the basic concepts
involved in working with a personal computer (PC). For example, students should be
familiar with terms such as computer memory, data files, and program files. Students
should also be familiar with the components that make up the PC, including input, output,
and storage devices. Students should also be fairly comfortable working in the Windows
environment. No prior knowledge of databases or Access is assumed.
What's next:
Access 2000: Introduction is the first course in this series. Access
2000: Intermediate, the next course in this series, teaches students how to enhance
their database designs by using the principles of normalization and table relationships.
Students also learn how to query multiple tables for data that is used in customized forms
and reports. Students who want to learn advanced features can take the third course in
this series, Access 2000: Advanced. In that course, students learn to create
advanced queries, create more efficient forms and reports, and work with macros. The final
course in this series, Access 2000: Application Development, teaches students to
create custom applications.
Access 2000 -
Introduction
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:
- Use database terminology, plan the design of a database, and use the Help
database.
- Use Datasheet view and Design view.
- Create and save databases, create a table and set the primary key.
- Modify a table's design; add, delete, sort, and filter records.
- Create simple queries and design complex queries to perform calculations.
- Create, use, and modify forms.
- Create, modify, and print reports.
- Import and export database objects.
|