We issue dosimeters to approximately 400 staff. Each staff is issued a dosimeter for 3 months. The dosimeters are then collected and readout. A file is exported from the dosimeter reader. The file has the dosimeter serial number and the readings but no information on who used it. The next quarter dosimeters are issued to staff again. A dosimeter may be used by different people in different quarters, but a dosimeter will only be used by one person in any quarter.
We have a database that uses a table for each quarters readings. A query then reads the dosimeter file, looks up who used the dosimeter and puts the readings into their record. We have kept each quarter separate so that only one person matches the dosimeter. However after only two years the number of tables and associated relationships, forms, queries, reports etc is getting difficult to manage. Is there a way to organise our existing database to make it easier to manage or should we try to simplify the number of tables?
Thank you.