To view Access queries in SQL rather than Access query design - open the query design window and change the view to SQL:

Select Statement
SELECT [column_name] FROM [table_name];

Append Statement
INSERT INTO [table_name] ([column1], [column2], [column3])
VALUES ('value1', #value2#, value3);

This assumes value1 is a string, value2 is a date and value 3 is some other datatype
...