bigoldalphamale

i am doing an assigment for school and i cant figure out the best way to do the following:

Basic query writing skills..write a query to be able to look up data in a database. For example, select, cross tab, make table, and append.

can someone describe how i would do these things please?

is this as easy as:

1) select table or database
2) cross tabulate two or more pieces of data from the table or database
3)make a table from the crosstabulated data
4)'append' ...no clue what to do here. does this mean add it to another database or table, maybe?

HELP!!!!