question

_____ fields hold things such as pictures and video clips

answer

OLE Object

question

__________ view is used to enter field properties and data types.

answer

Design

question

A _____ enables users to view or enter data one record at a time.

answer

Form

question

a category of data

answer

field

question

A category of information about students, such as their phone numbers, would be stored in a(n) _____

answer

field

question

a category of information in a database

answer

field

question

A collection of data

answer

Table

question

a collection of objects

answer

database

question

A database ____ organizes information into fields and records.

answer

Table

question

a field that has a value unique to each record

answer

primary key

question

a group of related fields

answer

record

question

A group of related fields is called a(n) ___

answer

record

question

a group of related records

answer

table

question

A group of related records is called a(n) _____

answer

table

question

a link between tables that defines how the data is connected

answer

relationship

question

A One to Many relationship is indicated by a 1 at one end of the join line and __________ at the other end.

answer

infinity sign (?)

question

A query that extracts data from more than one table is called a(n) _____ query.

answer

multi-table

question

A Short Text field can store no more than 100 characters.

answer

False

question

A system that's designed to help perform routine daily tasks is known as (a)n

answer

office support system.

question

A type of data validation that would ensure the number of hours worked for an employee is greater than 0 but less than or equal to 40 is called a

answer

range check.

question

A(n) _____ is a collection of related data that can be easily stored, organized, and queried.

answer

database

question

A(n) ______ database stores in more than two dimensions

answer

multidimensional

question

All of the following are types of basic database objects EXCEPT __________.

answer

lists

question

All of the following is TRUE about a Query EXCEPT ____

answer

it is a professional printed presentation

question

allows editing of individual records

answer

form

question

Alphabetic Check

answer

Confirms that only texlual characters are entered in a field.

question

Artificial Intelligence (AI)

answer

Is the branch of computer science that deals with the attempt to create computers that think like humans.

question

Attachment

answer

The Attachment field type is used to store images, spreadsheet files, documents, charts, and other types of supported files to the records in your database.

question

AutoNumber

answer

An AutoNumber field creates unique values automatically when Access creates a new record. The AutoNumber field is primarily used for primary keys in Access.

question

Autonumber Datatypes are generally used for calculation fields such as price.

answer

False

question

Batch processing

answer

The accumulation of transaction data until a certain point is reached, at which time several transactions are processed at once

question

batch processing

answer

The accumulation of transaction data until a certain point is reached, at which time several transactions are processed at once.

question

Before a multi-table query can be created, a __________ must first be established between the tables.

answer

relationship

question

Before you begin to create a database using Access, you should do all of the following EXCEPT __________.

answer

plan the hierarchy of your records

question

Being able to use data from two or more tables by linking their common fields involves establishing a ____

answer

relationship

question

Binary Large Object (BLOB)

answer

Data enclosed in binary form.

question

Browsing

answer

An option with most databases where you view records.

question

business intelligence systems

answer

Systems used to analyze and interpret data in order to enable managers to make informed decisions about how best to run a business.

question

But, if I include the primary key of one table in the other table, won't I have two primary keys for a record?

answer

When the primary key of one table is included in another table to establish a relationship between the two tables, it is called a foreign key in the related table.

question

Calculated

answer

Data created with a formula. Use a Calculated field when a calculated value will be used in many queries, forms, and reports.

question

Calculated field (or computed field)

answer

A numeric field that stores the contents of a calculation, which is generated with a formula in the numeric field.

question

Changing the field type may result in the loss of data

answer

True

question

clickstream data

answer

Software used on company websites to capture information about each click that users make as they navigate through the site.

question

completeness check

answer

Ensures that all fields defined as "required" have data entered into them.

question

Computational Field (Calculated Field)

answer

Is a numeric field that stores the contents of a calculation, which is generated with a formula in the numeric field.

question

Consistency Check

answer

Compaires the value of data in two or more fields to see if these values are reasonable.

question

Currency

answer

The Currency data type stores values in a monetary format.

question

Data __________ is the duplication of data in a database and should be avoided.

answer

