I am building a database for a highschool so that staff members can track students with poor grades. I have the whole database linked and working however I ran into a slight problem. I was uploading every weeks grades into a new table and building the new week into each relationship. Now I don't mind do that every week, but once I duplicate the database for other schools to use no one is going to know how to update the grades no matter how many instructions I provide.
Is there a way to make a linked Excel source that would upload the same way every week if someone just added data to it?
I want the columns to look like this:
Student ID Last Name First Name Course 10/19 10/26 11/02
No matter whatI have tried I cannot get one linked Excel Sheet to come out looking like this. HELP