Database Essentials 1

1. How do you write the mathematical operator "equal to or greater than"?

=&

=>

=

=+

2. What is the arrangement of data in a field in alphabetical order?

Filing

Numbering

Searching

Sorting

3. What type of software is designed to act as an electronic filing cabinet organizing collections of data?

Database

Desktop publishing

Spreadsheet

Word processing

4. Which is NOT true about database programs?

Are an excellent way to organize information

Can be printed

Can find information quickly

Can only hold up to 100 records

5. How would you find the phone number of one particular student from 500 names and addresses of students enrolled at your school?

Perform a search of all boys in the database

Perform a search using the student's name as the criteria

Sort the database and scroll through the records

Sort the database in descending order

6. What does descending order mean?

A to Z alphabetical order

Connecting order

Search numerical order

Z to A alphabetical order

7. How do you write the mathematical operator "less than"?

=/

=

>

8. Why would a travel agent use a database?

Communicate with cruise ships

Forecast the summer season

Get airline schedules for clients

Print vacation brochures

9. Which is NOT a field type to consider when creating a database?

Date

Item

Number

Text

10. What item could an electronic database be compared to?

Copier

Fax machine

File cabinet

Telephone

11. In a database containing information about North Carolina and its counties, how would you find the county with the most people?

Filter the population field using >10,000

Rank the counties by name and scroll through the list

Search each county record

Sort the records by population in descending order

12. If books are organized from the most expensive to the cheapest, what is the sort order?

Ascending

Criterion

Descending

Numerical

13. What is NOT a reason a business might use a computerized database?

Designing a brochure for advertising purposes

Keeping an appointment calendar with patients or customers

Keeping their inventory up to date

Maintaining a list of loyal customers

14. If you had a database of names and phone numbers, what would LAST NAME, FIRST NAME, and PHONE NUMBER be examples of?

Data

Entries

Fields

Records

15. What operator would you use for the word "exceeds"?

>

=>

=

16. When creating a database about African countries, what type of field would the square miles (land size) be?

Logical

Miles

Number

Text

17. What feature displays records that meet a specific criteria from a database?

Edit

Filter

Recall

View

18. What is a wildcard?

A character to take the place of an unknown

A symbol such as

A way of sorting values in a deck of cards

An ace of spades

19. What is a group of related fields known as?

Characters

Data

Files

Records

20. Why might a student use an electronic database?

Average his or her grades for math class

Keep tract of friends' names and addresses

Send an e-mail message to his or her parents

Write a report for a history class

21. What is another term for the categories when creating a database?

Entry

Field

File

Record

22. Which operator would you use for the words "at most"?

>

=>

=

23. What are the four parts of a database listed in ascending order?

Entry, field, file, record

Entry, field, record, file

File, field, entry, record

File, record, field, entry

24. What term applies to a collection of related records in a database?

Clipboard

Field

File

Form

25. What do you call words like "and" and "or" when you are filtering, querying, or searching records?

Commands

Connectors

Forms

Operators