Application Software Flashcards
A _______ is a collection of interrelated files in a computer system.
database
[Explanation]
Database files are organized according to common elements to simplify retrieval.
A structured file uses a _______ format to store data for each person or thing in the file.
uniform
[Explanation]
Databases use structured files to organize data.
The most common type of database used on PCs is the __________ database in which data is organized into related tables.
relational
[Explanation]
Relational databases organize data in rows and columns. Access (included with Microsoft Office) is an example of a popular Windows-based relational database application.
Paint, photo editing, and drawing software are all examples of ________ software.
graphics
[Explanation]
Graphics software is designed to help users manipulate and print graphics.
In a relational database, a ___ field is used to sort data.
key
[Explanation]
This can also be called a sort key, index, or keyword. Most database applications allow for multiple keys so that users can sort records in different ways.
In a relational database, the primary key holds a ______ value for each record.
unique
[Explanation]
If we were using a database containing employee records, the primary key might be the employee ID number or social security number. The primary key could be a unique series of numbers or characters; it doesn’t have to be meaningful–just unique.
A database _____ contains a list of keys and each key provides a pointer to the record that contains the rest of the fields related to that key.
index
[Explanation]
A database index can be used to organize data in alphabetical or numerical order.
In a relational database, information is organized in rows and columns. ____ are called records.
Rows
In a relational database, information is organized in rows and columns. The ______ are called fields.
columns
A field contains the smallest unit of meaningful data and can therefore be called the basic ________ block for a structured file or database.
building
[Explanation]
Examples of fields include name, address, social security number, etc.. A collection of fields make up a record.
With a relational database, users _____ records to locate and display them.
query
[Explanation]
This action of calling up specific records in the database is called “querying”.
____ processing software is used to create, edit, print, format and store text.
Word
The ______ is a marker on the monitor which indicates where the next character will appear.
cursor
[Explanation]
The cursor is often a blinking rectangle and its location is called the insertion point.
Spelling and _______ checkers flag unrecognized words, misspelled words, and incorrect grammar with different color squiggly lines.
grammar
In word processing, the formatting for a ________ refers to the way text, graphics, headings, and page numbers appear on a page.
document
[Explanation]
The format for a document refers to the way the document looks.
A ________ is a preformatted document often provided with word processing software.
template
[Explanation]
Examples of popular word processing templates include invoices, FAX cover sheets, and letterheads.
A ________ allows users to enter data in rows and columns to create financial schedules and tables arranged as a grid on a display.
spreadsheet
[Explanation]
In addition to displaying information in rows and columns, spreadsheet software can perform calculations on inputted data. Examples of uses for this feature include grade books, budgets, project costs, expenses, etc..
________ column headings appear across the top frame of the spreadsheet.
Lettered
[Explanation]
Column headings are used to select an entire column with a mouse click.
Numbered ___ headings appear down the left frame of the spreadsheet.
row
[Explanation]
Row headings are used to select an entire row with a mouse click.
The location on a spreadsheet where a row and a column intersect is called a ____.
cell
A group of adjacent cells on a spreadsheet is called a _____.
range
[Explanation]
An example of specifying a range is “C1 to C17”.
Harvard Graphics and MS PowerPoint are examples of ____________ graphics software.
presentation
[Explanation]
Typically, presentations created with this software are used in live presentations, but they may also be printed or presented over the web.
Spreadsheet instructions for calculations are called ________.
formulas
[Explanation]
A formula works behind the scenes to instruct the spreadsheet on how to use the contents of cells in calculations. For example, a user might create a formula to add the contents of a range of cells.
A spreadsheet _____ is any number used in a calculation.
value
[Explanation]
Values are the actual numbers or dates entered into cells. Examples of values include dollars, percentages, grade points and temperatures.
A spreadsheet ________ is a built-in formula which performs common calculations.
function
[Explanation]
For example, a function might count up the results of a range of cells.
A _____ is a single keystroke or command used to automatically issue a longer, predefined series of keystrokes or commands.
macro
[Explanation]
A macro, or keyboard shortcut, is useful when a user has to type the same pattern of keystrokes over and over.
A _______ analysis allows a user to change the contents of a spreadsheet cell and find out how that would change the outcome of the calculation.
what-if
[Explanation]
An example of a what-if analysis would be a spreadsheet created to compare the costs of various mortgages. The user could change variables like interest rate, points, or principal amount and then compare the outcomes.
An _____ system is an interactive computer program that helps users solve problems.
expert
[Explanation]
MYCIN, PROSPECTOR, CARES, CLUES and CLIPS are all examples of expert systems.
The software that controls the search of the expert systems knowledge base and produces a conclusion is called the _________ engine.
inference
Multimedia authoring software combines video, text, animation, graphics and sound to create standalone _________ applications.
multimedia
[Explanation]
Multimedia authoring software is popular with educational businesses, websites, and business training centers.
In MS PowerPoint, the _______ view helps you organize the content of your material.
outline
In MS PowerPoint, the slide sorter view displays __________ of each slide, allowing you to change the order of your presentation.
miniatures
In PowerPoint, the __________ view presents the slides in the order in which the audience will view them.
slide show
[Explanation]
This allows you to practice your presentation.
_________ software allows users to track income and expenses, manage checkbooks, create reports, and record tax information
Financial
[Explanation]
Examples of personal finance manager software include Quicken and Microsoft Money.
Analytical graphics are graphical forms that make _______ data easier to analyze.
numeric
[Explanation]
Analytical graphics are also called business graphics and make sales figures and economic trends easier to understand.
Settings automatically used by a program unless changed by the user are called _______ settings.
default
__________________ software has reduced the time needed to create professional looking printed projects.
Desktop publishing
[Explanation]
Desktop publishing software (DTP) is used to create high quality materials for commercial printing. Examples of DTP software include MS Publisher and PageMaker.
__________________ software allows scheduling of events, management of costs and allocation of resources associated with a project.
Project management
[Explanation]
Usually, project management software allows the user to break a project down into a series of goals or events which are organized as a timeline. Depending on the software, it will also allow management of a lot of the other details related to the project.
Personal Information Management software helps users organize and manage daily ________ activities.
business
[Explanation]
Examples of information managed by PIM software include addresses, phone numbers, appointments, and to-do lists.
Recalculation is the process of recomputing values in a ___________.
spreadsheet
[Explanation]
When data is changed in one cell, data in other cells is automatically recalculated.
Word ____ is a special feature that automatically continues text on the next line when the user reaches the right margin.
Wrap
__________ is the process of moving up, down, or sideways through the text or other screen display.
Scrolling
The _______ displays menus and icons of commonly used commands and options.
toolbar
[Explanation]
In MS Windows, the toolbar is located at the top of the window below the menu bar.
CAD software is used to ______ products, maps, structures and civil engineering drawings.
design
[Explanation]
Drawings created with CAD (Computer Aided Design) software are 3D and can be rotated to view all sides.
What does CAD stand for?
Computer Aided Design
Dreamweaver, Macromedia Flash and MS FrontPage are all examples of web page ______ software.
design
[Explanation]
Web page design software allows users to create sophisticated web pages with multimedia features.
A ___________ is software that enables a user to find and access the various parts of the Internet.
web browser
[Explanation]
Popular web browsers include MS Internet Explorer, Netscape Navigator, and Mozilla Firefox.
Examples of graphics file _______ include BMP, GIF, JPEG, TIFF, and PNG.
formats
TIFF is a ________ file format used on both PCs and Macs for high quality printable files.
graphics
JPEG is a popular graphics file format used in applications such as web pages where flexibility in _________ is important.
file size
[Explanation]
The JPEG graphics format has built-in compression that can be adjusted by the user. Modifying the compression allows the user to control the resulting file size.