redundancy

question

Data Centealization

answer

Ensuring integrity, instead of being in multipal lists that have to be maintained, the information is maintained in only one place.

question

data centralization

answer

Ensuring data integrity; instead of being in multiple lists that have to be maintained, the information is maintained in only one place.

question

data centralization

answer

When data is maintained in only one file.

question

data dictionary (database schema)

answer

A map of a database that defines the features of the fields in the database.

question

data dictionary (or database schema)

answer

Description of the data. This description is contained in the database's files.

question

data inconsistency

answer

Each time the information in the list changes, multiple lists must be updated and if not, then inconsistent data results.Data for a record being different in two different lists.

question

Data Integrity

answer

When the data contained in the database is accurate and reliable.

question

Data mart

answer

Small slices of a data warehouse grouped together and separated from the main body of data in the data warehouse so that related sets of data can be analyzed

question

Data Mining

answer

Is the porcess by which great amounts of data are analyzed and investigated. The objective is to spot significant patterns or trends within the data that would otherwise not be obvious.

question

data redundancy

answer

Duplicated data between lists.

question

Data Staging

answer

Source data must be "staged" before entering the data warehouse. The act of formatting data from source databases before fitting it into a data warehouse; it consists of three steps: extraction, transformation, and storage.

question

data type (field type)

answer

(1) Describes the kind of data being stored at the memory location; each programming language has its own data types (although there is some degree of overlap). (2) In a database, indicates what type of data can be stored in a field and prevents the wrong type of data from being entered into the field.

question

Data Type (Field Type)

answer

Indicates what type of data can be stored in the field.

question

Data warehouse

answer

A large-scale collection of data that contains and organizes in one place all the data from an organization's multiple databases

question

Database

answer

Collection of related data that can be easily stored, sorted, organized and queried.

question

database administrator (or database designer)

answer

An individual trained in the design and building of databases, to assist with the construction of large databases.

question

Database Managment System (DBMS)

answer

Specially designed application software (such as Oracle Database or Microsoft Access) that interacts with the user, other applications, and the database to capture and analyze data.

question

database query

answer

A question you ask the database so that it provides you with the records you wish to view.

question

database-management system (DBMS)

answer

Specially designed application software (such as Oracle Database or Microsoft Access) that interacts with the user, other applications, and the database to capture and analyze data.

question

Date/Time

answer

The Date/Time field allows storage of date and time information.

question

Date/Time Field

answer

Holds data such as Birthdays and Due Dates.

question

decision support system (DSS)

answer

A type of business intelligence system designed to help managers develop solutions for specific problems.

question

Default Value

answer

The value the database uses for the field unless the user enters another value.

question

detail report

answer

A report generated by a management information system that provides a list of the transactions that occurred during a certain time period.

question

enterprise resource planning (ERP) system

answer

A business intelligence system that accumulates in a central location all information relevant to running a business and makes it readily available to whoever needs it to make decisions.

question

exception report

answer

A report generated by a management information system that shows conditions that are unusual or that need attention by system users. 2: Shows conditions that are unusal or that need attention by users of the system.

question

expert system

answer

A system that tries to replicate the decision-making processes of human experts in order to solve specific problems.

question

Export

answer

Involves putting it into an electronic file in a format that another application can understand.

question

External Data Source

answer

Is any source now owned by the company that owns the DSS, such as customer demographic data purchased from third parties, mailing lists, or staistic compiled by the federal government.

question

Field

answer

The component of a database in which the database stores each category of information

question

field constraint

answer

A property that must be satisfied for an entry to be accepted into the field.

question

Field Name

answer

An identifying name assigned to each field in a database.

question

field properties

answer

In an Access database table, the field name, data type, and other data elements.

question

Field Size

answer

Defines the maximum number characters or numbers that a field can hold.

question

Filter

answer

In a database, temporarily displays records that match the certain criteria

question

Foreign Key

answer

The primary key of another table that is included for purposes of establishing relationships with that other table.

question

Forms enable you to __________ individual records.

answer

view, input, or edit

question

