Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities -- About the Authors -- About the Contributing Authors and Technical Editors -- Acknowledgments -- Contents at a Glance -- Contents -- Foreword -- Introduction -- Part I: Introduction and Basic Concepts -- Chapter 1: Overview and Road Map -- Part I: Introduction and Fundamentals -- Part II: Dealing with Customers and Customer Data -- Part IV: Tracking and Analyzing Financial Data -- Part V: Independent Areas -- The Appendixes -- Part VI: Bonus Content -- Chapter 2: Elements of a Microsoft Access Database -- Database Schema -- Tables -- Relationships -- Queries -- Summary -- Chapter 3: Relational Data Model -- The Basics -- A Little Deeper -- Normalization -- Summary -- Part II: Dealing with Customers and Customer Data -- Chapter 4: People, Organizations, Addresses -- How This Chapter Is Organized -- Basic Field Information -- People and Organization Information Processing and Storage -- The Simple Model -- Differences between the Simple and Complex Models -- The Complex Model -- Adding More Information about People and Organizations -- Summary -- Chapter 5: Customer Relationship Management -- Six Core Topics of Customer Relationship Management -- Approach for Reviewing Core Topics -- Customer Information -- Basic Business Functions for People and Organizations -- Tracking Customer Correspondence -- Tracking Correspondence Overview -- Tracking Sales Information for CRM -- Sales Information for CRM Overview -- Tracking Service and Support Information -- Advertising and Marketing Campaigns, Targeted and General -- Internal Information Sharing -- Improving Process Quality -- Summary -- Chapter 6: Marketing -- Marketing Campaigns -- Questionnaires -- Summary -- Chapter 7: Sales -- Building the Model.

Designing the Tables -- A More Complex Model -- Using the Database -- Summary -- Part III: Producing and Tracking the Goods & Services -- Chapter 8: Production and Manufacturing -- Industry Terms -- Enterprise-Level Systems -- Purpose of the Database -- Identifying the Requirements -- Identifying User Expectations -- Manufacturing Overview: Identifying the Core Subjects -- Manufacturing Processes -- Putting It All Together -- More Information -- Summary -- Chapter 9: Inventory Management -- The Approach for This Chapter -- The Inventory Management Database -- Inventory Overview: Identifying the Subjects -- Approach for Reviewing the Core Subjects -- Products -- Vendors -- Locations -- Transactions -- Putting It All Together -- Summary -- Chapter 10: Services -- Database Terminology -- Appointments Made Simple -- Pet Boarding Example -- Process Monitoring -- Variations of the Theme -- Summary -- Part IV: Tracking and Analyzing Financial Data -- Chapter 11: Accounting Systems: Requirements and Design -- Double-Entry Accounting -- Chart of Accounts -- General Ledger -- Database Design Considerations -- Accounting Database -- Relationships -- Summary -- Chapter 12: Accounting: Budgeting, Analysis, and Reporting -- Budgets -- Analyzing Profitability -- Summary -- Part V: Independent Areas -- Chapter 13: Managing Memberships -- Membership Management Functions -- Communication -- Recruiting -- Sponsorships -- Summary -- Chapter 14: Implementing the Models -- Not-for-Profit Organizations -- Designing the Database -- Components of the User Interface -- User Interface Design -- Products -- Summary -- Chapter 15: SQL Server and Other External Data Sources -- Client-Server Databases -- Server Database Design -- Optimization Suggestions -- Other Data Sources -- Summary -- Part VI: Appendixes -- Appendix A: Field Properties -- Using Field Properties.

Appendix B: Relationships, Joins, and Nulls -- Relationships and Joins -- Domain (or Lookup) Tables -- Summary -- Appendix C: Resolving Relationship Triangles -- Non-Normalized Schema to Support a Less Complex Interface -- Using the Law Of Propagating Nulls to Validate -- Normalized Tables Supported in a More Complex Interface -- Sub-table for Notes -- Summary -- Appendix D: Measures: Financial and Performance -- Financial and Nonfinancial Measures -- Summary -- Appendix E: References and Resources -- Our Favorite Starting Points -- Websites of the Authors and Tech Edit Teams -- Newsgroups -- Books -- Bonus Resource Database -- Appendix F: What's on the CD-ROM -- System Requirements -- Using the CD -- What's on the CD-ROM -- Troubleshooting -- Customer Care -- Index -- Part VII: Bonus Material -- Chapter 1: Knowledge: Intellectual Property, Structural Capital, and Intellectual Capital -- Intellectual Property -- Structural Capital -- Intellectual Capital -- Summary -- Bonus Appendix A: Database and Business Terms -- Bonus Appendix B: Gathering Requirements -- Dos and Don'ts of Asking Questions -- The Specification -- Comments and Summary -- Bonus Appendix C: Data Warehousing Concepts -- Data Warehouse Tables -- Load Process -- Table Design -- Query Design -- Reporting on the Data -- Bonus Appendix D: Database Platforms -- Key Factors for Selecting the Platform -- Common Platforms -- Summary.