Having a table with tens of records: Honda, Toyota, Lexus, e.t.c
Required to create a table for each record and to link ID of each table to that record.
Sure it can be done. You can create tables in Access via code and dynamically add fields. So you can read your current table and break that into multiple tables. Can you explain the purpose?