Rule of Thumb:
TABLES - Store the data. Don't make your users work directly in tables.
QUERIES - manipulates data into information
FORMS - presents all information to the user and allows data entry
REPORTS - makes hardcopy of the information
MODULES - stores code for things that you cannot do using queries