But it looks like you've figured out how to create and delete tables in code. There is a section of the MS Access help called the JET SQL Reference (or similar) that gives a brief overview of the ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

However, writing SQL code can be tedious, repetitive, and error-prone, especially when you need to perform similar tasks or calculations across different tables, views, or queries.