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;
29 Cards in this Set
- Front
- Back
Database
|
a collection of data used for record retrieval and sorting
|
|
Sort Ascending
|
to sort data from least to greatest or from A to Z
|
|
Sort Descending
|
To sort data from greatest to least or from Z to A
|
|
File
|
A collection of related records in a database
|
|
Field
|
a category of information in a database, i.e. First Name, Last Name, Address, etc.
|
|
Design View
|
the view that allows you to change the layout, data type and properties of your database
|
|
Datasheet View
|
the view that shows all the data in your database in finished form
|
|
Record
|
A set of related data fields in a database; a row or tuple in a database
|
|
Sort
|
to arrange a set of data in a particular order
|
|
Filter
|
to retrieve data from a database based on a certain criteria or query
|
|
Query
|
to question or search a database for a particular criteria
|
|
Editing
|
to change or modify data within a database
|
|
Entry
|
a single piece of data in a database
|
|
File
|
a collection of related records in a database
|
|
Wildcard Character
|
an asterisk (*) used to represent data that is unknown or spelling may not be known
|
|
Primary Key
|
a unique identifier within a database that cannot be duplicated or repeated within a database, i.e. Social Security Number
|
|
Null Value
|
Containing no particular value or no value given
|
|
Criteria
|
a specific combination of values associated with data elements that allow you to select data according to your needs
|
|
Data
|
the information that is entered into the computer for processing
|
|
Date/Time Field
|
a 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.
|
|
Field Name
|
a label at the top of a database column that describes the kind of information to be stored in the column
|
|
Logical Field
|
a field that can be one of two entries, basically YES or NO or TRUE or FALSE.
|
|
Memo Field
|
a field used for information more than simple text, such as notes or comments.
|
|
Numeric Field
|
a field used to store purely numeric information
|
|
Object Field
|
a field used for 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 Number
|
the number that identifies the sequence of a record in a database.
|
|
Text Field
|
a field used to store alphanumeric information. You may also hear this type of field called a character field.
|
|
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).
|