This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview
Access 2000: Level 2 is a hands-on instruction book that 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.
Prerequisites
We designed Access 2000: Level 2 for the student who has a basic level of understanding of the Access 2000 interface, and has designed tables, simple queries, forms, and reports. The prerequisite for this course is Access 2000: Level 1.
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.
Performance-Based Objectives
- 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.
Certification
Access 2000: Level 2 is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
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.
Delivery Method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
What's Next
Access 2000: Level 2 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: Introduction to Application Development.
Course duration
1 Day(s)
Course outline
Lesson 1: Principles of Table Design
- Topic 1A: Normalizing Data
- Topic 1B: Normalizing Data for Fourth and Fifth Normal
Forms
Lesson 2: Principles of Table Relationships
- Topic 2A: Analyzing Table Relationships
- Topic 2B: Establishing and Testing Referential Integrity
Lesson 3: Table Design Techniques
- Topic 3A: Data Validation Techniques
- Topic 3B: Indexing Techniques
Lesson 4: Designing Select Queries
- Topic 4A: Using Calculated Fields in Queries
- Topic 4B: Creating Multiple-table Queries
Lesson 5: Customizing Form Designs
- Topic 5A: Customizing the Form Design
- Topic 5B: Performing Calculations on a Form
- Topic 5C: Adding Combo Boxes to a Form
- Topic 5D: Adding Unbound Controls
Lesson 6: Working with Data Access Pages
- Topic 6A: Creating Data Access Pages
- Topic 6B: Integrating with Other Applications
Lesson 7: Customizing Reports
- Topic 7A: Customizing a Report Created by the Report
Wizard
- Topic 7B: Working with Subreports
- Topic 7C: Creating a Report in Design View
Hardware/Software Requirements
This course was developed using the Windows 98 platform; however,
the manufacturer’s documentation states that Office 2000 can also run on Windows
95, Windows 2000, or Windows NT 4.0 with Service Pack 3 or higher installed,
though some of the screen displays might be slightly different.
- A Pentium 75 PC with 16 MB of RAM. (We recommend a Pentium
133 or faster with 32 MB or more.)
- 600 MB of free hard-disk space. For optimal performance, we
recommend an additional 100 MB of free hard-disk space for user graphics and
temporary image caches.
- Either a local CD-ROM drive or access to a networked CD-ROM
drive for installation purposes.
- A 3.5"-disk drive.
- A two-button mouse, an IntelliMouse, or compatible pointing
device.
- VGA or higher-resolution monitor; Super VGA recommended. (The
EGA display adapter is not supported.)
- An installed printer driver. (Printers are not required; however,
each PC must have an installed printer driver to use Print Preview.)
- An Internet connection with access to the World Wide Web.
The connection is necessary to complete some tasks and Web Tips throughout
the book. (Note: Internet access may require payment of a separate fee to
a service provider.)
- Microsoft Windows 95 (or later) operating system, Microsoft
Windows 2000, Microsoft Windows NT Workstation operating system version 4.0
Service Pack 3 (or later). If you are running Windows NT, make sure that you
have at least 4 MB of free Registry space.
- A custom installation of Microsoft Office 2000 Premium Edition—see
the following section, Class Requirements, for additional instructions.
