Access is basically single threaded (excluding timers perhaps) so you can put 8 queries into a macro and it will run them one after another, but not at the same time, can't really think of a way to do that.
Create a new Macro and use the OpenQuery macro command, in the arguments area put in the name of your query, repeat the command as many times as necessary.