New Alpha users often post questions to this forum about how to design a A5V10 database.
Here's a resource worth checking out, available at Amazon.com for around $31.00:
Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities - Teresa Hennig
I looked at a copy this afternoon at Borders Books ($50.00) and was impressed. It contains fairly complete datamodels for 31 different applications.
Here's the official blurb:
Here's a resource worth checking out, available at Amazon.com for around $31.00:
Microsoft Access Small Business Solutions: State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities - Teresa Hennig
I looked at a copy this afternoon at Borders Books ($50.00) and was impressed. It contains fairly complete datamodels for 31 different applications.
Here's the official blurb:
Code:
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. 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.
Comment