Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities
- 15h 5m
- Teresa Hennig, et al.
- John Wiley & Sons (US)
- 2010
Take control with database models designed exclusively for your business
Every small-business owner knows how important effective databases are to successful sales, marketing, and customer management strategies. Effective is the key word, and Microsoft Access enables you to create solutions tailored to meet your specific needs. In this book, a team of Microsoft Access MVPs shows you how to design databases that support your efforts for marketing, sales, inventory management, quality control, budgeting, financial tracking and analysis, customer relations, and many other activities.
- Learn interview techniques that will help you determine the database requirements and tailor your database model to specific business scenarios
- Build simple to complex models for tracking sales, services, and customer relations
- Construct databases for budgeting, financial analysis, production and manufacturing, and customer contacts
- Track inventory, vendors, and manufacturing services
- Design models and simple solutions to manage memberships, events, and sponsors, both profit and not-for-profit
- Adapt the table structure for SQL Server and other external data sources
- Get the single most comprehensive set of database models and guides available
Save hundreds of hours of development time!
About the Authors
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.
In this Book
-
Foreword
-
Introduction
-
Overview and Road Map
-
Elements of a Microsoft Access Database
-
Relational Data Model
-
People, Organizations, Addresses
-
Customer Relationship Management
-
Marketing
-
Sales
-
Production and Manufacturing
-
Inventory Management
-
Services
-
Accounting Systems—Requirements and Design
-
Accounting—Budgeting, Analysis, and Reporting
-
Managing Memberships
-
Implementing the Models
-
SQL Server and other External Data Sources
-
Knowledge—Intellectual Property, Structural Capital, and Intellectual Capital
