G
Guest
I am trying to create a database to track projects and I am having trouble
getting my arms around it.
getting my arms around it.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lynn Trapp
Without some more information -- like exactly what you are trying to do --
no one will able to get their arms around it.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
no one will able to get their arms around it.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
G
Guest
Gus L. said:I am trying to create a database to track projects and I am having trouble
getting my arms around it.
I have a project log in excel and what my company calls a complex design
information sheet. What I want to do is combine the two with one form but be
ablet view the information seperately.
J
John Vinson
I have a project log in excel and what my company calls a complex design
information sheet. What I want to do is combine the two with one form but be
ablet view the information seperately.
The first mental leap to make is:
Forms ARE NOT DATA.
A Form is just a window, a way of viewing data.
When you're building a database, the first thing to do is to *forget
about* forms, and how the data will be displayed; that's secondary.
Instead, identify the real-life things, persons, or events of
importance to the application - the "entities". A Project would
clearly be an entity; I'd guess you'll need a table to contain the
people working on the project, perhaps a table of goals, perhaps a
table of project checkpoints: I don't know your business model, so I
don't know what tables there will be, other than that there will be at
least a few other tables.
Once you have the LOGICAL structure of the data, you can build a Table
for each type of entity.
*THEN* you can start thinking about using Forms to combine and display
that information onscreen, or Reports to print the information to
paper. These Forms and Reports would typically draw information from
multiple tables, using Queries, Subforms, Combo Boxes and the other
tools that Access provides.
John W. Vinson[MVP]
G
Guest
Gus L. said:I am trying to create a database to track projects and I am having trouble
getting my arms around it.
I am trying to merge two forms one is a project log and the other is a form
called a complex design request so all the information is in on local but can
be called up and searched independantly of each other.
J
John Vinson
I am trying to merge two forms one is a project log and the other is a form
called a complex design request so all the information is in on local but can
be called up and searched independantly of each other.
Gus, Lynn and I have both answered your previous posts. Did you see
those replies?
Reposting the same question over and over is neither necessary nor
polite.
John W. Vinson[MVP]