| Access 2000 -
Intermediate Course
specifications
Course number: 011 311
Software version number: 9.0
Course length: 1 day
Course description
Overview:
Students will learn how to enhance database designs by using the principles of data
normalization, table relationships, and referential integrity; by querying multiple tables
for data used in customized forms, reports, and subreports; and by creating data access
pages. This course meets many of the Microsoft Proficiency Guidelines for Access at the
Expert level.
Prerequisites:
The prerequisite for this course is Access 2000: Introduction or equivalent
knowledge.
Delivery method:
Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits:
Students will learn how to take the guesswork out of creating databases by using
data-normalization techniques. They will learn how to take advantage of relational
database efficiency to maintain data by establishing relationships and enforcing
referential integrity. In addition, students will save data entry time by using sound
table design techniques to control data entry and automate tasks. Students will also
benefit by becoming familiar with Access features that will enable them to customize forms
and reports, and to share data over an intranet or the Internet by creating and using data
access pages.
Target student:
Students enrolling in this course should have a basic level of understanding of the
Access 2000 interface, and should have experience designing tables, simple queries, forms,
and reports.
What's next:
Access 2000: Intermediate is the second course in this series. Access
2000: Advanced, the next course in this series, teaches students how to use a variety
of query techniques, and how to create more efficient forms and reports, and macros. After
taking the Advanced course, students who want to learn how to develop an application and
tie the objects together into a cohesive system by using macros and Visual Basic for
Applications code can take Access 2000: Application Development.
Access 2000 -
Intermediate
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:
- Normalize tables to reduce redundancy, set relationships between tables, and
implement referential integrity.
- Use the Lookup Wizard to create lookup lists in the Design view of a table and
use subdatasheets to enter data in related tables.
- Create an input mask in Design view, use the Input Mask Wizard to specify input
masks, set different properties of a field in Design view, and set validation rules for
entering data in a field.
- Create self-joins, inner joins, and outer joins, create calculated fields in a
query, create queries to add, modify, and delete data from tables, and create queries to
create a new table.
- Use queries to view summarized and grouped data from tables, create crosstab
queries to summarize grouped data, create parameter queries, and set indexes in a table.
- Use controls to add graphics and calculated fields, add combo boxes to a form,
and add unbound controls to a form.
- Customize headers and footers in a report, use the HideDuplicates property to
hide duplicate values in a report, use functions to add calculated values, and use
subreports to view data from related tables in a report.
- Create and modify charts in forms and reports.
|