Queries

The vagaries of dates in queries

Local format in design view, US format in SQL view.

There's no wizard for this, but they can be very useful.

Querying system objects

Make use of the MSysObjects table.

Returning the top n values

How to return a specified number of the highest (or lowest) values in a field.

Querying users and security groups

How to query the workgroup information file for a nice view of which users are in which groups.