Download Database Terms and Definitions and more Quizzes Information Technology in PDF only on Docsity!
database
A file that consists of one or more tables and the supporting objects used to get data into and out of the fields TERM 2
relational database software
DEFINITION 2 a computer application, such as Microsoft Access, that is used to store data and convert it into information TERM 3
relational database management system
DEFINITION 3 Data are grouped into similar collections, called tables, and the relationships between tables are formed by using a common field TERM 4
flat/non-relational data
DEFINITION 4 data contained in a single page or sheet TERM 5
field
DEFINITION 5 a basic entity, data element, or category, such as a book title or telephone number
column
the data field that you assign to group data vertically into columns; ex. First name, last name, address, and phone number TERM 7
record
DEFINITION 7 a complete set of all of the data about one person, place, event, or idea; All the fields on my class roster about one student. TERM 8
row
DEFINITION 8 the source field that you assign to group data horizontally in a crosstab query TERM 9
table
DEFINITION 9 a collection of records TERM 10
primary key
DEFINITION 10 the field that makes each record in a table unique; ex. Student ID number
Access works primarily
from...
storage TERM 17
practicing good file management in access..
DEFINITION 17 a. Avoid damaging data by copying data and renaming the file. b. Access speed the amount of time it takes for the storage device to make the file content available for use c. Access runs best from a hard drive or network drive because those drives have sufficient access speed to support the software. TERM 18
Compact and Repair database
utility
DEFINITION 18 Reduces the size of the database and eliminates wasted space. i. Acts like a disk defragmenter utility. It finds related file sectors and reassembles them in one location if they become scattered from database use. ii. You should compact and repair your database each day when you close the file. TERM 19
datasheet view
DEFINITION 19 a grid containing columns and rows where you add, edit, and delete records in a database table TERM 20
design view
DEFINITION 20 displays the infrastructure of a table, form, or report without displaying the data
one-to-many relationships
exists when each record in the first table may match one, more than one, or no records in the second table TERM 22
cascades
DEFINITION 22 permit data changes to travel from one table to another. TERM 23
cascade delete
DEFINITION 23 searches the database and deletes all of the related records; ex. Delete a customer and all his orders will be deleted, too. TERM 24
cascade update
DEFINITION 24 connects a primary key change to the tables in which it is a foreign key TERM 25
indexed property
DEFINITION 25 is a list that relates the field values to the records that contain the field value. a. Like an index in a book, using an index to find a record in a database reduces retrieval time. b. All primary keys must be indexed.
currency
can be used in a calculation and is used for fields that contain monetary values. Example: Your checking account balance TERM 32
yes/no
DEFINITION 32 assumes one of two values, such as Yes or No, True or False, or On or Off. Example: Deans list TERM 33
OLE
DEFINITION 33 contains an object created by another application. Example: Excel workbook TERM 34
attachment
DEFINITION 34 data type that allows you to attach images, spreadsheet files, charts, and other types of supported files to the records in your database TERM 35
date arithmetic
DEFINITION 35 a mathematical expression that calculates elapsed time; Ex. Add one to Today( ) to get tomorrow.
filter
condition that helps you find a subset of data meeting your specifications; Ex. Filter by crash data by parish code TERM 37
sort
DEFINITION 37 (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 TERM 38
filter by form
DEFINITION 38 permits selecting the criteria from a dropdown list, or applying multiple criterion TERM 39
filter by selection
DEFINITION 39 selects only the records that match the pre-selected criteria TERM 40
pivot chart view
DEFINITION 40 displays a chart of the associated PivotTable view
data mining
the process of analyzing large volumes of data to identify patterns and relationships TERM 47
data demographics
DEFINITION 47 are data describing population segments by age, race, education, and other variables. TERM 48
pivot table elements
DEFINITION 48 a. Drop zone b. Row field (Row drop zone) c. Column field (Column drop zone) d. Detail or totals field e. Drill button f. Filter field (Filter drop zone) g. Crossfooting TERM 49
drop zone
DEFINITION 49 an area in the PivotTable or PivotChart design grid where drop fields to organize the data TERM 50
row field (row drop zone)
DEFINITION 50 the source field that you assign to group data horizontally into rows
column field (column drop zone)
the data field that you assign to group data vertically into columns TERM 52
details or total field
DEFINITION 52 the data field that contains individual values to be summarized TERM 53
drill button
DEFINITION 53 the plus or minus sign that enables you to show or collapse details in a PivotTable TERM 54
filter field
DEFINITION 54 the data field that you use to create criteria to filter data in a PivotTable TERM 55
cross footing
DEFINITION 55 the sum of a total row compared to the sum of a column total to verify that the two totals match
bubble charts
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. i. Example: Salaries by job title with the size of the bubble representing the percentage of the total salary budget. TERM 62
pivot chart elements
DEFINITION 62 a. Legend area of the chart that identifies which color represents the data for each data series b. Axes the vertical and horizontal scales displaying plotted data in a line, column, bar, or scatter chart c. Gridlines the lines that extend across the plot area of a chart d. Chart title the area of a chart that displays a name describing the data depicted in a chart e. Plot area area of the chart that displays the data points TERM 63
calculated detail field
DEFINITION 63 the portion of a PivotTable or PivotChart that generates a new field and performs the stipulated calculation on all of the detail records TERM 64
calculated total field
DEFINITION 64 a data field used to customize aggregated data
