Access Chapter 1

Wizard

Step by step process.

Primary Key

The field in a table that uniquely identifies a record.

Table

The foundation of a database.

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.

Normalization

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

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.

Export

The process of copying data from one file into another file, such as an Access table into an Excel spreadsheet.

Record selector box

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

Data source

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

Destination Table

The table to which you import or append data.

Append

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

Truncated

Trun

Source file

When importing a file, refers to the file being imported.

Database management system

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

SharePoint

A Microsoft application used for setting up websites to share and manage documents.

Server

A computer that provides services on a network such as an email server or a file server.

Link

A connection to data in another file.

Tables and Related views

An arrangement in the Navigation Pane.

Database

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

Simple select query

Another name for a select query.

Field properties

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

Information

Data that is organized in a useful manner.

Object window

An area of the Access window that displays open objects, such as tables, queries, forms, or reports.

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.

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.

Report

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

Blank desktop database

A database that has no data and has no database tools.

Custom web app

A database that you can publish and share with others over the internet.

Common field

A field in two or more tables that stores the same data.

Multiple- items form

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

Single record form

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

Property Sheet

A list of characteristics properties for fields or controls on a form or report in which you can make precise changes to each property associated with the field or control.

Database template

A preformatted database that contains prebuilt tables, queries, forms, and reports that perform a specific task, such as tracking events.

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.

Second principle of good database design

A principle stating that appropriate database techniques are used to ensure the accuracy and consistency of data as it is entered into the table.

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.

Flat database

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

Field

A single piece of information that is stored in every record; represented by a column in a database table.

Relational database

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

Secure environment

A system that uses controlled servers ti ensure the security and privacy of email, to control the storage and use of information and to protect against the loss of confidential data.

Select query

A type of Access query that retrieves data from one or more tables or queries, displaying the selected data in a datasheet.

Record

All of the categories of data pertaining to one person, place, event, thing or idea.

Best Fit

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

Currency data type

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

Number data type

An Access data type that describes numbers that might be used in calculations.

Short 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 Postal Code.

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.

Design view

An Access view that displays the detailed structure of a table, query, form, or report.

DBMS

An acronym for database management system.

Navigation area

An area at the bottom of the Access window that indicates the number of records in the table and contains controls in the form of arrows that you click to navigate among the records.

Navigation Pane

An area of the Access window that displays and organizes the names of the objects in a database.

Data

Facts about people, events, things, or ideas.

Structure

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

Redundant

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

Object tab

In the object window, a tab that identifies the object and which enables you to make the open object active.

Layout view

The Access view in which you can make changes to a form or report while the object is open

Form view

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

Datasheet view

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

Populate

The action of filling a database table with records.

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.

Objects

The basic parts of a database that you create to store your data and to work with your data.

Data type

The characteristic that defines the kind of data that can be stored in a field, such as numbers, text, or dates.