Module 2

Question 1

Composite Key

Answer 1

A primary key that consists of two or more fields.

Question 2

data redundancy

Answer 2

A condition that occurs when you store the same data in more than one place; it wastes space and can cause inconsistencies.

Question 3

properties

Answer 3

The characteristics of each field in a table.

Question 4

Cascade Delete Related Records option

Answer 4

An option you can set to enforce the referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that have matching foreign key values.

Question 5

set

Answer 5

To select or enter a value for a property of a field.

Question 6

Field Size property

Answer 6

The property that defines a field’s maximum storage size for Short Text, Number, and AutoNumber fields.

Question 7

Byte

Answer 7

The Field Size property that stores whole numbers from 0 to 255 in one byte.

Question 8

Integer

Answer 8

The Field Size property that stores whole numbers from -32,768 to 32,767 in two bytes.

Question 9

Long Integer

Answer 9

The Field Size property that stores whole numbers from -2,147,483,648 to 2,147,483,647 in four bytes.

Question 10

Single

Answer 10

The Field Size property that stores positive and negative numbers to precisely seven decimal places in four bytes.

Question 11

Double

Answer 11

The Field Size property that stores positive and negative numbers to precisely 15 decimal places in eight bytes.

Question 12

Replication ID

Answer 12

The Field Size property that establishes a unique identifier for replication of tables, records, and other objects in databases created using Access 2003 and earlier versions in 16 bytes.

Question 13

Caption property

Answer 13

A field property that specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports.

Question 14

Decimal

Answer 14

The Field Size property that stores positive and negative numbers to precisely 28 decimal places in 12 bytes.

Question 15

Decimal Places property

Answer 15

The property that specifies the number of decimal places that are displayed to the right of the decimal point.

Question 16

entity integrity

Answer 16

The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in every record in the table.

Question 17

null value

Answer 17

The value that results from not entering a value for a field; a null value is not permitted for a primary key.

Question 18

keyboard shortcut

Answer 18

A key or combination of keys you press to complete an action more efficiently.

Question 19

import

Answer 19

A process that allows you to copy the data from a source, without having to open the source file, and to add the imported data in an Access table.

Question 20

Data Type gallery

Answer 20

An Access tool that allows you to add a group of related fields to a table at the same time, rather than adding each field individually.

Question 21

Quick Start selection

Answer 21

The name given to the group of fields you add to a table at the same time using the Data Type gallery.

Question 22

Address Quick Start selection

Answer 22

The Quick Start Selection that adds a collection of fields related to an address to the table at one time.

Question 23

Default Value property

Answer 23

The property that specifies what value will appear, by default, for a field in each new record you add to a table.

Question 24

delimited text file

Answer 24

A type of text file in which fields of data are separated by a character such as a comma or tab.

Question 25

join

Answer 25

To relate tables using a common field.

Question 26

orphaned record

Answer 26

A record whose matching record in either the primary or related table has been deleted.

Question 27

Referential integrity

Answer 27

A set of rules that Access enforces to maintain consistency between related tables when you update data in a database.

Question 28

Cascade Update Related Fields option

Answer 28

An option you can set to enforce the referential integrity rule that permits a change in value to the primary key and changes the appropriate foreign key values in related tables.