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