using a temp table to add date to main table

[ntambomvu]

Hello chaps,


I am a newdie and am working my way through steve bishops tutorials on ms access
In lesson 15 entitled "Make table and insert queries " he is showing how to add a record to the
main table by first creating a temp table and then adding the new row in the temp table
by appending it to the main table.
To me--(imyi) it seems a long way around when one could just add a new row to the
main table directly.
could someone please tell me why this roundabout way is used?
best regards and thank you
fred

[moke123]

I believe in the first part of the video he is demonstrating a make table query and in the second he is demonstrating an insert query.
I don't think he means to use them together, he just happens to use the made table in the second part of the lesson.

could someone please tell me why this roundabout way is used?

There are instances where you might use them together however. One being importing data into a temp table to clean it up before
appending it to your main tables.

[ntambomvu]

thank you-- now it is clear!!
regards

fred