fuzzy logic

answer

Enables the interjection of experiential learning into knowledge-based systems by allowing the consideration of probabilities.

question

How do I create fields in a database?

answer

Actually, you can create the fields manually by assigned field names.

question

How do I create relationships between tables?

answer

You use primary and foreign key fields to create relationships between tables.

question

How do I get started on creating a database?

answer

Before creating a database, you need to know the three main components of a database. These include fields, records, and tables.

question

Hyperlink

answer

The Hyperlink field type is used to store web addresses.

question

Hyperlink field

answer

Stores hyperlinks to Web pages.

question

If you change the data type from Number to Text, you could end up _____

answer

Losing data

question

If you delete a field the data will be maintained in the database in case you add the field again later

answer

False

question

If you want to save and reuse the criteria for selecting records, you should use __________.

answer

a query

question

In a database, a text capable of holding complete paragraphs has a _____ data type

answer

long text

question

In a database, a video clip would be stored in a(n) _____ field

answer

OLE Object

question

information system

answer

A system that includes data, people, procedures, hardware, and software that help in planning and decision making; a software-based solution used to gather and analyze information.

question

input form

answer

Provides a view of the data fields to be filled, with appropriate labels to assist database users in populating the database.

question

Internal Data Source

answer

Are maintained by the same company that operates the DSS.

question

Is one table in a database enough to enter all my information in it and store all the fields?

answer

No, you need to create different tables and categorize data to be stored in them.

question

join query

answer

A query used to extract data that's in two or more tables in a database.When you want to extract data that is in two or more tables, you use a join query. The query actually links (or joins) the two tables using the common field in both tables and extracts the relevant data from each.

question

Knowledge based systems

answer

A business intelligence system that provides intelligence that supplements the user's own intellect and makes the decision support system more effective

question

List five of the suggested online template areas.

answer

Assets, Business, Contacts, Employee, Inventory, Project, and Sales

question

Long Text

answer

Text up to 65,536 characters. A feature of the long text field is that it now supports rich text formatting.

question

Long Text field

answer

Like a text field but can hold long pieces of text.

question

management information system(MIS)

answer

A type of business intelligence system that provides timely and accurate information that enables managers to make critical business decisions.

question

Management information systems (MISY WOOOOO)

answer

A type of business intelligence system that provides timely and accurate information that enables managers to make critical business decisions

question

many-to-many relationship

answer

In a relational database, records in one table are related to multiple records in a second table, and vice versa.

question

metadata

answer

Data that describes other data; an integral part of the data dictionary.

question

model management system

answer

Software that assists in building management models in decision support systems; an analysis tool that, through the use of internal and external data, provides a view of a particular business situation for the purposes of decision making.

question

Most small businesses use ___ databases as they are reliable and less costly

answer

relational

question

Multidimensional database

answer

A database that stores data from different perspectives, called dimensions, and organizes data in cube format. 2: Stores data in more than two dimensions.

question

natural language processing (NLP)system

answer

A knowledge-based business intelligence system that enables users to communicate with computer systems using a natural spoken or written language instead of a computer programming language.

question

normalization

answer

In databases, the goal is to reduce data redundancy by recording data only once. This process is called normalization of the data. 2:A process to ensure data is organized most efficiently in a database.

question

Number

answer

Only numbers. You may use + or - before the number, as well as a decimal point.

question

Number field

answer

Stores values that can be used to perform calculations.

question

numeric check

answer

Confirms that only numbers are entered in the field.

question

Object Query Language (OQL)

answer

A query language used by many object-oriented databases.2: A database that stores data in objects rather than in tables. 3: Similar in many respects to SQL (structured query language), a standard language used to construct queries to extract data from databases.

question

office support system (OSS)

answer

A system designed to improve communications and assist employees in accomplishing their daily tasks.

question

OLE Object field

answer

Holds items such as pictures, video clips, or documents.

question

Once a query has been created, clicking the Run button displays the results of the query

answer

True

question

one-to-many relationship

answer

