Can Access 2002 solve the following problem?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My manager at work gave me an example of a kind of problem and wants to know if Access can help deal with it
Here is the problem

On page 1 of a patient questionnaire, an individual fails to check a box that indicates that they are pregnant. However, on page 3, they are answering portions of the questionnaire that only those individuals who are pregnant should be responding to.

What my manager needs is for the database to recognize, and direct the users attention to, these kinds of problems. Can Access do this? And, if so, where do I begin to learn how to deal with these problems? I am a c# programmer. Can I resolve these kinds of issues programmatically, or are there easier solutions

Any help would be greatly appreciated

Thanks
 
Assuming that by "page", you mean "form", you can put edit checks in to
ensure that all mandatory fields are completed. In other words, you can
refuse to let them leave the first page if they haven't completed the
mandatory questions. And you can make it so that you only show page 3 if
they are pregnant, or you can show them page 3, but display a message in the
situation you're describing.

Having said that, though, Access doesn't do anything like that. You have to
write VBA code to do it.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Narwe said:
My manager at work gave me an example of a kind of problem and wants to
Click to expand...
know if Access can help deal with it.
Here is the problem:

On page 1 of a patient questionnaire, an individual fails to check a box
Click to expand...
that indicates that they are pregnant. However, on page 3, they are
answering portions of the questionnaire that only those individuals who are
pregnant should be responding to.
What my manager needs is for the database to recognize, and direct the
Click to expand...
users attention to, these kinds of problems. Can Access do this? And, if
so, where do I begin to learn how to deal with these problems? I am a c#
programmer. Can I resolve these kinds of issues programmatically, or are
there easier solutions?
 
Having said that, though, Access doesn't do anything like that. You have
to

Cross-field data validation ???

Having said that, though, nobody does that using cross-field data
validation....

(david)
 
Thank you for the replies but in my absent mindedness I failed to mention a key factor

I'm dealing with data that already exists. The questionnaires have been completed and now the contradictory data needs to be dealt with.

I'm very sorry I didn't mention that initially. It's been a long day.
 
Access is (amongst other things) a data environment that allows you display
or use the results of Structured Queries on general data, even if you don't
really know any SQL or how to write Windows Programs.

So yes, Access 2002 can solve the problem.

What exactly are you trying to do? Do you want to update the 'pregnant flag
if other data is there? Do you want a list of all the people who (answered
questions about pregnancy without setting the 'pregnant flag)?

(david)


Narwe said:
Thank you for the replies but in my absent mindedness I failed to mention a key factor.

I'm dealing with data that already exists. The questionnaires have been
Click to expand...
completed and now the contradictory data needs to be dealt with.
 
Narwe said:
Thank you for the replies but in my absent mindedness I failed to
mention a key factor.

I'm dealing with data that already exists. The questionnaires have
been completed and now the contradictory data needs to be dealt with.

I'm very sorry I didn't mention that initially. It's been a long day.
Click to expand...

Are the results of these questionnaires stored in an Access database, or
in a form that Access can link to as a table, such as an Excel
spreadsheet or a tabular text file? If so, it's easy enough to write a
query that selects records where the "Pregnant" field is False, but any
of various "pregnancy-only" fields is not Null.
 
Back
Top