I have started building my school database in Access 2007. I am working on student details right now. I put all student data of admission, fee, examination, report cards, leaving certificate in one table, and, as I couldn't create combo box in the same table for classes and sections, so I designed other tables for those date which have many categories and then added them in the main table. There are many single-option table in the navigation pane. Please let me know, is it the way to do it or we can create combo box from the table and don't need other table for them. If we can, please let me know how.

Secondly, I want to create different query for different data. For instance, one query will be for admission only with student detail for admission and another for fee with fee collection options and so on. In this way, I have many classes and I need more than 100 queries for different classes and section and the same for examination result please let me know if there is an easier and quicker way to do it.

Thanks for your help! It is not common to use software for school operation in ou

---

Reply from Richard Rost:

Part 1: Sounds to me like you need to set up multiple tables to store related data. I cover this in Access 201. Here's a free tutorial on how to do something similar.

Part 2: This is what PARAMETER queries are for.