How do I create a testbank database in Access '07

[TXHusker]

I am studying for some exams and I have some questions / answers from
previous tests. I'd like to create a database by entering those questions
and associated answer. Then use this as a study aid. Any suggestions?

 

[BruceM]

Maybe something like a two-field table with a Question field and an Answer
field. Build a form based on the table, with text boxes txtQuestion and
txtAnswer bound to the fields. In the form's Current event:
Me.txtAnswer.Visible = False
Add a ViewAnswer command button to the form, with its Click event set to:
Me.txtAnswer.Visible = True
In order to do the initial data entry you would probably just want to make
txtAnswer visible, and eliminate code that hides and unhides it.
From the information you have provided I don't see a use for anything other
than a flat (single-table) database. Within that context, a simple
interactive study guide is simple enough to build, although I expect the
act of typing the answers will be of at least as much benefit in retaining
the information as will using the completed project as a study guide.

 

[TXHusker]

thank you for your help...i'll look into this

Maybe something like a two-field table with a Question field and an Answer
field. Build a form based on the table, with text boxes txtQuestion and
txtAnswer bound to the fields. In the form's Current event:
Me.txtAnswer.Visible = False
Add a ViewAnswer command button to the form, with its Click event set to:
Me.txtAnswer.Visible = True
In order to do the initial data entry you would probably just want to make
txtAnswer visible, and eliminate code that hides and unhides it.
From the information you have provided I don't see a use for anything other
than a flat (single-table) database. Within that context, a simple
interactive study guide is simple enough to build, although I expect the
act of typing the answers will be of at least as much benefit in retaining
the information as will using the completed project as a study guide.