computer concepts access 1
25 test answers
Unlock all answers in this set
Unlock answers 25question
table
answer
the database object that stores the data, and which is the foundation of an Access database
Unlock the answer
question
record
answer
a table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea
Unlock the answer
question
field
answer
a single piece of information that is stored in every record and represented by a column in a table
Unlock the answer
question
first principle of good database design
answer
a principle stating that data a organized in tables so that there is no redundant data
Unlock the answer
question
second principle of good database design
answer
a principle stating that techniques are used to ensure the accuracy of data entered into a table
Unlock the answer
question
normalization
answer
the process of applying design rules and principles to ensure that a database performs as expected
Unlock the answer
question
common field
answer
a field in one or more tables that stores the same data
Unlock the answer
question
objects
answer
the basic parts of database; for example tables, forms, queries and reports
Unlock the answer
question
navigation pane
answer
the window area that organizes the database objects and from which you open objects
Unlock the answer
question
object window
answer
the window area that displays each open object on its own tab
Unlock the answer
question
populate
answer
the action of filling a database with records
Unlock the answer
question
datasheet view
answer
the access view that displays data in columns and rows like an Excel worksheet
Unlock the answer
question
data type
answer
the characteristic that defines the kind of data you can enter into a field
Unlock the answer
question
record selector box
answer
the box at the left of a record datasheet view that you click to select an entire record
Unlock the answer
question
append
answer
to add on to the end of an object, such as to add records to the end of an existing table
Unlock the answer
question
field properties
answer
characteristics of a field that control how the field displays and how data is entered
Unlock the answer
question
primary key
answer
the field that uniquely identifies a record in a table is known as the
Unlock the answer
question
structure
answer
the underlying design of a table is referred to as the
Unlock the answer
question
query
answer
the object that retrieves specific data and then displays only the data that you specify is a
Unlock the answer
question
report
answer
the object that displays fields and records from a table or query in a printable format is a
Unlock the answer
question
redundant
answer
information repeated in a database in a manner that indicates poor design is said to be
Unlock the answer