I'm trying to put together a new database based on a previous database put together by someone else. For the most part it isn't bad. It has a table for counties, coordinators, region names, consumer (which contains: fname, lname, address, city, state, zip, DOB, injury date, enrollment date). The problem is, that these consumers typically receive services every year and very often every quarter and the way it has been done in the past is all of the consumer info. table is replicated for each year and saved by year (i.e., roster2009, roster 2010, roster 2011). I would prefer to have one database which uses the same consumer table for each year, but has the ability to run queries that would depict the year and quarter(s) of services received and allow me to track the year(s) and quarter(s) the various individuals received services.
I believe I need to create a service date(year) table and perhaps a quarter table. I'm not sure this is doable and to be honest I took training in Access 2003 nine years ago and have not used the software in several years. Is there a way to do this without programming skills and with my limited knowledge?