Microsoft Access 2000: Office User Specialist Certification Guide

by Reid, Maria

• ISBN13: 9781585771196
• ISBN10: 1585771198
• Format: Paperback
• Copyright: 2000-11-01
• Publisher: D D C Pub

Table of Contents

SPECIALIST OBJECTIVES
Plant & Design A Database
Determine Appropriate Data Inputs for Your Database	1	(4)
Determine Appropriate Data Outputs for Your Database	5	(3)
Create Table Structure	8	(3)
Establish Table Relationships	11	(2)
Work With Access
Use the Office Assistant	13	(3)
Select an Object Using the Objects Bar	16	(1)
Print Databse Objects (Tables, Forms, Reports, Queries)	17	(2)
Navigate Through Records in a Table, Query, or Form	19	(2)
Create a Database (Wizard or Design View)	21	(6)
Build & Modify Tables
Create Tables by Using the Table Wizard	27	(4)
Set Primary Keys	31	(2)
Modify Field Properties	33	(18)
Use Multiple Data Types	51	(1)
Modify Tables Using Design View	52	(2)
Use the Lookup Wizard	54	(2)
Use the Input Mask Wizard	56	(3)
Build & Modify Forms
Create Form with Form Wizard	59	(2)
Use the Control Toolbox to Add Controls	61	(2)
Modify Format Properties of Controls	63	(1)
Use Form Sections	64	(3)
Use a Calculated Control on a Form	67	(3)
View and Organize Info
Use the Office Clipboard	70	(1)
Switch Between Object Views	71	(1)
Enter Records Using a Datasheet	72	(1)
Enter Records Using a Form	73	(1)
Delete Records From a Table	74	(1)
Find a Record	74	(3)
Sort Records	77	(1)
Apply and Remove Filters	77	(3)
Specify Criteria in a Query	80	(2)
Display Related Records in a Subdatasheet	82	(2)
Create a Calculated Field	84	(2)
Create and Modify a Multi-table Select Query	86	(1)
Define Relationships
Establish Relationships	87	(3)
Enforce Referential Integrity	90	(1)
Produce Reports
Create a Report with Report Wizard	91	(3)
Preview and Print a Report	94	(1)
Move and Resize a Control	95	(5)
Modify Format Properties	100	(1)
Use the Control Toolbox	101	(1)
Use Report Sections	102	(1)
Use a Calculated Control in a Report	103	(1)
Integrate With Other Applications
Import Data to a New Table	104	(3)
Save Table, Query or Form as a Web Page	107	(2)
Add Hyperlinks	109	(6)
Use Access Tools
Print Relationships	115	(2)
Backup and Restore a Database	117	(1)
Repair and Compact a Database	118