ACCESS CHAPTER 1 GLOSSARY OF TERMS
Asterisk Symbol – appears next the blank record at the end
of every table.
AutoCorrect – feature that automatically expands
Current Record – the record the user is working on.
Data Validation – anticipates errors the user might make
and rejects those errors prior to accepting data.
Database – consists of one or more tables
Database Window – displays the various objects in an Access
Datasheet View – the view used to add, edit, or delete
Design View – used to define the table initially and to
specify the fields it will contain.
Field – a basic fact or data element
Field Name – the first row in the table.
Filter – displays a subset of records from the table
according to specified criteria.
Filter by Form – filtering in which the user specifies
Filter by Selection
– filtering by clicking any cell that contains the desired
Filter Excluding Selection
– displays all records that do not satisfy the specified
Find Command – enables the user to locate a specific record (s)
by searching the table for a particular value.
Form – provides a more convenient and attractive way to
enter, display, and/or print the data in a table.
GIGO (Garbage In, Garbage Out)
– the reality that a system cannot produce valid output with
from invalid input.
Insertion Point – a flashing vertical bar that appears at
the point where the text is being entered.
Macro – analogous to a computer program and consists of
commands that are executed automatically one after the other.
Macros are used to automate the performance of any
a major application in the Microsoft Office that is used to
create and manage a database.
Module – provides a greater degree of automation through
programming in Visual Basic for Applications (VBA).
Relationship – the way in which two tables are linked by a common
Page – is an HTML document that can be posted to a Web
server or Local Area Network, and which can be viewed by a Web
Pencil Symbol - indicates that the user is working on the record
and that the changes have not yet been saved.
Primary Key – a field or combination of fields, which are
unique for every record in the table.
Query – answers a question about the database with the
most common type of query specifies a set of criteria, then
searches the database to retrieve the records that satisfy the
Record – a set of fields
Record Selector Symbol
– a symbol next to the current record to indicate its status.
– tables must be consistent with one another
Database – contains multiple tables and enables the user to
extract information from those tables in a single query.
Remove Filter – by clicking this, the user can display the
Replace Command – incorporates the Find command and allows
the user to locate and optionally replace (one or more
occurrences of) one value with another.
Report – presents the data in a table or query in
attractive fashion on the printed page.
Sort – lists records in a specific sequence.
– type of sort that is more appropriate for non-numeric
Sort Descending – type of sort that is more appropriate for
Table – stores data about an entity and is the basic
element in any database. It
is made up of records and columnar in appearance.
Triangle Symbol – indicates
that the record has been saved to disk.
Undo Command – allows the user to reverse the most recent past
to Main Page