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

Teresa Hennig (Author), Truitt L. Bradly (Author), Larry Linson (Author), Leigh Purvis (Author), Brent Spaulding (Author)

Book Description

ISBN-10: 0470525746 | ISBN-13: 978-0470525746 | Publication Date: March 8, 2010 | Edition: 1

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.

Editorial Reviews

From the Back Cover

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 — a total of 76 files — on the CD-ROM

Save hundreds of hours of development time!

CD-ROM contains

• 31 database models, covering each business area discussed

• A printable, detailed file guide to help you locate files and tools

• A Bonus Resource database, with reference tables and valuable tools for creating and managing databases

All files work with Access 2000 through 2010. See the CD Appendix for complete system requirements.

About the Author

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.

Product Details

• Paperback: 792 pages
• Publisher: Wiley; 1 edition (March 8, 2010)
• Language: English
• ISBN-10: 0470525746
• ISBN-13: 978-0470525746
• Product Dimensions: 9.2 x 7.4 x 1.7 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #163,184 in Books (See Top 100 in Books)
  • #69 in Books > Business & Investing > Small Business & Entrepreneurship > Marketing

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

6 of 8 people found the following review helpful:

1.0 out of 5 stars Poorly written and organized, December 3, 2010

By 

openmind "zenon" (Silver Spring, MD USA) - See all my reviews

Amazon Verified Purchase

This review is from: Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities (Paperback)

This book is so poorly written that once you put it down you do not want to pick it up again. It is highly repetitive as if trying to fill empty pages and from my perspective does not offer a great deal in terms of learning. Even the form design in Chapter 14, the only chapter where "form" design is touched upon, is esthetically and functionally is amateurish at best. I have read many books on Microsoft Access and this one ranks pretty low. It would have been better had the authors took the time to develop one or two complete applications rather than wasting time on table designs for a bunch of applications with little pedagogic value.

9 of 13 people found the following review helpful:

5.0 out of 5 stars Great resource for novice and experienced developers, March 9, 2010

By 

Duane Hookom (EDEN PRAIRIE, MN, US) - See all my reviews
(REAL NAME)   

This review is from: Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities (Paperback)

I have only begun to read this book. It doesn't take long to realize the authors are sharing their experiences from many years of developing database applications. While focusing on Access there is also advice about if and when to upgrade to client server architecture.

While the subtitle of the book highlights "Database Models", the book is much much more. There is lots of extra content that had even greater value to me as a 25+ year database developer. I have already begun using some of their tools and tips in my projects.

I would recommend Microsoft Access Small Business Solutions to all levels of database developers.

5.0 out of 5 stars Good Stuff!!, September 13, 2011

By 

John Riley "IT Professional" (Dallas-Ft Worth, Texas USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities (Paperback)

Wow! very good information here. What a departure from the rather clinical writting of the other reference books on Access. Great added CD content too.