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
Synopsis
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.
Synopsis
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 1: Get Acquainted with Access 2003 2: Create a Database 3: Create and Modify Tables 4: Relate Tables 5: Enter and Edit Data Part II: Retrieve and Present Information 6: Sort, Filter, and Print Records 7: Extract Information with Queries 8: Create Advanced Queries 9: Understand Form and Report Design Basics 10: Create Custom Forms and Subforms 11: Create and Customize Reports and Subreports 12: Create Charts and Graphs Part III: Improve the Access 2003 Workplace 13: Customize the Workplace 14: Speed Up Your Database 15: Automate with Macros 16: Customize Menus and Toolbars 17: Create Custom Switchboards and Dialog Boxes Part IV: Exchange Data with Others 18: Exchange Database Objects and Text 19: Exchange Data with Outside Sources 20: Share with Multiple Users 21: Secure a Database Appendix: Convert to Access 2003