Microsoft Access 2000 Intermediate:
Tables and Forms
 

It is intended for participants who have a basic understanding of Windows 98 and have taken the Access 2000 Fundamentals course. This is the second in the PBTSystem series of books covering Microsoft Access 2000. This full-day performance-based training course covers the basics of developing Access databases, focusing on designing and creating effective tables and forms.

Course Prerequisites
Windows 98 Fundamentals
Access 2000 Fundamentals

Operating System
Windows 98

Course Length
1 day

Performance Objectives

•  Plan, design, and create database tables.
•  Assign primary keys and define data entry rules to ensure data quality.
•  Import and link data within database tables and define types of table relationships to increase data flexibility.
•  Use Cascade Update and Cascade Delete options and create lookup controls to manage data.
•  Create and modify user-friendly forms using a variety of techniques.
•  Add new objects to forms and control the appearance and behavior of forms.
•  Enhance the look and feel of your forms and combine multiple data sources to broaden content depth.
•  Insert controls and command buttons to widen the range of usable data and increase ease of use.

Module 1: Designing and Creating Tables
Building Your Skills
Designing Tables
Table Elements
Normalization
Creating Tables
Creating Tables Using a Wizard
Creating Tables in Design View
Assigning a Primary Key
Defining Data Entry Rules
Setting Display Rules
Establishing Data Entry Rules

Module 2: Creating and Using Relationships
Building Your Skills
Importing and Linking Data
Importing Data
Linking to Another Database
Defining Table Relationships
One-to-many relationship
One-to-one relationship
Many-to-many relationship
Many-to-one relationship
Subdatasheets
Using Cascade Update and Cascade Delete Options
Creating Lookup Controls
Using Tables to Establish Lookups
Using Queries to Establish Lookups
 

 Microsoft Access 2000 Intermediate:
Tables and Forms
 

Course Content

Module 3: Creating and Enhancing Forms
Building Your Skills
Creating a Form
Creating a Form Using AutoFormat
Creating a Form Using a Wizard
Modifying a Form
Selecting Form Elements
Moving and Modifying Controls
Creating Form Headers and Form Footers
Building a Custom Form
Enhancing a Form
Creating a Hyperlink
Exploring Form Properties
Change Form Properties
Using AutoFormat

 Module 4: Creating and Automating Forms
Building Your Skills
Enhancing Form Design
Creating Combo Boxes
Creating Check Boxes
Creating Option Groups
Combining Multiple Data Sources in a Single Form
Merging Two Tables into a Form
Adding a Subform to a Form
Inserting Tab Controls
Designing Command Buttons