In a relational database, a record appears only once in one table while having the capability of appearing many times in a related table. 2: Characterized by a record in one table and occurring most frequently in relational databases.

question

one-to-one relationship

answer

In a relational database, for each record in a table there's only one corresponding record in a related table.

question

online analytical processing (OLAP)

answer

Software that provides standardized tools for viewing and manipulating data in a data warehouse.

question

online transaction processing (OLTP)

answer

The real-time processing of database transactions online.

question

Primary Key

answer

In a database, a field that has a value unique to a record

question

primary key (or key field)

answer

To keep records distinct, each record must have one field (the primary key) that has a value unique to that record.

question

primary key field

answer

In a database, a field that has a value unique to a record.

question

Queries can be created using Design view

answer

True

question

Queries can be saved and used to generate other objects such as reports and forms

answer

True

question

query

answer

A question or inquiry.

question

Query

answer

In a database, a way of retrieving information that defines a particular subset of data; can be used to extract data from one or more tables

question

query language

answer

A specially designed computer language used to manipulate data in or extract data from a database. 2: Software used to retrieve and display records. A query language consists of its own vocabulary and sentence structure, which you use to frame the requests.

question

Query modifications such as changing the contents of the Criteria row are done in ____ view

answer

Design

question

questions for the database

answer

query

question

range check

answer

Ensures that the data entered into the field of a database falls within a certain range of values.

question

Real time processing

answer

The processing of database transactions in which the database is updated while the transaction is taking place

question

Record

answer

A group of related fields in a database

question

referential integrity

answer

In a relational database, a condition where, for each value in the foreign key table, there's a corresponding value in the primary key table.

question

relation

answer

A table that contains related data.

question

relational algebra

answer

The use of English-like expressions that have variables and operations, much like algebraic equations, to extract data from databases using Structured Query Language.

question

Relational database

answer

A database type that organizes data into related tables based on logical groupings

question

relationship

answer

A link between tables that defines how the data is related.

question

Relationship

answer

In a relational database, a link between tables that defines how the data is related

question

Report modifications such as re-sizing controls or columns, or changing the formatting are most easily done in ____ view

answer

Layout

question

represents multiple characters in search criteria

answer

wildcard

question

select query

answer

In Structured Query Language, displays a subset of data from a table (or tables) based on the criteria specified.

question

Short Text field

answer

Hold any combination of alphanumeric data (letters or numbers).

question

sort

answer

Involves organizing data in a new fashion.

question

structured (analytical) data

answer

Relational databases excel in the storage of structured (analytical) data. 2:Data such as "Bill" or "345," as opposed to unstructured data.

question

structured query language (SQL)

answer

A type of query language used by almost all relational and object relational databases to extract records from a database.

question

Summarize information for printing and presentation

answer

report

question

summary report

answer

A report generated by a management information system that provides a consolidated picture of detailed data; these reports usually include some calculation or visual displays of information.

question

table (or file)

answer

A group of related records.

question

Tables are collections of related data organized by __________.

answer

fields and records

question

Text

answer

A Text field can contain values that are text, numeric, or a combination of both. A text field can contain a maximum length of 255 characters.

question

The Access data type to automatically assign an incremental number is ____

answer

AutoNumber

question

The Access object that enables you to ask the database questions about information is a __________.

answer

query

question

The Access object that summarizes information for presentation and printing is a __________.

answer

report

question

The duplication of data in a database is called data ____

answer

Redundancy

question

The easiest way to create a query is to use the Simple Query __________.

answer

Wizard

question

The easiest way to create a simple query is to use the Simple Query _____

answer

wizard

question

The field that has a unique entry for each record in a database table is called the

answer

primary key.

question

The form ____ prompts you step-by-step through the creation of a form

answer

Wizard

question

The information about a single student would be stored in a _____

answer

record

question

The two types of objects responsible for collecting data are _____.

answer

tables and forms

question

Three Steps of Data Staging

answer

Step 1: Extraction of the data from source databases. Step 2: Transformation (reformatting) of the data. Step 3: Storage of the data warehouse.

question

time-variant data

