More Database Terms

Queries: Queries make changes to or move many records in just one operation. You can use SQL to query, update and manage relational databases such as Microsoft Access.

Forms: A form is a type of database object, that is primarily used to enter or display data in the database. Data comes from the fields in the underlying record source.

Macro: A macro is a set of one or more actions and each performs a particular operation, such as opening a form or printing a report. Macros can help you to automate common tasks. For example, you can run a macro that prints a report when a user clicks a command.

Module: A module is essentially a collection of declarations, statements, and procedures stored together as one named unit. Microsoft Access has two types of modules. They are standard modules and class modules. Form and Report modules are class modules, that are not associated with any other object, and frequently used procedures that can be run from anywhere within the database.