Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition

by Friedrichsen, Lisa

• ISBN13: 9781418842994
• ISBN10: 1418842990
• Edition: 1st
• Format: Paperback
• Copyright: 2005-03-31
• Publisher: Course Technology

Summary

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

Table of Contents

Preface	iv
WINDOWS XP
Getting Started with Windows XP	1	(1)
Starting Windows and Viewing the Desktop	2	(2)
Accessing the Internet from the Desktop
Using the Mouse	4	(2)
Starting a Program	6	(2)
Customizing the Start Menu
Moving and Resizing Windows	8	(2)
More about sizing windows
Using Menus, Keyboard Shortcuts, and Toolbars	10	(2)
Using Dialog Boxes	12	(2)
Using Scroll Bars	14	(2)
Using Windows Help and Support Center	16	(2)
Other forms of Help
Closing a Program and Shutting Down Windows	18	(2)
The Log Off command
Concepts Review	20	(1)
Skills Review	21	(2)
Independent Challenges	23	(1)
Visual Workshop	24
WINDOWS XP
Working with Programs, Files, and Folders	1	(1)
Creating and Saving a WordPad Document	2	(2)
Opening, Editing, and Saving an Existing Paint File	4	(2)
Working with Multiple Programs	6	(2)
Other Programs that Come with Windows XP
Understanding File Management	8	(2)
Viewing Files and Creating Folders with My Computer	10	(2)
Moving and Copying Files with My Computer	12	(2)
Managing Files with Windows Explorer	14	(2)
Searching for Files	16	(2)
Accessing files, folders, programs, and drives you use often
Deleting and Restoring Files	18	(2)
Customizing your Recycle Bin
Concepts Review	20	(1)
Skills Review	21	(1)
Independent Challenges	22	(2)
Visual Workshop	24
WINDOWS XP
Formatting a Floppy Disk	1	(1)
Formatting a Floppy Disk	2	(2)
More about disks
Data Files	4
ACCESS 2003
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
ACCESS 2003
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
ACCESS 2003
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
ACCESS 2003
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
ACCESS 2003
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
ACCESS 2003
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 PivotTables and PivotCharts	16	(2)
Concepts Review	18	(2)
Skills Review	20	(2)
Independent Challenges	22	(4)
Visual Workshop	26
ACCESS 2003
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
ACCESS 2003
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
ACCESS 2003
Sharing Access Information with Other Office Programs	1	(1)
Examining Access Objects	2	(2)
Setting Relationships	4	(2)
Importing XML Data	6	(2)
Linking Data	8	(2)
Publishing Data to Word	10	(2)
Analyzing Data with Excel	12	(2)
Merging Data with Word	14	(2)
Exporting Data to XML	16	(2)
Using an Access Project with SQL Server	18	(2)
Concepts Review	20	(2)
Skills Review	22	(2)
Independent Challenges	24	(2)
Visual Workshop	26
ACCESS 2003
Creating Data Access Pages	1	(1)
Understanding the World Wide Web	2	(2)
Creating Hyperlink Fields	4	(2)
Understanding the Universal Naming Convention
Creating Pages for Interactive Reporting	6	(2)
Creating Pages for Data Entry	8	(2)
Creating PivotTables	10	(2)
Creating PivotCharts	12	(2)
Adding Hyperlinks	14	(2)
Creating a hyperlink from an image
Publishing Web Pages to Web Servers	16	(2)
The connection between the Web page and database file
Concepts Review	18	(2)
Skills Review	20	(3)
Independent Challenges	23	(3)
Visual Workshop	26
ACCESS 2003
Creating Advanced Queries	1	(1)
Querying for Top Values	2	(2)
Creating a Parameter Query	4	(2)
Modifying Query Properties	6	(2)
Creating a Make-Table Query	8	(2)
Creating an Append Query	10	(2)
1900 versus 2000 dates
Creating a Delete Query	12	(2)
Reviewing referential integrity
Creating an Update Query	14	(2)
Specifying Join Properties	16	(2)
Null and zero-length string values
Creating Find Unmatched Queries	18	(2)
Find Duplicate Query Wizard
Concepts Review	20	(2)
Skills Review	22	(3)
Independent Challenges	25	(3)
Visual Workshop	28
ACCESS 2003
Creating Advanced Forms and Reports	1	(1)
Adding Check Boxes and Toggle Buttons	2	(2)
Using Conditional Formatting in a Form	4	(2)
Creating Custom Help	6	(2)
Adding Tab Controls	8	(2)
Adding Charts	10	(2)
Modifying Charts	12	(2)
Adding Subreport Controls	14	(2)
Modifying Section Properties	16	(2)
Using Domain Functions	18	(2)
Concepts Review	20	(1)
Skills Review	21	(2)
Independent Challenges	23	(3)
Visual Workshop	26
ACCESS 2003
Managing Database Objects	1	(1)
Working with Objects	2	(2)
Updating names with Name AutoCorrect
Using the Documenter	4	(2)
Viewing object dependencies
Grouping Objects	6	(2)
Modifying Shortcuts and Groups	8	(2)
Speech recognition--interface of the future?
Creating a Dialog Box	10	(2)
Creating a Pop-up Form	12	(2)
Creating a Switchboard	14	(2)
Modifying a Switchboard	16	(2)
The Northwind database
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
ACCESS 2003
Creating Macros	1	(1)
Understanding Macros	2	(2)
Creating a Macro	4	(2)
Modifying Actions and Arguments	6	(2)
Creating a Macro Group	8	(2)
Assigning a macro to a key combination
Setting Conditional Expressions	10	(2)
Working with Events	12	(2)
Assigning a macro to a command button
Customizing Toolbars	14	(2)
Troubleshooting Macros	16	(2)
Converting a macro to VBA
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
ACCESS 2003
Creating Modules and VBA	1	(1)
Understanding Modules and VBA	2	(2)
Comparing Macros and Modules	4	(2)
Creating Functions	6	(2)
Using If Statements	8	(2)
Documenting Procedures	10	(2)
Creating Class Modules	12	(2)
Creating Sub Procedures	14	(2)
Troubleshooting Modules	16	(2)
Using Visual Basic screen prompts
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
ACCESS 2003
Managing the Database	1	(1)
Converting Databases	2	(2)
Converting from Access 2000 to Access 2002-2003
Setting Passwords	4	(2)
Creating workgroups
Changing Startup Options	6	(2)
Encoding a Database	8	(2)
Creating an MDE file
Analyzing Performance	10	(2)
Splitting a Database	12	(2)
Client/Server computing
Replicating a Database	14	(2)
Using a Briefcase folder
Synchronizing a Database	16	(2)
Using the Briefcase with a laptop computer
Concepts Review	18	(1)
Skills Review	19	(1)
Independent Challenges	20	(2)
Visual Workshop	22
Glossary	1	(12)
Index	13