The Components of Access
|
| Object |
Primary
Purpose |
| Tables |
- Hold data in a structured manner.
- Alternatively act as conduits to external data
sources
- In general, tables in a database should be normalised
and thus have Relationships
Note: Datasheet view in tables allows easy browsing and
management of data (searching, sorting, filtering, deleting,
appending....) |
| Queries |
- Store re-useable questions (does not change original
data) or
- Store re-useable processing actions (changes data)
- Cannot perform itemised as well as summarised
retrieval - use Reports.
- Can be used as the source for further Queries.
|
| Forms |
- Present data for editing (allows much more control
for the author/developer than just using tables).
- Act as a canvas to place Controls (labels, text
boxes, buttons and the like).
- Hold VBA programming code in Class Modules.
|
| Reports |
- Preview or Print nicely formatted reports.
- Combine itemised and summary information for
printing.
|
| Macros |
- The novice or the quick method of automating Access.
- Hold customised menu instructions.
|
Stand alone and
Code Behind Forms
Modules |
- Hold VBA programming code which is calleable
throughout the database
|
