Synopses & Reviews
Get results from the best-selling database management system with help from this expertly written guide. Learn to build databases for all your information management needs, from a simple address list to a complex inventory management system. Highly regarded database author Virginia Andersen shows you in step-by-step detail how to set up Access for storing, retrieving, and interpreting your data. Enter and edit data. Design tables for storing information. Retrieve specific information and present it in customized forms, reports, and dynamic data access pages. Let this friendly, solutions-oriented resource help you understand and employ all the data organizing tools available in Access 2003.
- Master this powerful information management tool
- Create more efficient relational databases
- Retrieve, exchange, and process all types of information
- Customize data entry for efficient data transfer and editing
- Integrate Access with other applications
- Sort and filter data--plus create custom forms, reports, and charts
- Use queries to extract only the information you want
- Administer multiple-user databases securely
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.
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
Part I: Get Started.
Chapter 1: Getting Acquainted with Access 2002.
Chapter 2: Creating a Database.
Chapter 3: Creating and Modifying Tables.
Chapter 4: Relating Tables.
Chapter 5: Entering and Editing Data.
Part II: Retrieve and Present Information.
Chapter 6: Sorting, Filtering, and Printing Records.
Chapter 7: Extracting Information with Queries.
Chapter 8: Creating Advanced Queries.
Chapter 9: Understanding Form and Report Design Basics.
Chapter 10: Creating Custom Forms and Subforms.
Chapter 11: Creating and Customizing Reports and Subreports.
Chapter 12: Creating Charts, PivotTables, and PivotCharts.
Part III: Improve the Access 2002 Workplace.
Chapter 13: Customizing the Workplace.
Chapter 14: Using Access to Improve Performance.
Chapter 15: Automating with Macros.
Chapter 16: Customizing Menus and Toolbars.
Chapter 17: Creating Custom Switchboards and Dialog Boxes.
Part IV: Exchange Data with Others.
Chapter 18: Exchanging Database Objects and Text.