How to save the query based report for future reference ?

[mb60]

I generated a query based report from access table.I would like to save it in the table for future reference.
Reason:
Generated report is a mcq question paper of a chapter. If I would like to give the same paper for my students for practice in the future how can save and recall it?

I request the experts to guide me to solve this problem

Thank you

[missinglinq]

I'd simply import the table/query/record in a new, blank database and save it with an appropriate name. .

Linq ;0)>

[mb60]

It is not one. Such reports are many

[NeoPa]

What exactly do you want saved? The question is not clear.

[Stewart Ross]

This is nothing to do with reports as such. You are generating a multiple choice question paper which is printed as a report and issued to students. You want to save a copy of the report for the future. You mention that your report is based on a query (as it should be).

What is not said is how you select a particular question set to issue. Normal practice when dealing with generating sets of multiple choice questions is to have a bank of questions, then select a set either at random or by manual choice. The design of the database has to accommodate the storage of a specific question set so that it can be re-selected and printed on other occasions (as a past paper for other classes to study, for instance).

All this preamble is to say that reporting is the final stage of the process; what matters here is whether you have designed your database to store in a table somewhere the selection of questions making up paper x, where x is whatever reference you give to your paper. You would also need to associate that paper with a particular issue date, so that you can tell it was issued in June 2010, say, if you want to use it in future years, the course in which you are using it, and the exam diet if applicable (for example, Question Paper A832-01, Semester 1, June 2010).

You mention a chapter of some kind; is the question set associated with specific chapters in a textbook rather than a specific exam diet? If it is, the same principle of designing the underlying tables to model the relationships between the chapters and the questions applies.

If you set up the tables correctly from the start you can reprint any question set at any time.

-Stewart