How can we help?

You can also find more resources in our Help Center.

31 terms

6.00 Database Software

STUDY
PLAY
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 satisfies (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 filling 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 specific format to allow you to do such things as age an account or time 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
displaying one record at a time
List View
displaying more than one record at a time
Logical View
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