How To Do Everything With Access 2002

How To Do Everything With Access 2002

Paperback(Older Edition)

$25.94 $30.00 Save 14% Current price is $25.94, Original price is $30. You Save 14%.
Eligible for FREE SHIPPING
  • Get it by Thursday, March 22 ,  Order by 12:00 PM Eastern and choose Expedited Delivery during checkout.


How To Do Everything With Access 2002 by Virginia Andersen, Andersen

Another release in our successful How to Do Everything series, this friendly, solutions-oriented book is filled with step-by-step examples for using Access 2002 as an information manager. Each chapter begins with the specific how-to topics that will be covered, and within the chapter, each topic is accompanied by a solid, easy-to-follow walkthrough of the process. The book covers designing tables for storing information, entering and editing data, retrieving specific information, and presenting the information in customized forms, reports, and dynamic data access pages. You'll also learn how to quickly customize Access with special-purpose menus and toolbars.

Product Details

ISBN-13: 9780072132755
Publisher: McGraw-Hill Companies, The
Publication date: 04/27/2001
Series: How to Do Everything Series
Edition description: Older Edition
Pages: 692
Product dimensions: 7.50(w) x 9.25(h) x 1.39(d)

Table of Contents

Part IGet Started
Chapter 1Getting Acquainted with Access 20023
Starting Access and Opening a Database4
Open a Table14
Get Help When You Need It20
Get Help with What You're Doing29
Chapter 2Creating a Database31
Design an Efficient Database32
Create a Database with the Database Wizard39
Run the New Application45
Start with a Blank Database48
Chapter 3Creating and Modifying Tables51
Create a Table with the Table Wizard52
Create a Table from Scratch in Design View56
Modify the Table Design73
Ensure Data Validity78
Copying an Existing Table Structure85
Chapter 4Relating Tables87
Defining a Relationship88
Viewing and Editing Relationships98
Printing the Relationships100
Chapter 5Entering and Editing Data103
Enter New Data104
Customizing Data Entry114
Changing the Datasheet Appearance122
Changing Table Definition in Datasheet View128
Editing Record Data130
Part IIRetrieve and Present Information
Chapter 6Sorting, Filtering, and Printing Records139
Sorting Records140
Filtering Records141
Preview and Print Sorted or Filtered Table Data156
Chapter 7Extracting Information with Queries159
Creating a Select Query161
Adding Selection Criteria174
Setting Query Properties179
Modifying a Query180
Performing Calculations in a Query182
Creating Special Queries with the Query Wizard187
Chapter 8Creating Advanced Queries195
Creating Special Purpose Queries196
Designing Action Queries201
Introducing Structured Query Language (SQL)208
Creating SQL-Specific Queries210
Creating a Subquery213
Chapter 9Understanding Form and Report Design Basics217
Using AutoForm and AutoReport Features218
Common Form and Report Design Elements219
Working in the Design Window221
Modifying Controls231
Adding Other Objects and Special Effects242
Modifying Form or Report Properties248
Chapter 10Creating Custom Forms and Subforms253
Creating a New Form Design254
Modifying the Form Design258
Using the Form for Data Entry274
Creating a Multiple-Page Form277
Adding Special Controls281
Creating a Hierarchical Form282
Adding Custom User Guidance289
Adding Data Validation290
Chapter 11Creating and Customizing Reports and Subreports293
Starting a New Report294
Preview and Print the Report299
Modifying the Report Design305
Saving the Report Design310
Sorting and Grouping Records in a Report311
Adding a Subreport323
Designing a Multiple-Column Report330
Printing Mailing Labels and Envelopes332
Chapter 12Creating Charts, PivotTables, and PivotCharts337
Choosing a Chart Type338
Creating a New Chart with the Chart Wizard339
Creating a New Chart Without the Chart Wizard345
Adding an Existing Chart to a Form or Report348
Modifying the Chart349
Creating a PivotTable or PivotChart361
Part IIIImprove the Access 2002 Workplace
Chapter 13Customizing the Workplace373
Personalizing the Workplace374
Creating Custom Groups387
Changing the Way Access Starts388
Modifying the Office Assistant393
Chapter 14Using Access to Improve Performance397
Optimizing a Database398
Backing Up and Restoring a Database410
Compacting and Repairing a Database411
Chapter 15Automating with Macros417
Creating a Simple Macro418
Testing and Debugging a Macro422
Assigning a Macro to an Event Property424
Adding Conditions to a Macro426
Creating Other Commonly Used Macros429
Creating a Macro Group435
Chapter 16Customizing Menus and Toolbars441
Using Access Command Bars442
Customizing Command Bars448
Modifying Command Bars460
Chapter 17Creating Custom Switchboards and Dialog Boxes467
Creating Switchboards468
Creating a Custom Dialog Box480
Creating a Dialog Box for User Input488
Part IVExchange Data with Others
Chapter 18Exchanging Database Objects and Text493
Copying Objects Among Access Databases494
Importing or Linking Access Data496
Importing from or Linking to Other Databases502
Working with Linked or Imported Tables504
Importing and Linking Text Files506
Exporting to an Existing Access Database512
Exporting to Another Database Format514
Exporting to Text Files514
Chapter 19Exchanging Data with Outside Sources517
Copying or Moving Records518
Saving Access Output as an External File522
Working with Word523
Working with Excel528
Chapter 20Creating Data Access Pages537
Understanding Data Access Pages538
Creating a Data Access Page538
Modifying a Data Access Page547
Organizing Data in a Data Access Page556
Editing and Protecting Data in Data Access Pages561
Customizing a Record Navigation Bar564
Adding a Spreadsheet, Chart, PivotTable or PivotChart565
Publishing and Printing Data Access Pages573
Part VApplication Development
Chapter 21Sharing with Multiple Users577
Replicating a Database578
Modifying a Replica Set594
Sharing a Database on a Network597
Managing the Database in a Multiuser Environment600
Chapter 22Securing a Database605
Securing a Database with a Password606
Securing a Multiple-User Database608
Other Security Measures626
Appendix AConverting to Access 2002629
Deciding on a Conversion Strategy630
Converting a Database630
Converting a Workgroup Information File632
Converting Database Objects633
Converting a Secured Database634
Converting a Replicated Database634
Protecting Visual Basic Code635
Enabling a Database636
Sharing a Database Across Several Access Versions636
Converting from Access 2002 to Access 97637
Converting From Access 2002 to Access 2000638

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews