Access Flashcards

1
Q

Data Type

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

Data sheet

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

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
8
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
9
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
10
Q

Query

A

Finds and shows data that meet a specified criteria.

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

Report

A

Organizes data in a specific layout.

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

Field Properties

A

Definition of characteristics of and behavior data base field

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