Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access Design Problem

Posted on 2015-01-21
8
Medium Priority
?
234 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

578 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