access Flashcards

1
Q

datatype

A

a field property in access that determines the type of data a database field can store.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

database

A

A collection of related information organized for rapid search and retrieval.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

datasheet

A

A database table that stores subject-based data; the primary object in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

entry

A

Data entered in a datasheet cell.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

field

A

In Access, a single piece of database information, such as a first name, a last name, or a telephone number; in Word, an indication of a location in which variable text
or data can be inserted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

field name

A

A label that helps identify the field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

field properties

A

Definitions of the characteristics of and behavior of a database field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

primary key

A

Unique identifier of each record in an Access table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

record

A

A group of related fields in a database, such as all the contact information for an individual

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

relational database

A

A database in which information is organized into separate subject-based tables, and the relationship of the data in one or more tables is used to bring the data together

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

query

A

A database object which allows you to organize, summarize, and print all or a portion of the data in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

report

A

A database object which enables you to locate multiple records matching specified criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly