I've done alot of work with Access in college but thankfully... I've forgotten most of it! (",)
I would imagine that a form that would call a query or two, would be the best way to go about it. Shouldn't require any scripting at all. Sorry I can't be of more help.