Data Management Exam 2
feature that enables you to quickly sort and display field values in various ways
autofilter
________ ___ a database is the process of making a copy of the database file to protect your database against loss or damage
backing up
a field that displays the results of an expression
calculated field
The _________ _______ for a field specifies how the field name is displayed in a database objects, including table and query datasheets, forms, and reports
caption property
If you choose this option, Access deletes the record in the primary table and also deletes all records in related tables that have matching foreign key values
cascade delete related records option
If you use this option, access permits the change in value to the primary key and changes the appropriate foreign key values in the related table
cascade update related fields option
__________ a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly
compacting
a software program that lets you create databases and then manipulate data in most of them
data management system (DBMS)
determines what field values you can enter for a field
data type
a collection of related tables
database
an access tools that makes it easy for you to create an expression
expression builder
T/F: A field in one table that establishes a relationship to another table is called a redundant field.
false
T/F: A field name must be unique within a database.
false
T/F: A group of related fields is known as data redundancy.
false
T/F: A primary key in one table cannot be used as a foreign key in a different table.
false
T/F: Every table defined in Access must have a single field that serves as its primary key.
false
T/F: Like spreadsheets, a DBMS can handle massive amounts of data and can easily form relationships among multiple tables.
false
a single characteristic or attribute of a person, place, object, event, or idea
field
the specific value, or content, of a field
field value
a set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records
filter
a technique for filtering records that changes your datasheet to display blank fields
filter by form
a technique for filtering records that lets you select all or part of a field value in a datasheet or form, and then display only those records tat contain the selected value in the field
filter by selection
allows you to search a table or query datasheet, or a form, to locate a specific field value or part of a field value
find command
when you include the primary key from one table as a field in a second table to form a relationship between the two tables
foreign key
the process of relating tables
join
in this view, you can make design changes to the form while displaying its data, so that you can see the effects of the changes you make immediately
layout view
A sort field is ______ if more than one record can have the same value for the sort field
nonunique
a field, or a collection of fields, whose values uniquely identify each record in a table
primary key
a set of field values
record
a set of rules that Access enforces to maintain consistency between related tables when you update data in a database
referential integrity
data is organized as a collection of tables
relational database management system
the field used to determine the order of records in the datasheet
sort field
the process of rearranging records in a specified order or sequencce
sorting
a collection of fields that describes a person, place, object, event, or idea
table
a pre-designed database that includes professionally designed tables, reports, and other database projects
template
T/F: A collection of fields describing a person, a place, an object, an event, or an idea is a table.
true
T/F: A collection of related tables is called a relational database.
true
T/F: A common field is a field that is defined as a primary key in one table and is defined as a foreign key in a second table.
true
T/F: A database is a collection of related tables.
true
T/F: A primary key that consists of more than one field is called a composite key.
true
T/F: A relational DBMS controls the storage of databases on disk and facilitates the creation, manipulation, and reporting of data.
true
T/F: A single set of field values within a table is a record.
true
T/F: Although a field has unique values in the table in which it is the primary key, it does not have to have unique values in the table in which it is the foreign key.
true
T/F: It's best to choose a field or object name that describes the purpose or contents of the field or object so that later you can easily remember what the name represents.
true
T/F: More than one user can enter data into a database.
true
T/F: Primary keys uniquely identify records in a table.
true
T/F: Redundant fields waste storage space and can result in inconsistent data within the database.
true
T/F: When designing a database, the first thing you should do is identify the fields that will be required.
true
T/F: You connect the records in separate tables through a common field that appears in both tables.
true
A sort field is _______ if the value in the sort field for each record is different.
unique
the process of adding, modifying, and deleting records in database tables to keep them current and accurate
updating
a dialog box that you can use to enter text, expressions, or other values
zoom box
