Infotech English For Computer Users Student's Book - Unit 15

¡Supera tus tareas y exámenes ahora con Quizwiz!

A spreadsheet displays information in the form of a table with a lot of columns and rows - TRUE/FALSE

TRUE

If you type the value 800 in C3, the value in cells C5 and C12 will be recalculated - TRUE/FALSE

TRUE

Spreadsheet programs can generate a variety of charts and graphs - TRUE/FALSE

TRUE

The value of the cell C12 is the result of applying the formula C5-C10 - TRUE/FALSE

TRUE

Each field holds _____

a separate piece of information

A collection of data stored in a PC in a systematic way

database

A _____ is a collection of related data, and the software used in databases to store, organize and retrieve the data is called the _____ , or _____

database database management system DBMS

_______________ 2GB of RAM, 1TB HD Colour 19" 2GB of RAM, 250GB HD DBMS, relational database Anti-virus, anti-spyware 2,400 dpi, PostScript

description

A single piece of information in a record

field

Information is entered into a database via _____

fields

Information is entered into the database via _____. Each field holds a separate piece of information, and the fields are grouped together in _____

fields records

Records are grouped together into _____ which hold large amounts of information

files

A database program lets you create an _____ - a list of records ordered according to the content of certain fields

index

Updating a file means _____

making changes, adding news records or deleting old ones

Some companies have several computers sharing as database over a _____

network

The best database packages also include _____ facilities, which can make businesses more productive

network

_______________ 850€ 170€ 975€ 245€ 60€ 230€ Sub-total (21%)

price

_______________ Ulysses Classic Flat LCD screen Portable Ulysses D5 database Antidote JP Laser printer CQ

product

_______________ 4 4 2 1 6 1

quantify

A database _____ function allows you to extract information according to certain conditions or criteria

query

A tool that allows you to extract information that meets certain criteria

query

A unit of a database file made up of related fields

record

A _____ database maintains separate, related files, but combines data elements from the files for queries and reports

relational

Modern databases are _____ - that is, they are made up of related files: customers and orders, vendors and purchases, students and tutors, etc

relational

To look for specific information, for example the name of an employee

search

This helps you to _____ the database and _____ records into numerical or alphabetical order very quickly

search sort

Most aspects of the program can be protected by user-defined passwords and other _____

security devices

Files can easily be _____ - you can always change fields, add new records or delete old ones

updated

Access to a common database over a network can be protected by using _____

user-defined passwords and other security devices

However, technically, a _____ is a collection of cells grouped on a single layer of the file

worksheet

This worksheet shows the income and expenses of a company. Amounts are given in $millions. The terms _____ and _____ are often used interchangeably

worksheet spreadsheet

Spreadsheets cannot be used as databases - TRUE/FALSE

FALSE

The value of cell B5 is the result of adding the value in cells B2 and B3 - TRUE/FALSE

FALSE

You cannot change the width of columns - TRUE/FALSE

FALSE

In a spreadsheet you can only enter numbers and formulae - TRUE/FALSE

FALSE

To classify records into numerical or alphabetical order

sort

A _____ refers to both the computer program that displays data in rows and columns, and to the table which displays numbers in rows and columns

spreadsheet

A database management system is used to _____

store organize and rentrieve information from a database


Conjuntos de estudio relacionados

Restraint Alternative and Safe Restraint Use

View Set

CSE 3 Personal Computers Midterm 1

View Set

Intro to Sociology -- Chapter 11

View Set

The Renaissance in Quattrocento Italy

View Set

Phlebotomy National Exam Practice

View Set

CH. 1 Legal Frameworks Midterm Review

View Set

IBM (Chapter 10 Connect Assignment)

View Set