Microsoft Access Small Business Solutions

About the Authors, Microsoft Access MVPs Teresa Hennig is the author of the highly regarded Access Programmer's Reference titles from Wrox Press. Truitt Bradly has developed numerous insurance and health care database applications using Access and SQL Server. Larry Linson is a software developer and project manager focused on Access database application development. Leigh Purvis operates Database Development and works with Access either natively or in conjunction with SQL Server.Brent Spaulding has designed database systems for a variety of business areas using SQL Server and Access.

Foreword. Introduction. Part I Introduction and Basic Concepts. Chapter 1 Overview and Road Map. Chapter 2 Elements of a Microsoft Access Database. Chapter 3 Relational Data Model. Part II Dealing with Customers and Customer Data. Chapter 4 People, Organizations, Addresses. Chapter 5 Customer Relationship Management. Chapter 6 Marketing. Chapter 7 Sales. Part III Producing and Tracking the Goods & Services. Chapter 8 Production and Manufacturing. Chapter 9 Inventory Management. Chapter 10 Services. Part IV Tracking and Analyzing Financial Data. Chapter 11 Accounting Systems: Requirements and Design. Part V Independent Areas. Chapter 12 Accounting: Budgeting, Analysis, and Reporting. Chapter 13 Managing Memberships. Chapter 14 Implementing the Models. Chapter 15 SQL Server and Other External Data Sources. Part VI Appendices. Appendix A Field Properties. Appendix B Relationships, Joins, and Nulls. Appendix C Resolving Relationship Triangles. Appendix D Measures: Financial and Performance. Appendix E References and Resources. Appendix F What's on the CD-ROM. Part VII Bonus Material. Chapter B1 Knowledge: Intellectual Property, Structural Capital, and Intellectual Capital. Appendix BA Database and Business Terms. Appendix BB Gathering Requirements. Appendix BC Data Warehousing Concepts. Appendix BD Database Platforms. Index.