answer

Data that doesn't pertain to one period in time.

question

To combine data from more than one table, you need to create a(n) ____ between the tables.

answer

relationship

question

To create an association between common fields in two tables, you establish a __________.

answer

relationship

question

To display a limited set of records, you would use a __________.

answer

filter

question

To ensure that there are no duplicate records in a database table, you need to establish a ____

answer

primary key

question

To establish a relationship between two tables, the primary key in one table is associated with the ___ in the other table.

answer

foreign key

question

To limit data to just those records with states that begin with the letter C, which of the following would you type in the Find What text box?

answer

state=C*

question

To use data from two tables, you must create a ____ between them.

answer

relationship

question

transaction-processing system (TPS)

answer

A type of business intelligence system for keeping track of everyday business activities.

question

Two lists showing the same data about the same person is an example of

answer

data redundancy.

question

Types Of Fields

answer

Text Field, Numeric Field, Computational (Calculated) Field, Date/Time FIeld, Memo Field, Object Field, Hyperlink Field.

question

unstructured data

answer

Object-oriented databases are more adept at handling unstructured data that includes nontraditional data such as audio clips (including MP3 files), video clips, pictures, and extremely large documents.Audio clips, video clips, pictures, and extremely large documents. Also called binary large object (BLOB).

question

used to create a relationship between two tables

answer

join line

question

validation

answer

Process of ensuring that data entered into the database is correct (or at least reasonable) and complete.

question

validation rule

answer

In a database, generally defined as part of the data dictionary and specified in the field properties for each field; violations result in an error message and a suggested action. 2: Set up in the database to alert the user if a clearly wrong entry is entered in the field instead of a valid entry.

question

What are the different types of databases and which is the most common?

answer

There are relational, object-oriented, and multidimensional databases. Of these, the relational database is most common.

question

What data type can I use for a field if I have to store a page of text?

answer

You can use Long Text data type. They are text fields that are used to hold text with images just like a document.

question

What else can I store in a field besides text, numeric values, and contents of a calculation?

answer

You can store pictures and video clips using OLE Object fields.

question

What is an example of a record in the Windows Media Player database?

answer

A song

question

What is the Access object that organizes data into fields and records?

answer

Table

question

What is the difference between a record and a field?

answer

A field is a single piece of information in a record.

question

What is used to indicate a search term can be anywhere in a string of text?

answer

Wildcards

question

When a table is ____ some of the records are temporarily hidden

answer

filtered

question

When creating a table in Design view, you can add each of the following EXCEPT _____

answer

Table sizes

question

When just one residence hall can be listed for multiple students in a database, which type of relationship should be established between the database tables?

answer

one-to-many relationship

question

When you enter data using a form, the data in the underlying table is also updated.

answer

True

question

When you filter a table, data is actually deleted

answer

False

question

Which best describes a data warehouse?

answer

a collection of all the data from an organization's databases

question

Which data type enables you to store numeric values that need to be calculated?

answer

Number

question

Which database object enables you to ask questions of the database?

answer

Queries

question

Which database object filters out specific data based on the criteria you set?

answer

Queries

question

Which database object is used to input, view, or edit individual records one at a time?

answer

Form

question

Which database object is used to summarize information for presentation and printing?

answer

Report

question

Which is a type of MIS report that provides a consolidated picture of detailed data?

answer

summary report

question

Which is NOT a Microsoft Access database object?

answer

Slides

question

Which object is generally used to display only one record at a time for entering and editing data?

answer

Forms

question

Which of the following is a component of data staging?

answer

transformation of the data, extraction of data from source databases, storage of the data in the data warehouse

question

Which of the following is NOT a true statement when considering using databases instead of lists?

answer

Databases are easier to build and maintain than lists.

question

Which of the following is NOT an Access data type?

answer

Relational

question

Which of the following is NOT part of a design plan for a database?

answer

Develop the forms

question

Which tool is used to search for information in a database?

answer

Query

question

Which wildcard character enables you to specify any character and any number of characters?

answer

Asterisk (*)

question

