VBA LESSON 118 - SQL - CREATE TABLE
englishspacedog YouTube tutorial from Canada
http://www.herostratus.ca/PC.htm
You can execute SQL commands from Access VBA.
If you are interested in SQL, I have an SQL video series starting here:
• SQL 101 - CREATE TABLE and INSERT INTO