1. Edition - March 2010
43.90 Euro
2010. 792 Pages, Softcover
- Practical Approach Book -
ISBN-10: 0-470-52574-6
ISBN-13: 978-0-470-52574-6 - John Wiley & Sons






Sample Chapter

Detailed description
Database models developed by a team of leading Microsoft Access MVPs that provide ready-to-use solutions for sales, marketing, customer management and other key business activities for most small businesses.

As the most popular relational database in the world, Microsoft Access is widely used by small business owners. This book responds to the growing need for resources that help business managers and end users design and build effective Access database solutions for specific business functions.

Coverage includes:
* Elements of a Microsoft Access Database
* Relational Data Model
* Dealing with Customers and Customer Data
* Customer Relationship Management Database Solutions
* Marketing Database Solutions
* Sales Database Solutions
* Producing and Tracking the Goods & Services
* Production and Manufacturing Database Solutions
* Inventory Management Database Solutions
* Services Database Solutions
* Tracking and Analyzing Financial Data 1
* Accounting Systems: Requirements and Design Database Solutions
* Accounting: Budgeting, Analysis, and Reporting Database Solutions
* Managing Memberships
* Implementing the Models
* SQL Server and Other External Data Sources
* With this valuable guide and CD-ROM, you'll be on your way to implementing database solutions in no time

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

From the 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.