Yes, you can certainly import your MS Access data into Airtable!
You will first need to export the data as a .csv file and import it into a new database or a new table in an existing base. For more on how to do this, please see the articles titled "Import an Existing Spreadsheet or CSV into a New Base" and/or "Importing a CSV into a New Table in an Existing Base," respectively.
If you have multiple tables that you would like to import, you can import them into separate tables in your base.
Please note that there is currently a 2mb limit on .csv uploads.