Access 2003 Inside Out

Description

Hey, you know your way around a database - so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery!

* Build on what you already know about Access and quickly dive into what’s new
* Design your database the way the experts do - and sidestep common mistakes
* Import data from spreadsheets, text files, databases, and other sources
* Write simple to sophisticated queries to manipulate data
* Learn advanced techniques for building forms and reports
* Develop PivotTable and PivotChart dynamic views
* Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures
* Implement database security features
* Deliver dynamic data on the Web with data access pages and XML
* Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages

CD features:

* Complete eBook in PDF format
* Insider Extras - including fully functional sample databases, VBA code, and sample web pages
* Catalog of Access resources with links to third-party tools and demos
* Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook
* Microsoft Computer Dictionary, Fifth Edition, eBook - 10,000+ entries

CONTENTS:

AcknowledgmentsWe’d Like to Hear from You!About the CDConventions and Features Used in This BookIntroductionPart 1: Understanding Microsoft Access
* Chapter 1: What Is Microsoft Access?
* Chapter 2: The Many Faces of Microsoft Access
* Chapter 3: Designing Your Database ApplicationPart 2: Building a Microsoft Access Desktop Application
* Chapter 4: Creating Your Database and Tables
* Chapter 5: Modifying Your Table Design
* Chapter 6: Importing and Linking Data
* Chapter 7: Creating and Working with Simple Queries
* Chapter 8: Building Complex Queries
* Chapter 9: Modifying Data with Action QueriesPart 3: Creating Forms and Reports in a Desktop Application
* Chapter 10: Using Forms
* Chapter 11: Building a Form
* Chapter 12: Customizing a Form
* Chapter 13: Advanced Form Design
* Chapter 14: Using Reports
* Chapter 15: Constructing a Report
* Chapter 16: Advanced Report DesignPart 4: Designing an Access Project
* Chapter 17: Building Tables in an Access Project
* Chapter 18: Building Queries in an Access Project
* Chapter 19: Designing Forms in an Access Project
* Chapter 20: Building Reports in an Access ProjectPart 5: Automating an Access Application
* Chapter 21: Understanding Event Processing
* Chapter 22: Understanding Visual Basic Fundamentals
* Chapter 23: Automating Your Application with Visual Basic
* Chapter 24: The Finishing TouchesPart 6: Linking Access and the Web
* Chapter 25: Publishing Data on the Web
* Chapter 26: Creating Static and Dynamic Web Pages
* Chapter 27: Building Data Access Pages
* Chapter 28: Working with XML and SharePointPart 7: After Completing Your Application
* Chapter 29: Upsizing a Desktop Application to a Project
* Chapter 30: Securing Your Database
* Chapter 31: Distributing Your ApplicationPart 8: Appendix
* Appendix : Installing Microsoft Office
* Appendix : Index to Troubleshooting Topics
* Appendix : About the Author