computer concepts access 1

question

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

Get instant access to
all materials

Become a Member