D
dbracey
Hi all,
Firstly I'll appologise for the lengthy post, but writing out my
quesion often helps me understand it better myself.
I am designing a database to catalogue and generate reports based on
input data. I am unfortunately forced to use Access due to budget
limitations. I am a VB and SQL kid and don't know a whole lot about
Access.
Here's the project.
A survey consists of a variable amount of items (typically 8-12.) Each
item is assigned a numeric value from 1-10 by the surveyed party. Each
survey is assigned a gender, one of 3 age groups and a branch location.
Graphs will be generated on:
Overall results of each item.
Branch results for each item.
Demographic results of each item.
Most of the problems I am encountering are in the design. I am trying
make this as time efficient as possible, because people are entering
them manually and sometimes upwards of 1000 surveys.
I would like to write a script that remembers the last branch, gender,
and age group entered. The data entry person sorts the surveys by these
categories before entering the data so there might be 100 surveys from
a specific branch with gender female and age group 1. So if Access can
remember which one was entered last that would save 297 steps! they
would only have to change these when they reached a new category.
Also I'm having trouble with entering the number of items. As I
explained before there are a variable number of items each time a
survey is done (not for each individual survey.) I'm wary of setting up
an excessive amount of inputs for this and allowing NULL values because
I don't want actual items to have NULL values. This would skew the
results we are looking for.
Last but not least, does anyone have a good reference for the reporting
function of Access? Does Access have Crystal Reports functionality?
Like I said I am used to setting up data structures in SQL and writing
front end GUI's with VB, I have found this to be highly effective and
efficient, but my boss doesn't think that this is worth spending $1,200
on the software I need.
Any help you can offer would be greatly appreciated!
Firstly I'll appologise for the lengthy post, but writing out my
quesion often helps me understand it better myself.
I am designing a database to catalogue and generate reports based on
input data. I am unfortunately forced to use Access due to budget
limitations. I am a VB and SQL kid and don't know a whole lot about
Access.
Here's the project.
A survey consists of a variable amount of items (typically 8-12.) Each
item is assigned a numeric value from 1-10 by the surveyed party. Each
survey is assigned a gender, one of 3 age groups and a branch location.
Graphs will be generated on:
Overall results of each item.
Branch results for each item.
Demographic results of each item.
Most of the problems I am encountering are in the design. I am trying
make this as time efficient as possible, because people are entering
them manually and sometimes upwards of 1000 surveys.
I would like to write a script that remembers the last branch, gender,
and age group entered. The data entry person sorts the surveys by these
categories before entering the data so there might be 100 surveys from
a specific branch with gender female and age group 1. So if Access can
remember which one was entered last that would save 297 steps! they
would only have to change these when they reached a new category.
Also I'm having trouble with entering the number of items. As I
explained before there are a variable number of items each time a
survey is done (not for each individual survey.) I'm wary of setting up
an excessive amount of inputs for this and allowing NULL values because
I don't want actual items to have NULL values. This would skew the
results we are looking for.
Last but not least, does anyone have a good reference for the reporting
function of Access? Does Access have Crystal Reports functionality?
Like I said I am used to setting up data structures in SQL and writing
front end GUI's with VB, I have found this to be highly effective and
efficient, but my boss doesn't think that this is worth spending $1,200
on the software I need.
Any help you can offer would be greatly appreciated!