Hello,
Here is my situation and I need advice from all you Alpha Guru's out there. I just purchased Alpha 5 V9 and am starting to learn. I have inherited an Access Database that was created a while back that keeps track of student information for our Skills Development Grants. What I get is an Excel Spreadsheet containing new and updated info on the students (a new version each month that shows any new students, classes they took, how many hours, etc. as well as old students that might have taken or finished a course or might have been terminated, etc.). The Access database is the repository for the data, it is not relational, it is flat file. Each month, the old data is completely wiped out and the updated Excel spreadsheet is then loaded into the database. This happens each month for each of the grants (4) currently. I have attached the spreadsheet for one of the grants (dummy data inserted) so that you see what I get each month. Each grant has a unique number that is associated with that grant and that grant alone. So, each month I go in and wipe out the data from the previous month and then load from the Excel spreadsheet current and updated info.
So, to my question, what would be the best way for me to do things in Alpha 5 instead of Access, I would love just to load the database once with all the data for all the grants and when I receive a new spreadsheet with new and updated data, just be able to append or update what is already there.
I know this is long, but is it worth doing in Alpha or just keep on doing what I am doing with the Access database I have.
Thanks,
Ben
Here is my situation and I need advice from all you Alpha Guru's out there. I just purchased Alpha 5 V9 and am starting to learn. I have inherited an Access Database that was created a while back that keeps track of student information for our Skills Development Grants. What I get is an Excel Spreadsheet containing new and updated info on the students (a new version each month that shows any new students, classes they took, how many hours, etc. as well as old students that might have taken or finished a course or might have been terminated, etc.). The Access database is the repository for the data, it is not relational, it is flat file. Each month, the old data is completely wiped out and the updated Excel spreadsheet is then loaded into the database. This happens each month for each of the grants (4) currently. I have attached the spreadsheet for one of the grants (dummy data inserted) so that you see what I get each month. Each grant has a unique number that is associated with that grant and that grant alone. So, each month I go in and wipe out the data from the previous month and then load from the Excel spreadsheet current and updated info.
So, to my question, what would be the best way for me to do things in Alpha 5 instead of Access, I would love just to load the database once with all the data for all the grants and when I receive a new spreadsheet with new and updated data, just be able to append or update what is already there.
I know this is long, but is it worth doing in Alpha or just keep on doing what I am doing with the Access database I have.
Thanks,
Ben
Comment