Microsoft® Access Version 2002 Step by Step

Author Online Training Solutions, Inc. Pages 352 Disk 1 Companion CD(s) Level Beg/Int Published 06/06/2001 ISBN 9780735612990 Price $29.99 To see this book's discounted price, select a reseller below.	More Information About the Book Table of Contents Sample Chapter Index Related Series Related Books About the Author Support: Book & CD Rate this book

Table of Contents

What’s New in Microsoft Access 2002	vii
Getting Help	ix
Using the Book’s CD-ROM	xi
Conventions and Features	xvii
MOUS Objectives	xix
Taking a MOUS Exam	xxiii
1 Getting to Know Microsoft Access 2002	1
What Is a Database?	2
What’s Special About Access?	2
Opening an Existing Database	4
Exploring Tables	6
Exploring Queries	11
Exploring Forms	15
Exploring Reports	19
Exploring Other Access Objects	22
2 Creating a New Database	24
Creating a Database Structure the Simple Way	26
Checking the Work of a Wizard	30
Creating Tables the Simple Way	34
Refining How Data Is Displayed	37
Manipulating Table Columns and Rows	44
3 Getting Information Into and Out of a Database	48
Importing Information from Excel	50
Importing Information from a Delimited Text File	52
Importing Information from a Fixed-Width Text File	54
Importing Information from an Access Database	57
Importing Information from Other Databases	59
Importing Information from an HTML File	60
Importing XML Data	63
Exporting Information to Other Applications	64
Linking a Database to Information in Another Database	67
Other Ways to Share Access Data	69
4 Simplifying Data Entry with Forms	72
Creating a Form Using a Wizard	74
Refining Form Properties	76
Refining Form Layout	82
Adding Controls to a Form	85
Using VBA to Enter Data in a Form	90
Creating a Form Using an AutoForm	94
Adding a Subform to a Form	96
5 Locating Specific Information	106
Sorting Information	108
Filtering Information in a Table	110
Filtering By Form	113
Locating Information That Matches Multiple Criteria	115
Creating a Query in Design View	118
Creating a Query with a Wizard	126
Performing Calculations in a Query	128
6 Keeping Your Information Accurate	132
Using the Data Type to Restrict Data	134
Using the Field Size Property to Restrict Data	138
Using an Input Mask to Restrict Data	140
Using Validation Rules to Restrict Data	145
Using a Lookup List to Restrict Data	148
Updating Information in a Table	154
Deleting Information from a Table	157
7 Working with Reports	160
Creating a Report Using a Wizard	162
Modifying a Report	166
Creating a Report from Scratch	171
Adding a Subreport to a Report	176
Previewing and Printing a Report	182
8 Making It Easy for Others to Use Your Database	186
Creating a Switchboard with Switchboard Manager	188
Creating a Splash Screen	193
Setting Startup Options	198
Keeping Your Application Healthy	204
9 Keeping Your Information Secure	210
Hiding Database Content from Prying Eyes	212
Controlling Who Can Open Your Database	214
Sharing a Database	216
Replicating a Database	218
Splitting a Database	223
Setting Up a Workgroup	225
Maintaining a Workgroup	232
Preventing Changes to VBA Code	237
Securing a Database That Will Be Publicly Distributed	239
10 Working with Pages and Modules	242
Creating Static Web Pages	245
Exploring Visual Basic for Applications	247
Using VBA to Create a Web Page	252
Creating a Data Access Page with AutoPage	261
Creating a Data Access Page with the Page Wizard	269
Allowing Others to Analyze Data via the Web	273
QUICK REFERENCE	279
Chapter 1:Getting to Know Microsoft Access 2002	279
Chapter 2:Creating a New Database	279
Chapter 3:Getting Information Into and Out of a Database	280
Chapter 4:Simplying Data Entry with Forms	282
Chapter 5:Locating Specific Information	284
Chapter 6:Keeping Your Information Accurate	287
Chapter 7:Working with Reports	289
Chapter 8:Making It Easy for Others to Use Your Database	292
Chapter 9:Keeping Your Information Secure	293
Chapter 10:Working with Pages and Modules	296
GLOSSARY	299
INDEX	309

Top of Page

Last Updated: Saturday, July 7, 2001