Fetching data at regular intervals from a a Query

SaeedR 

"...There is this Virtual windows that I login..."

Are you talking about a Virtual Machine running the Windows Operating System?

".. i usually click on a rewritten Query" 

Please elaborate on what that looks like. What does it mean to say you "click on a rewritten Query"? What is a "rewritten Query" and how does that differ from just an ordinary query? Where is that query? I assume it must be in an Access accdb?  How do you find it to click on it? Do you open the accdb and click it in the Navigation Pane? Or....?

For the rest of your questions, the answer is that you certainly can write code which runs an append or update query at regular intervals. The details are, of course, far more complicated than one could guess at from this overview. 

In general, though, you can open a form with a timer on it. Set the Timer interval to 1000, which is the equivalent of 1,000 milliseconds, or 1 second. In the On Timer event write the code to run your query each time the timer reaches 1 second.  That seems very, very, frequent to me, but only you know the reason for doing it in your environment.

You can find the Access version under File-->Account.