KT-9201 Microsoft Access 2000: Level 2 Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Microsoft Access 2000: Level 2


Access 2000: Level 2 will help you enhance your database designs by using the principles of data normalization and table relationships, querying multiple tables for data used in customized forms and reports, and using data access pages. Students will learn how to:

  • Normalize tables through fifth normal form.
  • Establish relationships between tables and enforce referential integrity.
  • Maintain data integrity in tables by setting properties, creating a Lookup list, and creating indexes.
  • Use queries to calculate expressions and extract data from multiple tables.
  • Improve form designs by adding bound controls, calculated fields, and a combo box.
  • Create and modify data access pages, and integrate data with other applications.
  • Create and modify reports with the Report Wizard and Design View, add a subreport, and add a calculated control.

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.

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.

What's Next: Access 2000: Level 2 is the second course in this series. Access 2000: Level 3, the final 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.

Click here to view the Course Outline

Students should take Access 2000: Level 1 or have equavalent knowledge.

1 Day  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.

Comments on the Course



Knowledge Transfer Promotions