InfoPath Dev

Is it possible to requery on a timed interval without having to click "refresh"?  And when making the second connection, I want to have the most recent entry seen instead of the entire list or the first entry into the table, how would I go about that? Thank you very much.

What would be the code necessary to keep infopath updated/ synced with access. As we are writing into the access db we wanted to have it be reflected in infopath. How would we go about this? Thank you.

 Thanks, do you know if there is anywhere I could get helpful tips for the coding. I have some background in VB but only a semester worth.

I need to create a GUI that will have pop ups upon clicking on certain items. Is there a way to have pop ups that are more visually appealing than the error/other message boxes? Is it possible to put in  pictures?