Access Chapter 1 Flashcards
a filtering method that displays only records that match the selected criteria
selection filter
a filtering method that displays records based on multiple criteria
filter by form
a main component that is created and used to make a database function, such as a table or form
object
a method of listing records in a specific sequence (such as alphabetically)
sort
a predefined database that includes professionally designed tables, forms, reports and other object
template
a question in ask about the data in your database
query
an access interface element that organizes and lists database objects in a database
navigation pane
an access object that simplifies entering, modifying, and deleting table data
from
a set of common access components that can be added to an existing database
application part
an object that contains profession-looking formatted information from underlying tables or queries
report
an object used to store data, organizing data into columns and rows
table
complete set of all the fields about one person, place, event or concept
record
the field (or combination of fields) that uniquely identifies each record in a table
primary key
view that enables you to create and modify a table design
design view
a collection of data organized as meaningful information that can be access, managed, stored, queried, sorted and reported
database
