Top Level Objects

An object to define and store data. It is a collection of fields (columns) and records (rows), the cells (intersections) of which are used to define and store instances about a particular subject. Tables can have a primary key to make each record unique. Tables can utilize indexes to speed data retrieval. Tables are usually prefixed with tbl.
An object that uses Access' graphical QBE (Query By Example) or SQL statements to select, update, insert, or delete data from table(s) and/or one or more other queries. Queries are usually prefixed with qry.
An object to ease user data input, data display, and application interface. Forms can facilitate the generation of events that execute macros or procedures written in VBA. Forms are usually prefixed with frm. If used in VBA as a class, the name of the class for a specific form will follow this syntax: Form_frmName.
An object for formatting, calculating, printing, and summarizing queried data. Reports are usually prefixed with rpt. If used in VBA as a class, the name of the class for a specific report will follow this syntax: Form_rptName.
An object which structures specific actions in response to specific conditions or events, such as printing a report when a button is pressed. Macros are usually prefixed with mcr.
An object holding a custom mini-program written in VBA (Visual Basic for Access). Modules have more abilities than macros, including the ability to be stand-alone objects and the ability to respond to a greater variety of events. Modules are usually prefixed with mod.

Other Objects

  • Fields
  • Indexes
  • Controls

GeorgeHernandez.comSome rights reserved