Access SQL

How one looks at the Access SQL is a bit different because the form using to different terminologies in visually building a query.

Append: This means use a 'INSERT INTO'

I need to learn more about how the graphical build tools work in Access.

In specifying the query using the graphical interface you must specify at least one 'destination field.

From the Access Query From one can select either

• Select Query
• Update Query
• Append Query

In addtion on can select the following additional queries.

• Crosstab Query
• Make-table Query
• Delete Query

In creating a query on can use the ‘Design View’ or one of the following query wizards:

• Simple Query Wizard
• Crosstab Query Wizard
• Find Duplicates Query Wizard
• Find Unmatched Query Wizard