Download Database Terminology: Understanding Key Concepts for Access and Relational Databases and more Quizzes Information Technology in PDF only on Docsity!
Database
A file that cinsists of one or more tables and th esupporting 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 or 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, phone number TERM 7
Record
DEFINITION 7 a complete set of all the data about one person, place, event, or idea. Ex, All the fields on my class roster about one student TERM 8
Row
DEFINITION 8 the source field that you assign to group data horixontally 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
Practicing good file management
What are you doing:Avoid damaging data by copying data and renaming fileaccess speedaccess runs best from a hard drive since those drives have sufficient access speed to support the software. TERM 17
Access speed
DEFINITION 17 the amount of time it takes for the storage device to make the file content available for use TERM 18
the data is the lifeblood of the organization
DEFINITION 18 Backing up databases on a regular bases is critical because... TERM 19
create a duplicate copy of the database
DEFINITION 19 How do you back up and access file? TERM 20
The database grows
DEFINITION 20 What happens when the database is being used, such as when new information is added, the database is being viewed, queries are created or run, or filters are applied and removed?
Any
How much growth in a database creates problems? TERM 22
Compact and Repair Database Utility
DEFINITION 22 Reduces the size of the database and eliminated wasted space TERM 23
each day before you close the
file
DEFINITION 23 When should you compact and repair your database? TERM 24
50% or more
DEFINITION 24 How much will compacting and repairing your database decrease the file size by? TERM 25
Design view
DEFINITION 25 displays the infrastructure of a table, form, or report without displaying the data
Data redundancy
occurs when unnecessary duplicate information exists in a databse TERM 32
Text
DEFINITION 32 stores alphanumeric data,such as a student's name or address. Example: City TERM 33
Number
DEFINITION 33 contains a value that can be used in a calculation, such as the number of credits a students has earned. Example: Height TERM 34
Autonumber
DEFINITION 34 is a special data tyoe that Access used to assign the next consecutive number each time you add a record. Example customer account number TERM 35
Date/Time
DEFINITION 35 hold formatted dates or times and allows the values to be used in date or time arithmetic. Example: library databases that store research papers
Currency
can be used in a calculation and is used for fields that contain monetary values. Example: your checking account balance TERM 37
Yes/No
DEFINITION 37 assumes on of two values such as Yes or No, True or False, or On or Off. Example: Dean's list TERM 38
OLE
DEFINITION 38 contains an object created by another application, Example: Excel workbook TERM 39
Attachment
DEFINITION 39 data type that allows you to attach images, spreadsheet files, charts, and other types of supported files to the records in your database TERM 40
Date arithmetic
DEFINITION 40 a mathematical expression that calulates elapsed time; Ex. ass one to Today() to get tomorrow
PivotTable view
provides a convenient way to summarize and organize data about groups of records TERM 47
Query design grid
DEFINITION 47 displays when you select a query's design view; it divides the window into two parts TERM 48
Query Wizard
DEFINITION 48 a toold that facilitates new query development through a series of dialog boxes TERM 49
Select query
DEFINITION 49 searches the underlying tables to retrieve the data that satisfy the query parameters TERM 50
Calculated field
DEFINITION 50 a field that derives its value from a formula that references one or more existing fields
Data demographics
are data describing population segments by age, race, education, and other variables TERM 52
PivotTable Elements
DEFINITION 52 srop zone, row field (Row drop zone), Column field (column drop zone), detail or totals field, drill button, filter field (filter drop zone), Crossfotting TERM 53
Drop Zone
DEFINITION 53 an area in the PivotTable or PivotChart design grid where drop fields to organize the data TERM 54
Row Field
DEFINITION 54 the source field that you assign to group data horizontally into rows TERM 55
Drill button
DEFINITION 55 the plus or minus sign that enables you to show or collapse details in a PivotTable.
Continuous data
classification of data in which values fall on a continuum and are easily scaled. Ex. measurements of time, temperature, money, volume, size, and distance TERM 62
Calculated detail field
DEFINITION 62 the portion of a PivotTable or PivotChart that generates a new field and performs the stipulated calculation on all of the detail records TERM 63
Calculated total field
DEFINITION 63 a data field used to customize aggregated data
