DATABASE 2
Terms
undefined, object
copy deck
- 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