Depends on what version you’ve got today. According to Wikipedia, Apple Silicon support was introduced in version 19.3.2 (July 2021). If you’ve got an installation of 18 or older, then it will break when Rosetta goes away.
It’s been a long time since I worked with Access, but the last time I looked, it is a GUI wrapper around an SQL engine. Not (conceptually) any different any other SQL-based solution, including LibreOffice Base (which can connect to external open source database systems like MariaDB, MySQL or Postgress).