Open up a new query.
Switch to SQL View
Start Typing.
SELECT Field1, Field2, Field3
FROM Table1
UNION
SELECT FieldA, FieldB, FieldC
FROM AnotherTable
UNION
....
Lookup help on Union queries for further information.
Basic guidance:
Same number of fields in each query; Matching field types in each column.
