I have a personal MS Access 2010 database that contains a user table (approx 900 people) that I populate by pulling user data from AD. It also contains asset data (mainly IT equipment ~ 7500 assets +/-).
I would like to be able to provide users with a form that they can review the assets that are currently assigned to them, or located in their current office / workspace. (Standard office equipment such as dock, monitor, printer & scanners is assigned to the workspace & does not move with users, user usually has a laptop & cell phone assigned to them)
I would like to initiate the review, by an email or other trigger. The user would view the assets and either confirm or correct the asset ID for each item. Perhaps by scanning the items asset tag barcode or checking a checkbox on the form by each barcode. Any user corrections would be accumuilated in a temp table so they could be validated and pushed to the source tables as updates.
I am not sure what the best method is: Infopath form, Outlook Form, etc.
I am looking for suggestions and an outline of the implementation steps.
Thanks for any suggestions.