Microsoft Office Access 2003

by FRIEDRICHSEN

• ISBN13: 9780619188078
• ISBN10: 0619188073
• Format: Paperback
• Copyright: 2003-12-15
• Publisher: Course Technology

Summary

Part of the Illustrated series, this text offers a visual, flexible way to build Microsoft Access 2003 skills.

Table of Contents

Preface	vi
Getting Started with Access 2003	1	(1)
Understanding Relational Databases	2	(2)
Learning Database Terminology	4	(2)
Starting Access and Opening a Database	6	(2)
Personalized toolbars and menus in Access 2003
Working with the Database Window	8	(2)
Viewing objects
Navigating Records	10	(2)
Changing to Edit mode
Entering Records	12	(2)
Moving datasheet columns
Editing Records	14	(2)
Resizing datasheet columns
Previewing and Printing a Datasheet	16	(2)
Hiding fields
Getting Help and Exiting Access	18	(2)
Compact on Close
Concepts Review	20	(1)
Skills Review	21	(1)
Independent Challenges	22	(2)
Visual Workshop	24
Using Tables and Queries	1	(1)
Organizing Fields	2	(2)
Choosing between the Text and Number data type
Planning Related Tables	4	(2)
Creating a Table	6	(2)
Modifying a Table	8	(2)
Learning about field properties
Formatting a Datasheet	10	(2)
Understanding Sorting, Filtering, and Finding	12	(2)
Using wildcards
Sorting Records and Finding Data	14	(2)
Using more than one sort field
Filtering Records	16	(2)
Searching for blank fields
Creating a Query	18	(2)
Modifying a Query	20	(2)
Understanding And and Or criteria
Concepts Review	22	(1)
Skills Review	23	(2)
Independent Challenges	25	(3)
Visual Workshop	28
Using Forms	1	(1)
Planning a Form	2	(2)
Creating a Form	4	(2)
Using the AutoForm button
Moving and Resizing Controls	6	(2)
Modifying Labels	8	(2)
Using Text Boxes for Calculations	10	(2)
Modifying Tab Order	12	(2)
Entering, Editing, and Printing Records	14	(2)
Inserting an Image	16	(2)
Concepts Review	18	(2)
Skills Review	20	(2)
Independent Challenges	22	(4)
Visual Workshop	26
Using Reports	1	(1)
Planning a Report	2	(2)
Creating a Report	4	(2)
Why reports should be based on queries
Using Group Sections	6	(2)
Changing the Sort Order	8	(2)
Adding a field to a report
Adding a Calculation	10	(2)
Aligning Controls	12	(2)
Precisely moving and resizing controls
Formatting Controls	14	(2)
Changing Page Layout	16	(2)
Concepts Review	18	(2)
Skills Review	20	(2)
Independent Challenges	22	(4)
Visual Workshop	26
Modifying the Database Structure	1	(1)
Examining Relational Databases	2	(2)
Many-to-many relationships
Creating Related Tables	4	(2)
Creating foreign key fields
Creating One-to-Many Relationships	6	(2)
Enforcing referential integrity
Creating Lookup Fields	8	(2)
Modifying Text Fields	10	(2)
Input Mask property
Modifying Number and Currency Fields	12	(2)
Modifying Date/Time Fields	14	(2)
Smart Tags
Modifying Field Validation Properties	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
Creating Multiple Table Queries	1	(1)
Building Select Queries	2	(2)
Resizing Query Design View
Sorting a Query on Multiple Fields	4	(2)
Specifying a sort order different from the field order in the datasheet
Developing And Criteria	6	(2)
Developing OR Criteria	8	(2)
Using wildcard characters in query criteria
Creating Calculated Fields	10	(2)
Building Summary Queries	12	(2)
Building Crosstab Queries	14	(2)
Query Wizards
Building Pivot Tables and Pivot Charts	16	(2)
Concepts Review	18	(2)
Skills Review	20	(2)
Independent Challenges	22	(4)
Visual Workshop	26
Developing Forms and Subforms	1	(1)
Understanding the Form/Subform Relationship	2	(2)
Creating Subforms Using the Form Wizard	4	(2)
Creating Subforms Using Queries	6	(2)
Linking the form and subform
Modifying Subforms	8	(2)
Error checking options
Adding a Combo Box for Data Entry	10	(2)
Choosing between a combo box and a list box
Adding a Combo Box to Find Records	12	(2)
Adding Option Groups	14	(2)
Protecting data
Adding Command Buttons	16	(2)
Adding ActiveX Controls	18	(2)
Concepts Review	20	(1)
Skills Review	21	(3)
Independent Challenges	24	(4)
Visual Workshop	28
Sharing Information and Improving Reports	1	(1)
Importing Data	2	(2)
Applying Conditional Formatting	4	(2)
Adding Lines	6	(2)
Line troubles
Using the Format Painter and AutoFormats	8	(2)
Creating summary reports
Creating a Dynamic Web Page	10	(2)
Exporting Data	12	(2)
Compacting and Repairing a Database	14	(2)
Object dependencies
Backing Up a Database	16	(2)
Backing up an entire folder to floppy disks
Concepts Review	18	(2)
Skills Review	20	(2)
Independent Challenges	22	(4)
Visual Workshop	26
Glossary	1	(8)
Index	9