Microsoft Access Small Business Solutions : State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities
by Hennig, Teresa; Bradly, Truitt L.; Linson, Larry; Purvis, Leigh; Spaulding, BrentEdition: 1st
Format: Paperback
Pub. Date: 2010-03-08
Publisher(s): Wiley
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $52.50
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
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 analysisThe 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.
Author Biography
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.
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.
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.