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

x
?
Solved

Access Design Problem

Posted on 2015-01-21
8
Medium Priority
?
229 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
[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
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

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…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

636 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