Microsoft Access Small Business Solutions (With CD)

0.0

This book explains how to design a database for specific business functions common to most small businesses--including: Marketing and sales Customer management Inventory management Quality control Budgeting Financial tracking and analysis The book is aimed primarily at the needs of small-to-medium size businesses that rely on Microsoft Office and related technologies. The accompanying CD-ROM includes pre-built database models for each of the business activities described in the book, ready to load into Microsoft Access. The databases work across multiple versions of Microsoft Access. The authors show how even non-technical readers can quickly customize these databases to meet their unique business needs. To that end, they present step-by-step interview processes that help tailor the database structure to specific business scenarios or industry requirements. Key Features All authors are Microsoft Access MVPs---each with their own community platforms for promoting the book. The accompanying CD-ROM includes working Access database models for for real-world business activities, like marketing, sales, and customer support. The book more than pays for itself by providing ready-to-load databases that can be quickly customized---saving countless hours of development time. The database models are independent of specific releases of Microsoft Access, ensuring a long and profitable sales life. About The Author Teresa Hennig is a Microsoft Access MVP, President of the Seattle Access group (www.SeattleAccess.org) since 1999, and the President of the Pacific Northwest Access Developer Group (www.PWNADG.org) since 2002. Her two monthly newsletters reach readers nationwide. She is the lead author of the highly regarded Access 2007 VBA Programmer's Reference (Wrox). Truitt L. Bradly is a Microsoft Access MVP; as an accountant, analyst, and developer, Truitt has developed insurance and health care database applications using Access and SQL Server. He was Technical Editor for Microsoft Office Access 2007 VBA (Que). Larry Linson is a Microsoft Access MVP; he is a software developer and project manager focusing on database application development with Microsoft Access. He founded (and continues to be Co-Leader of) the Microsoft Access Special Interest Group in the North Texas PC User Group. Leigh Purvis is a Microsoft Access MVP, and proprietor of Database Development. His primary focus is working with Microsoft Access, either natively or in conjunction with MS SQL Server. He contributes to several online forums as well as writing the occasional article and FAQ. Brent Spaulding is a Microsoft AccessMVP. He has designed database systems for a wide range of business areas using Access, SQL Server, as well as JET and ACE desktop database engines. He co-authored Microsoft Office Access 2007 VBA (Que). Table Of Contents 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.