Access Design Problem

Posted on 2015-01-21
Medium Priority
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.

Question by:James Coats
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
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.

Author Comment

by:James Coats
ID: 40563087
Yes it is a homework assignment. Should I delete the question?
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.

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:
(Here, all precautions apply for downloaded files)

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 74

Accepted Solution

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...


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.
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"



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.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40563695
The design is almost identical to what your requirement is here:

Featured Post

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.

Question has a verified solution.

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

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…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

770 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