General Information
- Course Duration
4 hours
Audience
Anyone wishing to become familiar with
Microsoft Access 2000; students wishing to become
MOUS certified at Microsoft Access 2000 at the
Core level
- Prerequisites
Basic familiarity with the Windows 95/98 or
NT 4.0/2000 user environments and completion of Microsoft
Office 2000: Beginning Access and Microsoft
Office 2000: Intermediate Access
|
Topics
Covered
- Defining relationships
- Hands-on: Establishing relationships
- Data validation
- Hands-on: Validating data
- Optimizing data types
- Creating and modifying a form
- Hands-on: Creating a form
- Customizing a form
- Hands-on: Customizing form sections
- Subforms
- Hands-on: Using the subform control
- Switchboards
- Startup options and passwords
- Hands-on: Setting and modifying a password
- Analysis
- Replication and encryption
- Macros
- Hands-on: Creating macros
- Data access pages
- Hands-on: Creating a data access page
- Hyperlinks
- Hands-on: Creating a hyperlink
|
Course Aim
To provide an introduction to the core concepts of
Microsoft Access 2000 and the skill areas of modifying
and enhancing a table, a form, working with Access tools,
and integrating Access with the Web
|
Learning Objectives
After taking this course, the student should be able
to
- define and validate data
- optimize data types
- create, modify, and customize a form
- use subforms and switchboards
- use Access tools
- create and use macros
- create data access pages
- create hyperlinks
|
