Also look at SQL::Abstract to write the sql for you (i haven't tried personally, but it should alsmost certainly handle quoting the table names).

Also look at Class::DBI -- another way to avoid writing sql and also making easy-to-write powerful code.

random info -- in other databases you can quote the table names with backticks (no clue if that works w/access)