question

Database

answer

A file that consists of one or more tables and the supporting objects used to get data into and out of the fields

question

Relational database software

answer

a computer application, such as Microsoft Access, that is used to store data and convert it into information

question

Relational database management system

answer

Data are grouped into similar collections, called tables, and the relationships between tables are formed by using a common field

question

Flat or non-relational data

answer

data contained in a single page or sheet

question

Field

answer

a basic entity, data element, or category, such as a book title or telephone number

question

Column

answer

the data field that you assign to group data vertically into columns. Example: First name, last name, address, and phone number

question

Record

answer

a complete set of all of the data about one person, place, event, or idea. Example: All the fields on my class roster about one student.

question

Row

answer

the source field that you assign to group data horizontally in a crosstab query

question

Table

answer

a collection of records

question

Primary key

answer

the field that makes each record in a table unique; ex. Student ID number

question

Foreign key

answer

a field in one table that also is stored in a different table as a primary key

question

Query

answer

a database object that enables you to ask questions about the data stored in a database and returns the answers in the order from the records that match your instructions

question

Form

answer

an interface that enables you to enter or modify record data

question

Report

answer

a printed document that displays information professionally form a database

question

Access speed

answer

the amount of time it takes for the storage device to make the file content available for use

question

Compact and Repair Database Utility

answer

Reduces the size of the database and eliminates wasted space

question

Datasheet view

answer

a grid containing columns and rows where you add, edit, and delete records in a database table

question

Design view

answer

displays the infrastructure of a table, form, or report without displaying the data

question

One-to-many relationship

answer

exists when each record in the first table may match one, more than one, or no records in the second table

question

Cascades

answer

permit data changes to travel from one table to another.

question

Cascade delete

answer

searches the database and deletes all of the related records; ex. Delete a customer and all his orders will be deleted, too.

question

Cascade update

answer

connects a primary key change to the tables in which it is a foreign key

question

Indexed property

answer

is a list that relates the field values to the records that contain the field value

question

Data redundancy

answer

occurs when unnecessary duplicate information exists in a database

question

Text

answer

stores alphanumeric data, such as a student's name or address. Example: City

question

Number

answer

contains a value that can be used in a calculation, such as the number of credits a student has earned. Example: Height

question

Autonumber

answer

is a special data type that Access used to assign the next consecutive number each time you add a record. Example: customer account number

question

Date/Time

answer

hold formatted dates or times and allows the values to be used in date or time arithmetic. Example: Library databases that store research papers

question

Currency

answer

can be used in a calculation and is used for fields that contain monetary values. Example: Your checking account balance

question

Yes/No

answer

assumes one of two values, such as Yes or No, True or False, or On or Off. Example: Dean's list

question

Hyperlink

answer

stores a Web address (URL). Example: www.lsu.edu

question

OLE

answer

contains an object created by another application. Example: Excel workbook

question

Attachment

answer

data type that allows you to attach images, spreadsheet files, charts, and other types of supported files to the records in your database

question

Date arithmetic

answer

a mathematical expression that calculates elapsed time; Ex. Add one to Today( ) to get tomorrow.

question

Filter

answer

condition that helps you find a subset of data meeting your specifications; Ex. Filter by crash data by parish code

question

Sort

answer

(ascending) provides an alphabetical list of text data or a small-to-large list of numeric data. (Descending) arranges the records with the highest value listed first

question

Filter by form

answer

permits selecting the criteria from a dropdown list, or applying multiple criterion

question

Filter by selection

answer

selects only the records that match the pre-selected criteria

question

Inequity

answer

examines a mathematical relationship such as:

question

PivotChart view

answer

displays a chart of the associated PivotTable view

question

PivotTable view

answer

provides a convenient way to summarize and organize data about groups of records

question

Query design grid

answer

displays when you select a query's Design view; it divides the window into two parts

question

Query Wizard

answer

a tool that facilitates new query development through a series of dialog boxes

question

Select query

answer

searches the underlying tables to retrieve the data that satisfy the query parameters

question

Calculated field

answer

a field that derives its value from a formula that references one or more existing fields

question

Data Mining

answer

the process of analyzing large volumes of data to identify patterns and relationships

question

Data demographics

answer

are data describing population segments by age, race, education, and other variables.

question

Drop zone

answer

an area in the PivotTable or PivotChart design grid where drop fields to organize the data

question

Row field (Row drop zone)

answer

the source field that you assign to group data horizontally into rows

question

Column field (Column drop zone)

answer

the data field that you assign to group data vertically into columns

question

Detail or totals field

answer

the data field that contains individual values to be summarized

question

Drill button

answer

the plus or minus sign that enables you to show or collapse details in a PivotTable

question

Filter field (Filter drop zone)

answer

the data field that you use to create criteria to filter data in a PivotTable

question

Crossfooting

answer

the sum of a total row compared to the sum of a column total to verify that the two totals match

question

Discrete data

answer

classification of data that is measured and quantified in discrete, unique increments; categories; ex. the number of males and females in a class, names of countries, etc.

question

Continuous data

answer

classification of data in which values fall on a continuum and are easily scaled. Ex. Measurements of time, temperature, money, volume, size, and distance.

question

Column, bar, and stack

answer

charts that display quantitative data and compare data across categories.

question

Line Charts

answer

a chart that plots data points which are continuously distributed data to compare trends over time. Place time measurements on the X axis.

question

Pie chart

answer

a chart that shows proportion of each category to the whole for a single data series

question

Doughnut chart

answer

a chart that shows values as percentages to the whole for multiple data series

question

Bubble Charts

answer

a variation of a scatter chart to show how sets of things compare according to various factors. The sizes of the bubbles show the relative size of the data being plotted

question

Legend

answer

area of the chart that identifies which color represents the data for each data series

question

Axes

answer

the vertical and horizontal scales displaying plotted data in a line, column, bar, or scatter chart

question

Gridlines

answer

the lines that extend across the plot area of a chart

question

Chart title

answer

the area of a chart that displays a name describing the data depicted in a chart

question

Plot area

answer

area of the chart that displays the data points

question

Calculated detail field

answer

the portion of a PivotTable or PivotChart that generates a new field and performs the stipulated calculation on all of the detail records

question

Calculated total field

answer

a data field used to customize aggregated data

Microsoft Access Terms – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards