T
tkl
I need help in making my database (and bound form)
more "efficient". I am new to Access, bought two books &
have been teaching myself, so I apologize if this inquiry
is actually easily solved. I have just hit a wall.
My database is based on a Quality Performance Audits of
each employee. After creating my database/table, I then
created a form for easy data entry. However, my problem
is I KNOW there has to be a better/easier way to a).
enter the information onto the form (& table) in order
to...b). pull a report and/or query to show ...i.e.
August 2004.. "x" QI audits done...
as well as being able to 'easily' pull a report that
counts the # of times "y" criteria (of the 25 audited) is
noted/marked (& best case scenario...the % "y" criteria
in relation to "x" total audits in database.
Currently my form list "Criteria 1"[label] (3of these
options on the form) with a combo box drop down that list
all >25 options (which are in summarized sentence/memo
format). I just feel like there has to be a way to
change it to a Yes/No type option (but then my form will
contain labels with >25 detailed criteria titles. Or is
there a way to maybe leave the form the way I have it,
but have the actual entry chosen to go onto attached
table/database as a ?numeric? value (i.e. "y" criteria is
assigned a code/value)..my table is 3 feet long with the
current data that is entered.
Sorry for the length. Does this make any sense? It is
hard to explain in writing. I know their is a simple
solution, I think I have just hit overload on the amt. of
info. I have learned in the past month & I can't seem to
solve this one with my head in the books. I need advice..
(or just morale support...
).
Thanks for any help or suggestions anyone can give!
tkl
more "efficient". I am new to Access, bought two books &
have been teaching myself, so I apologize if this inquiry
is actually easily solved. I have just hit a wall.
My database is based on a Quality Performance Audits of
consists of 20-25 different "criteria" being monitored on
each employee. After creating my database/table, I then
created a form for easy data entry. However, my problem
is I KNOW there has to be a better/easier way to a).
enter the information onto the form (& table) in order
to...b). pull a report and/or query to show ...i.e.
August 2004.. "x" QI audits done...
as well as being able to 'easily' pull a report that
counts the # of times "y" criteria (of the 25 audited) is
noted/marked (& best case scenario...the % "y" criteria
in relation to "x" total audits in database.
Currently my form list "Criteria 1"[label] (3of these
options on the form) with a combo box drop down that list
all >25 options (which are in summarized sentence/memo
format). I just feel like there has to be a way to
change it to a Yes/No type option (but then my form will
contain labels with >25 detailed criteria titles. Or is
there a way to maybe leave the form the way I have it,
but have the actual entry chosen to go onto attached
table/database as a ?numeric? value (i.e. "y" criteria is
assigned a code/value)..my table is 3 feet long with the
current data that is entered.
Sorry for the length. Does this make any sense? It is
hard to explain in writing. I know their is a simple
solution, I think I have just hit overload on the amt. of
info. I have learned in the past month & I can't seem to
solve this one with my head in the books. I need advice..
(or just morale support...
).Thanks for any help or suggestions anyone can give!
tkl