I work for a university and maintain a student database in Access.
We currently use Formstack (a vendor) to create forms in order to collect data from students. This is our only source of data. I then import data via excel into Access. I'm finding this process cumbersome as I have to alter field names to match access and then have to double check who I have imported already.
I am an amateur Access user. I was wondering could we make the databse web based and give students access to their record to fill in their information? What are the pros and cons? My employer does not provide technical support.
Thanks.