Database

Front 1

A collection of data (information) on a specific topic stored in an organized manner.

Back 1

DATABASE

Front 2

Organizing (sorting) information in order from smallest to largest, or A to Z.

Back 2

ASCENDING ORDER

Front 3

Organizing (sorting) information in order from largest to smallest, or Z to A.

Back 3

DESCENDING ORDER

Front 4

A single category of information for which data is given in each individual record.

Back 4

FIELD

Front 5

To narrow down the information within a database by searching for specific items.

Back 5

FILTER

Front 6

The operator symbol for at least

Back 6

>=

Front 7

The operator symbol for no more than

Back 7

< =

Front 8

A collection of fields and entries on one subject in the database.

Back 8

RECORD

Front 9

A row in a database is called a ________

Back 9

RECORD

Front 10

When deleting an entire record in a database you should click on the ________ to highlight the entire row before deleting.

Back 10

ROW HEADING

Front 11

A pattern or form that is used repeatedly for each record in a database file.

Back 11

TEMPLATE

Front 12

Clicking on a _____________ will highlight an entire row or column.

Back 12

HEADING

Front 13

The connector used to connect ALL criteria being searched for.

Back 13

AND

Front 14

The connector used to search for ANY of the criteria being searched for.

Back 14

OR

Front 15

What are 4 advantages of a database.

Back 15

1. Can find a specific file quickly
2. Can alphabetize quickly
3. Can sort data quickly
4. Can create many different types of reports

Front 16

When creating a new field, you should also always choose the field ____________

Back 16

TYPE

Front 17

Give 6 examples of field types.

Back 17

1. Whole number
2. Decimal number
3. Money
4. Date
5. Text
6. True/False

Front 18

What would be the operator for 20 or fewer?

Back 18

<=20

Front 19

To identify something in a database, you will do what operation?

Back 19

FILTER

Front 20

A request for information from a database.

Back 20

QUERY

Front 21

Which field type would you select to create check boxes?

Back 21

TRUE/FALSE

Front 22

Which field type would you select if the contents were dates displaying only the year?

Back 22

DATE (YYYY)

Front 23

Which field type would you select if the contents were dates displaying the month, day, and year?

Back 23

DATE (MM/DD/YYYY)

Front 24

What would be the operator for between the years 1999 and 2003?

Back 24

Is AFTER or EQUAL to 1999
AND
Is BEFORE or EQUAL to 2003

Front 25

What are the 2 ways commonly used to view a database?

Back 25

LIST VIEW

FORM VIEW

Front 26

Which database view can you see one record at a time?

Back 26

FORM VIEW

Front 27

Which database view allows you to see several records at once?

Back 27

LIST VIEW