Advertisement Upgrade to remove ads

GO! Text pg. 460

Append

To add on to the end of an object; for example, to add records to the end of an existing table

AutoNumber Data Type

A data type that describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique

Best Fit

An Access command that adjusts the width of a column to accommodate the column's longest entry

Blank Database

A database that has no data and has no database tools- you must create the data and the tools as you need them

Caption

A property setting that displays a name for a field in a table, query, form, or report other than that listed as the field name

Common Field

A field in one or more tables that stores the same data

Currency Data Type

An Access data type that describes monetary values and numeric data that can be used in mathematical calculations involving data with one to four decimal places

Data

Facts about people, events, things, or ideas

Data Source

The table or tables from which a form, query, or report retrieves its data

Data Type

The characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates

Database

An organized collection of facts about people, events, things, or ideas related to a specific topic or purpose

Database Management System (DBMS)

Database software that controls how related collections of data are stored, organized, retrieved, and secured; also known as DBMS

Database Template

A preformatted database designed for a specific purpose

Datasheet View

The Access view that displays data organized in columns and rows similar to an Excel worksheet

DBMS

Database software that controls how related collections of data are stored, organized, retrieved, and secured

Design View

An Access view that displays the detailed structure or a query, form, or report; for forms and reports, may be the view in which some tasks must be performed, and only the controls, and not the data, display in this view

Destination Table

The table to which you import or append data

Field

A single piece of information that is stored in every record and formatted as a column in a database table

Field Properties

Characteristics of a field that control how the field displays and how data can be entered in the field

First Principle of Good Database Design

A principle of good database design stating that data is organized in tables so that there is no redundant data

Flat Database

A simple database file that is not related or linked to any other collection of data

Form

An Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records

Form View

The Access view in which you can view the records, but you cannot change the layout or design of the form

Import

The process of copying data from another file, such as a Word table or an Excel workbook, into a separate file, such as an Access database

Information

Data that is organized in a useful manner

Layout View

The Access view in which you can make changes to a form or report while the object is running--the data from the underlying data source displays

Link

A connection to data in another file

Multiple Items Form

A form that enables you to display or enter multiple records in a table

Navigation Area

An area at the bottom of the Access window that indicates the number of records in the table and contains controls (arrows) with which you can navigate among the records

Navigation Pane

An area of the Access window that displays and organizes the names of the objects in a database; from here, you open the objects for use

Normalization

The process of applying design rules and principles to ensure that your database performs as expected

Object Window

An area of the Access window that displays open objects, such as tables, forms, queries, or reports; by default, each object displays on its own tab

Objects

The basic parts of a database that you create to store your data and to work with your data; for example, tables, forms, queries, and reports

Populate

The action of filling a database table with records

Primary Key

The field that uniquely identifies a record in a table; for example, a Student ID number at a college

Query

A database object that retrieves specific data from one or more database objects--either tables or other queries--and then, in a single datasheet, displays only the data you specify

Record

All of the categories of data pertaining to one person, place, thing, event, or idea, and which is formatted as a row in a database table

Record Selector Bar

The bar at the left edge of a record when it is displayed in a form, and which is used to select an entire record

Record Selector Box

The small box at the left of a record in a Datasheet view that, when clicked, selects the entire record

Redundant

In a database, information that is repeated in a manner that indicates poor database design

Relational Database

A sophisticated type of database that has multiple collections of data within the file that are related to one another

Report

A database object that summarizes the fields and records from a table or query in an easy-to-read format suitable for printing

Run

The process in which Access searches the records in the table(s) included in the query design, finds the records that match the specified criteria, and then displays the records in a datasheet; only the fields that have been included in the query design display

Second Principle of Good Database Design

A priciple stating that appropriate database techniques are used to ensure the accuracy of data entered into a table

Select Query

A type of Access query that retrieves (selects) data from one or more tables or queries, displaying the selected data in a datasheet; also known as a simple select query

Simple Select Query

A type of Access query that retrieves (selects) data from one or more tables or queries, displaying the selected data in a datasheet; also known as a select query

Single-Record Form

A form that enables you to display or enter one record at a time in a table

Source File

When importing a file, refers to the file being imported

Structure

In Access, the underlying design of a table, including field names, data types, descriptions, and field properties

Table

A database object that stores data organized in an arrangement of columns and rows, and which is the foundation of an Access database

Tables and Related Views

An arrangement in the Navigation Pane that groups objects by the table to which they are related

Text Data Type

An Access Data type that describes, text, a combination of text and numbers, or numbers that are not used in calculations, such as a number that is an identifier like a Student ID

Truncated

Refers to data that is cut off or shortened

Wizard

A feature in Microsoft Office that walks you step by step through a process

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set