I am creating an access database for some users who are new to Access 2010. The process imports a bunch of records from excel into the database. However, I need to give them an easy way to view any records that error. Along with the ability to update or delete the records. I've created a query to gather this informaiton for them. The question is how would it be best to have them view this information? I have a form that has a button to do the importing and then I thought about a couple of buttons for error reporting.
Reports don't seem to allow deleting. However, I also don't know a way to pop up the results of the select query that I have created.
Any thougths or ideas on how best to do this? I would like to make this as easy as possible for them. However, if they are going to maintain this thing they need to learn how to use it as well. I'm tempted to have them just manually run the queries.