How To Do Everything With Access 2002

Be the first to write a review

Overview

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...
See more details below
Paperback (Older Edition)
$22.23
BN.com price
(Save 17%)$26.95 List Price
Other sellers (Paperback)
  • All (28) from $1.99   
  • New (8) from $8.51   
  • Used (20) from $1.99   
Sending request ...

More About This Book

Overview

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.
Read More Show Less

Product Details

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

Table of Contents

Acknowledgments xix
Introduction xxi
Part I Get Started
Chapter 1 Getting Acquainted with Access 2002 3
Starting Access and Opening a Database 4
Open a Table 14
Get Help When You Need It 20
Get Help with What You're Doing 29
Chapter 2 Creating a Database 31
Design an Efficient Database 32
Create a Database with the Database Wizard 39
Run the New Application 45
Start with a Blank Database 48
Chapter 3 Creating and Modifying Tables 51
Create a Table with the Table Wizard 52
Create a Table from Scratch in Design View 56
Modify the Table Design 73
Ensure Data Validity 78
Copying an Existing Table Structure 85
Chapter 4 Relating Tables 87
Defining a Relationship 88
Viewing and Editing Relationships 98
Printing the Relationships 100
Chapter 5 Entering and Editing Data 103
Enter New Data 104
Customizing Data Entry 114
Changing the Datasheet Appearance 122
Changing Table Definition in Datasheet View 128
Editing Record Data 130
Part II Retrieve and Present Information
Chapter 6 Sorting, Filtering, and Printing Records 139
Sorting Records 140
Filtering Records 141
Preview and Print Sorted or Filtered Table Data 156
Chapter 7 Extracting Information with Queries 159
Creating a Select Query 161
Adding Selection Criteria 174
Setting Query Properties 179
Modifying a Query 180
Performing Calculations in a Query 182
Creating Special Queries with the Query Wizard 187
Chapter 8 Creating Advanced Queries 195
Creating Special Purpose Queries 196
Designing Action Queries 201
Introducing Structured Query Language (SQL) 208
Creating SQL-Specific Queries 210
Creating a Subquery 213
Chapter 9 Understanding Form and Report Design Basics 217
Using AutoForm and AutoReport Features 218
Common Form and Report Design Elements 219
Working in the Design Window 221
Modifying Controls 231
Adding Other Objects and Special Effects 242
Modifying Form or Report Properties 248
Chapter 10 Creating Custom Forms and Subforms 253
Creating a New Form Design 254
Modifying the Form Design 258
Using the Form for Data Entry 274
Creating a Multiple-Page Form 277
Adding Special Controls 281
Creating a Hierarchical Form 282
Adding Custom User Guidance 289
Adding Data Validation 290
Chapter 11 Creating and Customizing Reports and Subreports 293
Starting a New Report 294
Preview and Print the Report 299
Modifying the Report Design 305
Saving the Report Design 310
Sorting and Grouping Records in a Report 311
Adding a Subreport 323
Designing a Multiple-Column Report 330
Printing Mailing Labels and Envelopes 332
Chapter 12 Creating Charts, PivotTables, and PivotCharts 337
Choosing a Chart Type 338
Creating a New Chart with the Chart Wizard 339
Creating a New Chart Without the Chart Wizard 345
Adding an Existing Chart to a Form or Report 348
Modifying the Chart 349
Creating a PivotTable or PivotChart 361
Part III Improve the Access 2002 Workplace
Chapter 13 Customizing the Workplace 373
Personalizing the Workplace 374
Creating Custom Groups 387
Changing the Way Access Starts 388
Modifying the Office Assistant 393
Chapter 14 Using Access to Improve Performance 397
Optimizing a Database 398
Backing Up and Restoring a Database 410
Compacting and Repairing a Database 411
Chapter 15 Automating with Macros 417
Creating a Simple Macro 418
Testing and Debugging a Macro 422
Assigning a Macro to an Event Property 424
Adding Conditions to a Macro 426
Creating Other Commonly Used Macros 429
Creating a Macro Group 435
Chapter 16 Customizing Menus and Toolbars 441
Using Access Command Bars 442
Customizing Command Bars 448
Modifying Command Bars 460
Chapter 17 Creating Custom Switchboards and Dialog Boxes 467
Creating Switchboards 468
Creating a Custom Dialog Box 480
Creating a Dialog Box for User Input 488
Part IV Exchange Data with Others
Chapter 18 Exchanging Database Objects and Text 493
Copying Objects Among Access Databases 494
Importing or Linking Access Data 496
Importing from or Linking to Other Databases 502
Working with Linked or Imported Tables 504
Importing and Linking Text Files 506
Exporting to an Existing Access Database 512
Exporting to Another Database Format 514
Exporting to Text Files 514
Chapter 19 Exchanging Data with Outside Sources 517
Copying or Moving Records 518
Saving Access Output as an External File 522
Working with Word 523
Working with Excel 528
Chapter 20 Creating Data Access Pages 537
Understanding Data Access Pages 538
Creating a Data Access Page 538
Modifying a Data Access Page 547
Organizing Data in a Data Access Page 556
Editing and Protecting Data in Data Access Pages 561
Customizing a Record Navigation Bar 564
Adding a Spreadsheet, Chart, PivotTable or PivotChart 565
Publishing and Printing Data Access Pages 573
Part V Application Development
Chapter 21 Sharing with Multiple Users 577
Replicating a Database 578
Modifying a Replica Set 594
Sharing a Database on a Network 597
Managing the Database in a Multiuser Environment 600
Chapter 22 Securing a Database 605
Securing a Database with a Password 606
Securing a Multiple-User Database 608
Other Security Measures 626
Appendix A Converting to Access 2002 629
Deciding on a Conversion Strategy 630
Converting a Database 630
Converting a Workgroup Information File 632
Converting Database Objects 633
Converting a Secured Database 634
Converting a Replicated Database 634
Protecting Visual Basic Code 635
Enabling a Database 636
Sharing a Database Across Several Access Versions 636
Converting from Access 2002 to Access 97 637
Converting From Access 2002 to Access 2000 638
Index 639
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)