編輯推薦: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.
內(nèi)容簡(jiǎn)介: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 analysis.
The 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.
作者簡(jiǎn)介: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.