B
BillT
Hi Everyone:
I'm new to Access and I need help automating a process to save me a ton of
time.
I'm a math department chair and I have a database of student information
such as marking period grades and exam scores. It's a very simple database
and every year I import all of the 6-12 students as new records with the same
fields, but just a different school year.
Anyway, all of the students have a unique id number in the district.
Teachers send me spreadsheets of data with the students names, id number and
then different columns of assorted data. I now have to update the records in
the main table from these spreadsheets. I have been first importing the data
into a new table from the Excel spreadsheet, and then once the new table is
created I create an update query for each teacher. Is there an easier way? I
have 24 teachers and this takes about 15 minutes or so each. I would really
like to know if there is another way, and also if there is a better way to
gather information from teachers than Excel. They like to add information
from home and so there is no access from home to the database.
Thanks for the time,
Bill
I'm new to Access and I need help automating a process to save me a ton of
time.
I'm a math department chair and I have a database of student information
such as marking period grades and exam scores. It's a very simple database
and every year I import all of the 6-12 students as new records with the same
fields, but just a different school year.
Anyway, all of the students have a unique id number in the district.
Teachers send me spreadsheets of data with the students names, id number and
then different columns of assorted data. I now have to update the records in
the main table from these spreadsheets. I have been first importing the data
into a new table from the Excel spreadsheet, and then once the new table is
created I create an update query for each teacher. Is there an easier way? I
have 24 teachers and this takes about 15 minutes or so each. I would really
like to know if there is another way, and also if there is a better way to
gather information from teachers than Excel. They like to add information
from home and so there is no access from home to the database.
Thanks for the time,
Bill