Which would NOT be a feature or component of a transaction-processing system?

answer

virtual processing

question

Yes/No

answer

Boolean data storage of true/false values.

question

You can create a report by using the __________.

answer

Report Wizard

question

You CANNOT use a query to generate a ________.

answer

spreadsheet

question

_________ means that the data contained in the database is accurate and reliable.

answer

Data integrity

question

A database stores each category of information in a ____________ and each group of related fields in a ____________.

answer

field; record

question

What ensures that data is organized in the most efficient way in a database?

answer

Normalization

question

What defines the maximum number of characters that a field in a database can hold?

answer

Field size

question

What are object-oriented databases more adept at handling than relational databases?

answer

Unstructured data

question

What type of database organizes data in a cube format?

answer

Multidimensional databases

question

A ____________ check compares the values of data in two or more fields to see if those values are reasonable.

answer

consistency

question

____________ temporarily displays records that match certain criteria.

answer

A filter

question

A(n) ____________ keeps track of everyday business activities such as accepting tuition payments or printing course catalogs.

answer

TPS

question

A system that tries to replicate the decision-making processes of human experts in order to solve specific problems is known as a(n) ____________ system.

answer

expert

question

Which knowledge-based system enables users to communicate with computer systems using a natural spoken or written language instead of using a computer programming language?

answer

NLP

question

The primary reason that businesses mine data is to understand their customers better.

answer

True

question

A one-to-many relationship in databases indicates that for each record in a table, there can be many corresponding records in a related table.

answer

True

question

The data dictionary is also known as the database schema.

answer

True

question

Batch processing is most appropriate for activities that are urgent and immediate.

answer

False

question

Transformation (reformatting) of the data is the first step in data staging.

answer

False

question

Clustering involves assigning a value to data based on some criterion.

answer

False

question

An enterprise resource planning (ERP) system enables the interjection of experiential learning into the equation by considering probabilities.

answer

False

question

A model management system is software that is designed to help managers develop solutions for specific problems.

answer

False

question

Artificial intelligence is the branch of computer science that deals with the attempt to create computers that think like humans.

answer

True

question

Detail reports, summary reports, and exception reports are the three types of reports generated by an expert system.

answer

False

question

All modern DBMSs contain a query language that the software uses to retrieve and display records.

answer

True

question

Data staging consists of three steps: extraction, transformation, and storage.

answer

True

question

Office support system

answer

Designed to improve communications and assist employees in accomplishing their daily tasks.

question

Transaction-processing system

answer

Keeps track of everyday business activities.

question

Management information system

answer

Provides timely and accurate information that enables managers to make critical business decisions.

question

Decision support system

answer

Business intelligence system designed to help managers develop solutions for specific problems.

question

Database management system

answer

Specially designed application software that is used to capture and analyze data.

question

Information system

answer

Software-based solution used to gather and analyze information.

question

Metadata

answer

Data that describes other data.

question

Query

answer

A subset of data that matches certain criteria.

question

Normalization

answer

Reduces data redundancy by recording data only once.

question

Table

answer

A group of related records.

question

Record

answer

A group of related fields.

question

Field name

answer

Identifies each field.

question

When is it sufficient to use a list to organize data?

answer

When the data is simple and can be organized in one table

question

Which is NOT a component of a database that describes how data is stored?

answer

Report

question

The type of database that is best for organizing unstructured data such as video and audio is

answer

object-oriented

question

Which of the following is NOT considered a step in data staging?

answer

Inputting data not stored in source databases

question

A gas purchase made with a credit card at the pump would be entered into which type of database system?

answer

Transaction-processing system

question

Which of the following database system uses artificial intelligence?

answer

Knowledge-based system

question

A field labeled PHONE that accepts data such as (610) 555-1212 would use the Number data type

answer

False

question

A query is used to extract a subset of data from a database.

answer

True

question

a small slice of a data warehouse is called a data market.

answer

False

question

Fuzzy logic uses approximate data gathered by experience rather than fixed and exact facts

answer

True

Technology in Action Chapter 11 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards