I have purchased a copy of Office 2010 Professional including Access 2010, but I am not familiar enough with it yet so I wanted to ask a question before I waste a lot of time chasing my tail.
I want to create a grade entry database for a school. It needs to be set up a particular way, ergo, commercial options are not a choice and I am creating it from scratch. I have been using a rudimentary PHP solution I dislike; however, it gives me the customization I need.
I would like a central, online repository, similar to a MySQL database. It would be in Access format however. It would need to be secured.
From the central Access repository, I would like to have web access to my forms, like the screenshots here: http://msdn.microsoft.com/en-us/library/ff402351.aspx
I would want to limit it so that teachers could only access, modify, and edit data for a pre-populated list of students. They couldn't go change data for another teacher's class, etc. Some sort of filter, I imagine.
I would want this all traveling through an SSL cert as it is FERPA protected information.
Can this be done? I created a nice Access 2007 form to do this prior to my mediocre PHP solution simply because some teachers at the school used MAC computers. If it is online, MAC is not an issue.
What is the performance like? How does it handle? Does it look like an Access form would? Can I add the limitations/filters I talked about?
Who provides Access 2010 hosting if this is a possibility? Data integrity is key. If a teacher wants to delete their data, fine. They cannot be permitted to change or delete data from other teachers, however. It seems like I tried Sharepoint with Access 2010 and it was a disaster as anyone could log in and change the central accmdb file, etc.