I am trying to create a Task table that is associated with project. How do I do that
I am trying to create a Task table that is associated with project. How do I do that
Tell us how you think you might do it, in plain English.
Consider building a House as a project.
What do you think might be the tasks involved?
I know what the tasks are. How do I create this in Access?
![]()
From experience, write down the steps on a piece of paper. Your question and response remind me of most who believe Access=Database. Wrong!
Database is a bunch of design principles and concepts based on some theory.
Access is a software package that has some facilities to implement the "Access version" of those concepts and principles.
Microsoft also has SQL Server, and there is also Oracle, Progress, sqlLite, MySQL, DB2..... each with their version of what/which of those principles and concepts can be supported in a cost effective manner.
Think of database and concepts and principles much like construction theory, materials science, bonding principles...
and Access as tools -- hammer, saw, screw driver, fasteners.... You have to know what you're building to bring it all together.
I think you should look at data modelling, and model what you think are the things involved in your assignment that reflects a Project and Task.
Here's some material that may help you.
Good luck. Let us know how your project goes.
Last edited by orange; 02-13-2015 at 03:54 PM. Reason: spelling