Unit 5

Key Field

the primary field used to uniquely identify records. It may be used to sort records in alphabetical order.

Query

to ask a question about data

Export

to move a file out of one application to another application

A wizard only allows data that matches certain conditions to pass through.

False

Before you start creating a database, you should first use paper to plan, test, and revise.

True

Field

one of the categories in a database record, such as last name. They correspond to columns in a table.

Sort means to arrange in a certain order.

true

Carolyn would like to store and retrieve data about products in her catalogue. She should use a _____. 1. database 2. word processor 3. spreadsheet 4. invoice

1

Use comparison operators to write a question that the database will understand. Which records contain "no"? 1. =no 2. < > no 3. =yes 4. is no

1

Select all actions that a database may perform. 1) Update information in more than one place at the same time. 2) Write a business letter. 3) Create data entry forms. 4) Find the average of four numbers. 5) Validate the data entered and check for inconsistencies. 6) Sort and manipulate the data in the database. 7) Conduct a query.

1 3 5 6 7

If you were looking for a record in a very large database and you knew the ID number, which of the following would be the most direct way to locate the record? 1. sort 2. find 3. locate 4. filter

2

If you have a database with birthdates, and you would like to find everyone who was born before June 16, 1967, what would you enter? 1. < > June 16, 1967 2. is June 16, 1967 3. < June 16, 1967 4. > June 16, 1967

3

Kevin needs to get his data from a database into a text file to send to another group. He needs to _____. 1. import 2. sort 3. export 4. link

3

Sarah wants to calculate how much of a profit she would make on producing and selling a new product. Sarah should use a _____. 1. database 2. word processor 3. spreadsheet 4. data entry form

3

Use comparison operators to write a question that the database will understand. Which records are more than or the same as twenty? 1. < 20 2. > 20 3. > =20 4. < =20

3

You would like to arrange the records alphabetically. You would _____. 1. delete a record 2. locate a record 3. sort 4. update

3

Nicole wants to create a database to collect information about sales transactions. She would like to use the database to look up customer names and sales prices if they return a product. She would also like to retrieve their credit card number in order to reimburse them. In addition, she would like to sort the items in the database by product number. What fields should she have in her database? 1. product number, product description, and sales price 2. product description, sales price, and employee name 3. last name, first name, telephone number, and address 4. name, credit card number, product number, and sales price

4

Sharon wants to import data from an old database into a new database. She notices some of the field names are different. Sharon will need to _____. 1. link 2. export 3. merge 4. map

4

You need to provide data to your client in a format that they can read. You will need to _____ the data. 1. map 2. import 3. filter 4. export

4

If you wanted the item that cost the least at the top of the table, you would sort in descending order.

False

Importing data is sending data to a new file.

False

Record

one set of data or complete entry in a database. They correspond to rows in a table

Ben keeps a database for employee contact information. One of his employee's address changed. Ben needs to _____. 1. update the record by editing the address field 2. delete the record and insert a new record 3. delete the address field 4. clear the address field

1

A spreadsheet is a software program for storing, managing, and retrieving information.

False

A query is a way to find answers to questions about the data.

True

Text File

a file that is created with a text editor and contains only printable letters, numbers, and symbols; no formatting

File

a group of records

Database

a software program for storing, managing, and retrieving information

Mapping

identifying relationships between data

Import

move a file into one application from another application

Table

rows and columns that are used for organizing data