databasec
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
Ascending | sorting from smallest to largest. Example: A-Z or 0-9.
🗑
|
||||
Connectors | words like OR and AND used in searching databases which indicate whether records satisfy one rule (OR) or if both rules must be satisfied (AND).
🗑
|
||||
Counter Field | used in many databases to identify each record uniquely, like creating a unique invoice number in an invoice database. Also known as a Primary Key in some programs.
🗑
|
||||
Data | the information that is entered into the computer for processing.
🗑
|
||||
Database | an electronic filing system that stores and retrieves information.
🗑
|
||||
Database Report | allows one to organize, summarize, and print selected portions of a database.
🗑
|
||||
Datasheet View | displays the table in a row-and-column format.
🗑
|
||||
Data Type (Format) | the different types of data entered in a database, i.e., number, text, date/time, etc.
🗑
|
||||
Date and Time Field | used for storing dates and times in a specific format to allow you to do such things as age an account or time an event.
🗑
|
||||
Descending | sorting from largest to smallest. Example: Z-A or 9-0.
🗑
|
||||
Design View | displays the field names and what kind of values you can enter in each field. In this view you can define or modify the field formats and create field names and data types for a database.
🗑
|
||||
Editing | to make changes to the information in a database.
🗑
|
||||
Enter/Entering | to type information into a field in a database.
🗑
|
||||
Entry | the information that is entered in the fields in a database.
🗑
|
||||
Field | a category of information in a database.
🗑
|
||||
Field Name | a label at the top of a database column that describes the kind of information to be stored in the column.
🗑
|
||||
File | a group of records. Also known as a Table in some programs.
🗑
|
||||
Filter/Query/Search | a feature that displays records that meet one or more specific criteria. Form View
🗑
|
||||
List View | displaying more than one record at a time.
🗑
|
||||
Logical Field | can be one of two entries, basically YES or NO (or ON or OFF or TRUE or FALSE).
🗑
|
||||
Memo Field | used for information that does not fit easily into a category such as notes or comments.
🗑
|
||||
Numeric Field | used to store purely numeric information.
🗑
|
||||
Object Field | used for other media types that might include a picture of an employee or product, a sound file, a clip-art image, or any other type of non-text entry.
🗑
|
||||
Operators | words or symbols such as less than (<), greater than (>), or equal to (=).
🗑
|
||||
Record | a complete set of field entries.
🗑
|
||||
Record Number | the number that identifies the sequence of a record in a database.
🗑
|
||||
Report | a display of records or parts of records that satisfy a particular search or sort.
🗑
|
||||
Sorting | arranging information in alphabetical or numerical order.
🗑
|
||||
Text Field | used to store alphanumeric information. You may also hear this type of field called a character field.
🗑
|
||||
Wildcards | The * symbol or asterisk is considered a wildcard character. If you don’t know the spelling of a word or you want to search plurals or variations of a word, use the wildcard character.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
spencercte
Popular Computers sets