Spent some time reading some posts, but my problem seems pretty specific. Having never really used access before (other than the ~15 hours spent working on this project), i think its time i asked for help.
I'm secretary for my organization and would like to completely overhaul our current system. I would like to change our current setup of having one excel spreadsheet of member information and a completely seperate sharepoint contacts table, and instead have a master database of all of member's information and a linked sharepoint contancts table. This is how i envision it working.
-I email out a form, then they fill it out and it is automatically saved to the database.
-Certain fields are automatically added to the contacts database.
-The contacts database is synced with a sharepoint contacts database for people to download to outlook.
Each of the steps seem simple on their own, but i can't figure out how to do it all. They don't need to be done automatically, but the more automation the better.
The form is easy enough, no questions there.
I'm unsure as to how to link only certain fields in a table. I can create a query to find the fields and create that, but that doesn't get me anywhere since it has to be added into a table, not a query.
I could simply create a linked table, but then when it is uploaded to sharepoint, it shows up as a table, and not a contacts list. In order to get it to play nicely with outlook, i need to create the contacts db in sharepoint, then download it and open it with access. Then i can't seem to link the contacts after it has already been created.
If i need to clarify something, just let me know. I'm using Access 2010. I have quite a bit of experience with VBA in excel, but access seems quite a bit different and would rather not have to get into it unless it was necessary, in which case i would need some of direction.
Any help would be very much appreciated. It's my last year in the organization, and i would like to leave this as my legacy to help out all the other secretaries to come after me.