Lesson 22: Getting Started with Access Essentials Flashcards

1
Q

Data Type

A

A field property in acces 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 store subject based data; a 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 database cell

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

field

A

In Accses a single piece of database information, such as a first name, a last name, or a telephone number

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

Defination of hte characteristics 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 realted field in a database, such as all the contact inforamtion 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 inforamtion is organized into seperate subject-based tables, and the relationship of hte 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

table

A

A datasheet that store subject-based data. It is a primary object an Access database

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