1. Fields: the smallest data element of a table, such as first name, last name,
address, or phone number.
2. Records: a group of related fields representing one entity, such as data for one
person, place, event, or concept.
3. Tables: An object used to store and organize data in a series of records (rows)
with each record made up of a number of fields (columns) and is the foundation of
every database.
4. Databases: A collection of data organized as meaningful information that can be
accessed, managed, stored, queried, sorted, and reported.
5. Forms (object): a database object that is used to add, edit or delete table data.
6. Reports (object): An object that contains professional-looking formatted informa-
tion from underlying tables or queries.
7. Macros (object): A series of actions that can be programmed to automate tasks.
8. Modules (object): An object that is written using Visual Basic for Applications
(VBA) and adds functionality to the database.
9. Queries (object): Enables you to create queries; the Design view is divided into
2 parts - top portion displays the tables and the bottom portion (known as the query
design grid) displays the fields and criteria.
10. Structured Query Language (SQL): The industry-standard language for defin-
ing, manipulating, and retrieving the data in a database.
11. Calculated Field: Produces a value from an expression or function that refer-
ences or more existing fields.
12. Caption Property: Used to create a more readable label that appears in the top
row in Datasheet view and in forms and reports.
13. Compact and Repair: An Access utility that reduces the size of the database
and can repair a corrupt database.
14. Composite Key: Primary key that is made of 2 or more fields.
1 G/ G
3
address, or phone number.
2. Records: a group of related fields representing one entity, such as data for one
person, place, event, or concept.
3. Tables: An object used to store and organize data in a series of records (rows)
with each record made up of a number of fields (columns) and is the foundation of
every database.
4. Databases: A collection of data organized as meaningful information that can be
accessed, managed, stored, queried, sorted, and reported.
5. Forms (object): a database object that is used to add, edit or delete table data.
6. Reports (object): An object that contains professional-looking formatted informa-
tion from underlying tables or queries.
7. Macros (object): A series of actions that can be programmed to automate tasks.
8. Modules (object): An object that is written using Visual Basic for Applications
(VBA) and adds functionality to the database.
9. Queries (object): Enables you to create queries; the Design view is divided into
2 parts - top portion displays the tables and the bottom portion (known as the query
design grid) displays the fields and criteria.
10. Structured Query Language (SQL): The industry-standard language for defin-
ing, manipulating, and retrieving the data in a database.
11. Calculated Field: Produces a value from an expression or function that refer-
ences or more existing fields.
12. Caption Property: Used to create a more readable label that appears in the top
row in Datasheet view and in forms and reports.
13. Compact and Repair: An Access utility that reduces the size of the database
and can repair a corrupt database.
14. Composite Key: Primary key that is made of 2 or more fields.
1 G/ G
3
