vba317: Your question raises two issues: First, the records in Access tables do not need to be ordered in tables; any order is fine. When you need to pull record data out (e.g. for forms, reports), you use sorting in either queries or in report design.
Secondly, as to "writing an append query," I am not sure your intentions. If creating one in query Design mode, just use the Help features; explanations are readily available. If you are trying to create an append query using code in a module, then I recommend you Dimension (dim) a variable as String, maybe call it qSQL. Then assign the sql statement for append query to the variable. Then the next line of code can be DoCmd.RunSQL qSQL.
Jeff