Microsoft Access Small Business Solutions : State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities

by Teresa Hennig; Truitt L. Bradly; Larry Linson; Leigh Purvis; Brent Spaulding

• ISBN13: 9780470640586
• ISBN10: 0470640588
• Format: eBook
• Copyright: 2010-02-01
• Publisher: Wiley

Summary

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.

Table of Contents

Foreword

Introduction

Introduction and Basic Concepts

Overview and Road Map

Elements of a Microsoft Access Database

Relational Data Model

Dealing with Customers and Customer Data

People, Organizations, Addresses

Customer Relationship Management

Marketing

Sales

Producing and Tracking the Goods & Services

Production and Manufacturing

Inventory Management

Services

Tracking and Analyzing Financial Data

Accounting Systems: Requirements and Design

Independent Areas

Accounting: Budgeting, Analysis, and Reporting

Managing Memberships

Implementing the Models

SQL Server and Other External Data Sources

Appendices

Field Properties

Relationships, Joins, and Nulls

Resolving Relationship Triangles

Measures: Financial and Performance

References and Resources

What's on the CD-ROM

Bonus Material

Database and Business Terms

Gathering Requirements

Data Warehousing Concepts

Database Platforms

Index

Table of Contents provided by Publisher. All Rights Reserved.