Quiz database?

[icebook1]

Hi everyone -

I'm working with my band director to make a database within Access. It would be used to make quizzes for the various band classes that he teaches. Each quiz would pull different terms (that he would choose from a list) and put them into a Word document (most likely).

The quizzes are of the matching format. For example, the term "piano" would be in the left column, with the answer "play very softly" somewhere in the right column. In the database, we'd need fields for the term, the symbol (i.e. p, mp, mf, f), and the definition.

The idea behind making this database is this. In music, there are only so many terms for various concepts (for example, tempo markings). The students are quizzed on most pieces that they play. If there was a central list or database where the director could simply pick the terms that apply to that piece, and then print the quiz out to administer to the kids, it would save him a lot of time. Right now, he's making each quiz from scratch which takes waayyy too long.

Any ideas? I've never used Access before, but am very computer-savvy. If there are any templates that could be used, or if someone would be willing to design a template, or just point me in the right direction, I'd really appreciate it!

Thanks!

 

[jeremie_ingram]

First get a good plan to go by.
Look up normalization here on the threads, it will give you a good place to start.

Figure out what tables are needed and what thier structure and relationships should be.
Use a form to make the selections.
Use querys to retrieve the data.
Use reports to display and print the data.

These are enough to get you researching, work from here and post questions as you come across problems. Be specific in you problems, and know what you are going for.
From what you have asked I could give a million variations so research - plan- work it through.