How to Do Everything with Access 2003 (How to Do Everything Series) / Edition 2
  • Alternative view 1 of How to Do Everything with Access 2003 (How to Do Everything Series) / Edition 2
  • Alternative view 2 of How to Do Everything with Access 2003 (How to Do Everything Series) / Edition 2

How to Do Everything with Access 2003 (How to Do Everything Series) / Edition 2

4.0 2
by Virginia Andersen
     
 

ISBN-10: 0072229381

ISBN-13: 9780072229387

Pub. Date: 08/08/2003

Publisher: McGraw-Hill Professional Publishing

Here is the ideal resource for anyone who wants to get the most out of all the new and enhanced features Access has to offer. Learn the best methods for creating and customizing a new database, retrieving, processing, presenting, and exchanging data, securing your Access environment--and much more.

Overview

Here is the ideal resource for anyone who wants to get the most out of all the new and enhanced features Access has to offer. Learn the best methods for creating and customizing a new database, retrieving, processing, presenting, and exchanging data, securing your Access environment--and much more.

Product Details

ISBN-13:
9780072229387
Publisher:
McGraw-Hill Professional Publishing
Publication date:
08/08/2003
Series:
How To Do Everything Series
Edition description:
Second Edition
Pages:
556
Product dimensions:
7.50(w) x 9.10(h) x 1.10(d)

Table of Contents

Acknowledgmentsxix
Introductionxxi
Part IGet Started
Chapter 1Get Acquainted with Access 20033
Start Access and Open a Database4
Open a Table14
Get Help When You Need It18
Chapter 2Create a Database25
Design an Efficient Database26
Create a Database with the Database Wizard33
Run the New Application38
Start with a Blank Database39
Chapter 3Create and Modify Tables41
Create a Table with the Table Wizard42
Create a Table from Scratch in Design View47
Modify the Table Design62
Ensure Data Validity65
Copy an Existing Table Structure70
Chapter 4Relate Tables73
Define a Relationship74
View and Edit Relationships85
Print the Relationships86
Chapter 5Enter and Edit Data89
Enter New Data90
Customize Data Entry99
Change the Datasheet Appearance106
Change Table Definition in Datasheet View112
Edit Record Data113
Part IIRetrieve and Present Information
Chapter 6Sort, Filter, and Print Records123
Sort Records124
Filter Records125
Preview and Print Sorted or Filtered Table Data136
Chapter 7Extract Information with Queries139
Create a Select Query141
Add Selection Criteria153
Set Query Properties158
Modify a Query159
Perform Calculations in a Query161
Create Special Queries with the Query Wizard166
Chapter 8Create Advanced Queries173
Create Special Purpose Queries174
Look at Structured Query Language (SQL)185
Create a Subquery187
Chapter 9Understand Form and Report Design Basics189
Use AutoForm and AutoReport Features190
Common Form and Report Design Elements191
Work in the Design Window193
Modify Controls202
Modify Form or Report Properties213
Chapter 10Create Custom Forms and Subforms217
Create a New Form Design218
Modify the Form Design222
Use the Form for Data Entry237
Create a Multiple-Page Form241
Add Special Controls245
Create a Hierarchical Form246
Add Custom User Guidance252
Add Data Validation252
Chapter 11Create and Customize Reports and Subreports255
Start a New Report256
Preview and Print the Report262
Modify the Report Design266
Save the Report Design270
Sort and Group Records in a Report270
Add a Subreport281
Design a Multiple-Column Report289
Print Mailing Labels290
Chapter 12Create Charts and Graphs295
Choose a Chart Type296
Create a New Chart with the Chart Wizard296
Add an Existing Chart to a Form or Report303
Modify the Chart304
Part IIIImprove the Access 2003 Workplace
Chapter 13Customize the Workplace319
Personalize the Workplace320
Create Custom Groups333
Change the Way Access Starts334
Modify the Office Assistant337
Chapter 14Speed Up Your Database341
Optimize a Database342
Back Up and Restore a Database352
Compact and Repair a Database353
Chapter 15Automate with Macros357
Create a Simple Macro358
Test and Debug a Macro361
Assign a Macro to an Event Property363
Add Conditions to a Macro365
Create Other Commonly Used Macros368
Create a Macro Group373
Chapter 16Customize Menus and Toolbars377
Use Access Command Bars378
Customize Command Bars383
Modify Command Bars393
Chapter 17Create Custom Switchboards and Dialog Boxes399
Create Switchboards400
Create a Custom Dialog Box412
Create a Dialog Box for User Input419
Part IVExchange Data with Others
Chapter 18Exchange Database Objects and Text425
Copy Objects among Access Databases426
Import or Link Access Data428
Import from or Link to Other Data Sources432
Work with Linked or Imported Tables434
Import and Link Text Files436
Export to an Existing Access Database442
Export to Another Database Format444
Export to Text Files444
Chapter 19Exchange Data with Outside Sources447
Copy or Move Records448
Save Access Output as an External File451
Work with Word452
Work with Excel457
Chapter 20Share with Multiple Users465
Share a Database on a Network466
Replicate a Database471
Manage the Database in a Multiuser Environment472
Chapter 21Secure a Database477
Secure a Database with a Password478
Secure a Multiple-User Database479
Other Security Measures498
AppendixConvert to Access 2003501
Decide on a Conversion Strategy502
Convert a Database502
Convert a Workgroup Information File504
Convert a Secured Database504
Convert a Replicated Database504
Enable a Database505
Share a Database Across Several Access Versions506
Convert from Access 2002-2003 to Access 97507
Convert from Access 2002-2003 to Access 2000507
Index509

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

How to Do Everything with Access 2003 (How to Do Everything Series) 4 out of 5 based on 0 ratings. 2 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago