Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

custom access setup

Posted on 2011-03-15
5
Medium Priority
?
1,989 Views
Last Modified: 2012-05-11
Very long question, I apologize up front.
My company sells 3 types of a product.  Each type of product has several different specifications.  Each product is sold in various sizes, some types have only one, some types have as many as 5.  We have roughly 500 customers, each has their own pricing structure depending upon their past purchase history. Each month, each customer receives a revised price list (3 pages, 1 page for each type) with current pricing.  I currently have this working in a excel-word mail merge, but would like this to be in a database instead.  I've tried to set this up in a database, but access-word merges don't work as I want them to.  From other questions on this issue, everyone says to use the report function in access, but the formatting is very specific how the owner of the company wants it to be.  Could anyone provide guidance as to what would be the proper way to set this up in access, if it is possible at all. I am attaching a basic layout of the spreadsheet (truncated to show sizes, types, & categories) I have setup and how the merged form needs to look like. layout of reportspreadsheet.jpg
0
Comment
Question by:lancecurwensville
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 58
ID: 35146687

 I'll need some more detail for the database design, but the above Thermal report is simply a list in a multi-column format.   The Insulated one is what is called a cross-tab report.  Both these could be done as sub-reports and combined into a single main report if need be.

  I'm about to walk out of the office till latter today.  If no one jumps in on this before I get back, I'll go through it with you.

JimD.
0
 
LVL 8

Author Comment

by:lancecurwensville
ID: 35147075
Thanks, let me know how to pursue this.
0
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 2000 total points
ID: 35147129
see sample Entity Relationship (ER) Diagram for an apparel retailer that you might be able to adapt to your circumstances, or at least use as a learning tool.  Note the relationships between the product table and size table.

    http://www.accountingsystemsanalyst.com/Analysis/Nomas_ERD.JPG 
0
 
LVL 58
ID: 35151176
OK, I'm back.

  So let's see, we have the following "things" that we need to keep track of:

Customers
Prices
Products
Sizes
Product Sizes (what sizes the product comes in).
Product Categories

  Am I missing anything else?

JimD.

 
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question