Solved

Access Design Problem

Posted on 2015-01-21
8
217 Views
Last Modified: 2015-01-21
I am working on a db design problem and have finished the database. I would like someone to look at it and make some suggestions. I have included the files needed for your evaluation on overall design thus far. I am new to this.

Thank you in advance.

Sam
241JRC02Aaccdb.accdb
dbDesignProb.docx
0
Comment
Question by:James Coats
  • 5
  • 3
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40563067
Your word doc reads like this is a Homework assignment.
If this is the case we cannot directly give to a "solution"

Please know that It is very difficult to just look at a design and offer any real "suggestions", without knowing the full scope and breadth of this system.
0
 

Author Comment

by:James Coats
ID: 40563087
Yes it is a homework assignment. Should I delete the question?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40563088
First impressions...
It is not typical for an Employee to be associated with a Product...
I don't see any element there designating the employees department.
Yo need to adopt a more streamlined naming convention
In most cases, the Primary key in a table will be an Autonumber field.
...
etc

The good news is that your requirement here (at a very basic level) match with the original "Northwind" sample database.
MS used to have a direct link, ...but I think you can still find it here:
http://download.cnet.com/Access-2000-Tutorial-Northwind-Traders-Sample-Database/3000-2251_4-10742880.html
(Here, all precautions apply for downloaded files)

JeffCoachman
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 40563106
Yes it is a homework assignment. Should I delete the question?
No, ...but bear in mind we cannot "solve" this for you (even if it wasn't)

What I posted above should get you started.

Pay close attention to the "OrderDatails" (Many--To--Many) table in the Northwind sample database....

You can post back with any questions, ..
But remember, this site is not really a site to provide "absolute" design advice...

Keep us posted...
;-)

JeffCoachman
0
 

Author Closing Comment

by:James Coats
ID: 40563125
I understand that and I know you can't solve the problem as it is very elementary and there is likely more than one way to solve each problem. Thank you very much for the links as I am sure they will help. I don't have the Northwind on my Access 2013 but I am guessing I can install a download from MS via the link you sent me.

Thank again.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40563360
there is likely more than one way to solve each problem.
Yes, ...It was not clear form the Word Doc, ...what the ultimate goal would be
...But you seem to be off on a good start...
;-)
I don't have the Northwind on my Access 2013
There is a newer version of the Northwind sample database, ....but it is *much* more complicated than a beginner could understand.
I am guessing I can install a download from MS via the link you sent me.
The link I posted is not an official MS site/link
as I said, MS used to have a link to the original file,. but I have not seen it in years.

If you can get a hold of a machine running Access 2003 or older, ...the Northwind database is a Template you can just "Open"

;-)

JeffCoachman
0
 

Author Comment

by:James Coats
ID: 40563630
Thank you, I did find it after looking at the link you sent me. You are correct it is quite complicated. I'm not sure I can actually understand much of it. But it may give me some ideas.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40563695
The design is almost identical to what your requirement is here:
Employees
customers
products
orders
...etc
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

830 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