MS Access - Multiple forms vs single forms | Access forum

Hi Craig,

Generally wherever a field looks like an obvious contender for being a category or limited choice of entry, then it is worth having a separate table for it. There are a number of benefits in doing that. Benefits include, keeping the database data compact, efficient, and therefore faster to call up information and avoids or reduces the future tasks to maintain workable table and file sizes. It is easier to get the information into separate tables now than to find yourself doing it to a loaded database say 20000 records later. You can get specific information out for specific purposes by including and excluding tables from queries before you start putting in parameters and reduces complexity of needed queries. Another advantage is that the categorised data which you may often filter on and sort by can be better controlled at input stage which ensures that filters and displays for information don