How to Do Everything with Access 2003 (How to Do Everything Series)

by Virginia Andersen, Megg Bonar (Editor)

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.




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 LLC
Publication date:	08/08/2003
Series:	How to Do Everything Series
Edition description:	Second Edition
Pages:	556
Product dimensions:	7.30(w) x 9.10(h) x 1.14(d)

About the Author

Virginia Andersen (Coronado, CA) is a freelance author and writer who has written or contributed to nearly 25 books about PC-based applications, including many student tutorials and accompanying instructor manuals with exercise disks. Virginia is certified as a Microsoft Access MOUS Expert. She has over 25 years experience in computer science applications, analysis, and engineering - including extensive technical writing and editing. Her government and defense projects include lunar mapping, reliability engineering, undersea surveillance, weapon system interface simulation, and naval communications. Her civilian projects include computerized project management and horse race handicapping. She holds a M.S. in Systems Management, University of Southern California, an M.S. in Computer Science, University of Southern California and a B.S. Mathematics, Stanford University.

Table of Contents

	Acknowledgments	xix
	Introduction	xxi
Part I	Get Started
Chapter 1	Get Acquainted with Access 2003	3
	Start Access and Open a Database	4
	Open a Table	14
	Get Help When You Need It	18
Chapter 2	Create a Database	25
	Design an Efficient Database	26
	Create a Database with the Database Wizard	33
	Run the New Application	38
	Start with a Blank Database	39
Chapter 3	Create and Modify Tables	41
	Create a Table with the Table Wizard	42
	Create a Table from Scratch in Design View	47
	Modify the Table Design	62
	Ensure Data Validity	65
	Copy an Existing Table Structure	70
Chapter 4	Relate Tables	73
	Define a Relationship	74
	View and Edit Relationships	85
	Print the Relationships	86
Chapter 5	Enter and Edit Data	89
	Enter New Data	90
	Customize Data Entry	99
	Change the Datasheet Appearance	106
	Change Table Definition in Datasheet View	112
	Edit Record Data	113
Part II	Retrieve and Present Information
Chapter 6	Sort, Filter, and Print Records	123
	Sort Records	124
	Filter Records	125
	Preview and Print Sorted or Filtered Table Data	136
Chapter 7	Extract Information with Queries	139
	Create a Select Query	141
	Add Selection Criteria	153
	Set Query Properties	158
	Modify a Query	159
	Perform Calculations in a Query	161
	Create Special Queries with the Query Wizard	166
Chapter 8	Create Advanced Queries	173
	Create Special Purpose Queries	174
	Look at Structured Query Language (SQL)	185
	Create a Subquery	187
Chapter 9	Understand Form and Report Design Basics	189
	Use AutoForm and AutoReport Features	190
	Common Form and Report Design Elements	191
	Work in the Design Window	193
	Modify Controls	202
	Modify Form or Report Properties	213
Chapter 10	Create Custom Forms and Subforms	217
	Create a New Form Design	218
	Modify the Form Design	222
	Use the Form for Data Entry	237
	Create a Multiple-Page Form	241
	Add Special Controls	245
	Create a Hierarchical Form	246
	Add Custom User Guidance	252
	Add Data Validation	252
Chapter 11	Create and Customize Reports and Subreports	255
	Start a New Report	256
	Preview and Print the Report	262
	Modify the Report Design	266
	Save the Report Design	270
	Sort and Group Records in a Report	270
	Add a Subreport	281
	Design a Multiple-Column Report	289
	Print Mailing Labels	290
Chapter 12	Create Charts and Graphs	295
	Choose a Chart Type	296
	Create a New Chart with the Chart Wizard	296
	Add an Existing Chart to a Form or Report	303
	Modify the Chart	304
Part III	Improve the Access 2003 Workplace
Chapter 13	Customize the Workplace	319
	Personalize the Workplace	320
	Create Custom Groups	333
	Change the Way Access Starts	334
	Modify the Office Assistant	337
Chapter 14	Speed Up Your Database	341
	Optimize a Database	342
	Back Up and Restore a Database	352
	Compact and Repair a Database	353
Chapter 15	Automate with Macros	357
	Create a Simple Macro	358
	Test and Debug a Macro	361
	Assign a Macro to an Event Property	363
	Add Conditions to a Macro	365
	Create Other Commonly Used Macros	368
	Create a Macro Group	373
Chapter 16	Customize Menus and Toolbars	377
	Use Access Command Bars	378
	Customize Command Bars	383
	Modify Command Bars	393
Chapter 17	Create Custom Switchboards and Dialog Boxes	399
	Create Switchboards	400
	Create a Custom Dialog Box	412
	Create a Dialog Box for User Input	419
Part IV	Exchange Data with Others
Chapter 18	Exchange Database Objects and Text	425
	Copy Objects among Access Databases	426
	Import or Link Access Data	428
	Import from or Link to Other Data Sources	432
	Work with Linked or Imported Tables	434
	Import and Link Text Files	436
	Export to an Existing Access Database	442
	Export to Another Database Format	444
	Export to Text Files	444
Chapter 19	Exchange Data with Outside Sources	447
	Copy or Move Records	448
	Save Access Output as an External File	451
	Work with Word	452
	Work with Excel	457
Chapter 20	Share with Multiple Users	465
	Share a Database on a Network	466
	Replicate a Database	471
	Manage the Database in a Multiuser Environment	472
Chapter 21	Secure a Database	477
	Secure a Database with a Password	478
	Secure a Multiple-User Database	479
	Other Security Measures	498
Appendix	Convert to Access 2003	501
	Decide on a Conversion Strategy	502
	Convert a Database	502
	Convert a Workgroup Information File	504
	Convert a Secured Database	504
	Convert a Replicated Database	504
	Enable a Database	505
	Share a Database Across Several Access Versions	506
	Convert from Access 2002-2003 to Access 97	507
	Convert from Access 2002-2003 to Access 2000	507
	Index	509