Quiz #1 - Database Management

Related table

The "many" table in a one-to-many relationship

Primary Table

The "one" table in a one-to-many relationship.

Layout view

The Access view in which you can make design changes to a form so that you can immediately see the effects of changing the design.

Datasheet view (for a table)

The Access view that shows a table's contents as a datasheet in rows and columns.

Design view (for a table)

The Access view you use to define or modify a table structure or the properties of the fields in a table.

Relationship Window

The Access window in which you define and view the relationships among a database's tables.

Single

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

Long integer

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

Backstage view

The File tab of the ribbon, which provides access to file-level options and program settings.

Navigation pane

The area on the left of the Access program window that lists all the objects in the database and is the main control center for opening and working with database objects.

Entity Integrity

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.

ID field

The default field Access creates to serve as the primary key field for all new tables.

Datasheet

The display of a table's contents in rows and columns, similar to a table or spreadsheet; each row is a separate record in the table, and each column contains the field values for one field in the table.

Data type

The field property that determines what field values you can enter for the field and what other properties the field will have. Examples: short text, number, or currency.

Description property

The optional property you can use to enter a description for a field to explain its purpose or usage.

Field Properties Pane

The part of the Table window in Design view that contains the properties for the selected field.

Table Design Grid

The part of the Table window in Design view that contains the values for the Field Name, Data Type, and Description field properties.

Field property size

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

Decimal place property

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

Default value property

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

Field value

The specific value, or content, of a field in a record.

Star symbol

The symbol that appears in a row selector to indicate that the row is the next one available for a new record.

one-to-many relationship

The type of database relationship that exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when one record in the second table matches at most one record in the first table.

Null value

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

Join and join line

To join or relate tables using a common field. In the Relationships Window, the line that connects the common field that joins two tables.

Table

a collection of fields that describes a person, place, object, event, or idea

Primary key

a field, or a collection of fields, whose values uniquely identify each record in a table

Import

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.

Cascase Delete Related Records Option

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.

Report

formatted printout or screen display of the contents of one or more tables in a database

Datasheet selector

the box in the upper-left corner of a datasheet that, when clicked, selects all fields and records in the datasheet

Properties

the characteristics of each field in a table.

Double

the field size property that stores positive and negative numbers to precisely 15 decimal places in eight bytes.

Byte

the field size property that stores whole numbers from 0 to 255 in one byte.

Field list

A box listing the fields contained in a table in the order in which they appear.

Show Table Button

A button on the Relationship Tools Design tab that you click to open the Show Table dialog box, from where you can add tables to the Relationships window.

Database

A collection of related tables stored in the same file.

relational database

A collection of related tables stored in the same file.

Record

A complete set of field values for a specific person, place, object, event, or idea.

data redundancy

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

Form

A database object you can create and customize to maintain, view, and print records in a database in different and useful ways.

Microsoft Access 2016

A database program you use to enter, organize, display, and retrieve related information.

Caption property

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

common field

A field that appears in more than one table, allowing you to connect the records in the separate tables.

Foreign key

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

Composite key

A primary key that consists of two or more fields.

Compacting

A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly. Enhances the performance of the database

Query

A question you ask about the data stored in a database. In response, Access displays the specific records and fields that answer your question.

Navigation Buttons

A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table.

Referential Integrity

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

Field

A single characteristic or attribute of a person, place, object, event, or idea.

relational database management system

A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.

Database Management System (DBMS)

A software program that lets you create databases and then manipulate data in them.

Create tab

A tab on the ribbon that provides options for creating various database objects, including tables, forms, and reports.

Delimited text file

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

Short text

An Access data type that allows field values containing letters, digits, and other characters.

AutoNumber

An Access data type that automatically assigns a unique number to a record.

Form wizard

An Access tool that asks you a series of questions, and then creates a form based on your answers.

Query wizard

An Access tool that asks you a series of questions, and then creates a query based on your answers.

Report Wizard

An Access tool that asks you a series of questions, and then creates a report based on your answers.

Form tool

An Access tool that creates a form containing all the fields in the table or query on which the form is based.

Report tool

An Access tool that places all the fields from a table or query on a report.

Simple Query Wizard

An Access wizard that lets you quickly select the records and fields to display in a query datasheet.

Cascade Update Related Fields option

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.

Integer

Field size property that stores values from -32,768 to 32,767 in two bytes.

Click to add column

In Datasheet view for a table, the datasheet column you can use to create a new field in the table.

Field selector

In a datasheet, the column heading (also called the column selector)that you click to select the entire column.

column selector

In a datasheet, the column heading (also called the field selector) that you click to select the entire column.

row selector

In a datasheet, the small square at the beginning of a row (also called the record selector), which you click to select the entire row.

Record selector

In a datasheet, the small square at the beginning of a row (also called the row selector) that you click to select the entire row.

Backing up

Making a copy of a database file to protect your database against loss or damage.