Chapter 6 Application Software

Database

A collection of related data that is stored in a manner enabling information to be retrieved as needed; in a relational database, a collection of related tables

Record

A collection of related fields in a database. Also called a row

Software suite

A collection of software programs bundled together and sold as a single software package

Workbook

A collection of worksheets saved in a single spreadsheet file

Keyboard shortcut

A combination of keyboard keys that are pressed in unison to issue a specific software command

Electronic slide show

A group of electronic slides that are displayed one after the other on a monitor or other display device

Function

A named formula that can be entered into a worksheet cell to perform some type of calculation or to extract information from other cells in the worksheet

Constant value

A numerical entry in worksheet cell

Slide

A one-page presentation graphic that can be displayed in a group with other to form an electronic slide show

Label

A text-based entry in a worksheet cell that identifies data on the worksheet

Formula

An entry in a worksheet cell that performs computations on worksheet data and displays the results

Presentation graphic

An image, such as a graph or drawn object, designed to visually enhance a presentation

Insertion point

An on-screen character that looks like a blinking vertical line; indicates the current location in a document, which is where the next change will be made

Formatting

Changing the appearance of a document, such as changing the margins or font size

Editing

Changing the content of a document, such as inserting or deleting words

Public domain software

Software that is not copyrighted and may be used without restriction

Installed software

Software that must be installed on a computer in order to be used

Application software

Programs that enable users to perform specific tasks on a computer, such as writing a letter or playing a game

Web-based software

Software that is delivered on demand via the Web; also referred to as Software as a Service (SaaS) and cloudware

Spreadsheet

A document containing a group of values and other data organized into rows and columns; also called a worksheet in a spreadsheet program

Ribbon

A feature found in recent versions of Microsoft Office that uses tab to organize groups of related commands

Field

A single category of data to be stored in a database, such as a person's last name or telephone number. Also called a column

Worksheet

A single spreadsheet document in a spreadsheet program

Software license

An agreement, either included in a software package or displayed on the screen during installation, that specifies the conditions under which a buyer of the program can use it

Database software

Application software that allows the creation and manipulation of an electronic database

Graphics software

Application software used to create or modify images

Presentation graphics software

Application software used to create presentation graphics and electronic slide shows

Spreadsheet software

Application software used to create spreadsheets, which typically contain a great deal of numbers and mathematical computations organized into rows and columns

Word processing software

Application software used to create, edit, save, and print written documents

Shareware

Copyrighted software that is distributed on the honor system; consumers should either pay for it of uninstall it after the trial period

Freeware

Copyrighted software that may be used free of charge

Table

In a relational database, a collection of related records or rows

Row

In a spreadsheet program, a horizontal group of cells on a worksheet In a database, a record

Column

In a spreadsheet program, a vertical group of cells on a worksheet In a database, a field

Microsoft Office

One of the most widely used office software suites

Word wrap

The feature in a word processing program that automatically returns the insertion point to the next line when the end of the screen line is reached

Cell

The location at the intersection of a row and column on a worksheet into which data can be typed

Word processing

Using a computer and word processing software to create, edit, save, and print written documents, such as letters, contracts, and manuscripts