Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
27 Cards in this Set
- Front
- Back
A collection of data (information) on a specific topic stored in an organized manner.
|
DATABASE
|
|
Organizing (sorting) information in order from smallest to largest, or A to Z.
|
ASCENDING ORDER
|
|
Organizing (sorting) information in order from largest to smallest, or Z to A.
|
DESCENDING ORDER
|
|
A single category of information for which data is given in each individual record.
|
FIELD
|
|
To narrow down the information within a database by searching for specific items.
|
FILTER
|
|
The operator symbol for at least
|
>=
|
|
The operator symbol for no more than
|
< =
|
|
A collection of fields and entries on one subject in the database.
|
RECORD
|
|
A row in a database is called a ________
|
RECORD
|
|
When deleting an entire record in a database you should click on the ________ to highlight the entire row before deleting.
|
ROW HEADING
|
|
A pattern or form that is used repeatedly for each record in a database file.
|
TEMPLATE
|
|
Clicking on a _____________ will highlight an entire row or column.
|
HEADING
|
|
The connector used to connect ALL criteria being searched for.
|
AND
|
|
The connector used to search for ANY of the criteria being searched for.
|
OR
|
|
What are 4 advantages of a database.
|
1. Can find a specific file quickly
2. Can alphabetize quickly 3. Can sort data quickly 4. Can create many different types of reports |
|
When creating a new field, you should also always choose the field ____________
|
TYPE
|
|
Give 6 examples of field types.
|
1. Whole number
2. Decimal number 3. Money 4. Date 5. Text 6. True/False |
|
What would be the operator for 20 or fewer?
|
<=20
|
|
To identify something in a database, you will do what operation?
|
FILTER
|
|
A request for information from a database.
|
QUERY
|
|
Which field type would you select to create check boxes?
|
TRUE/FALSE
|
|
Which field type would you select if the contents were dates displaying only the year?
|
DATE (YYYY)
|
|
Which field type would you select if the contents were dates displaying the month, day, and year?
|
DATE (MM/DD/YYYY)
|
|
What would be the operator for between the years 1999 and 2003?
|
Is AFTER or EQUAL to 1999
AND Is BEFORE or EQUAL to 2003 |
|
What are the 2 ways commonly used to view a database?
|
LIST VIEW
FORM VIEW |
|
Which database view can you see one record at a time?
|
FORM VIEW
|
|
Which database view allows you to see several records at once?
|
LIST VIEW
|