Database Vocab    (first, second, third)      (6th Grade)

< - less than

<= - less than or equal to; at most

= - equal to

=> - greater than or equal to; at least

> - greater than

AND - need to meet both criteria, less answers

Ascend - alphabetical order, A-Z, 1-10

At least � greater than or equal to

At most � less than or equal to

Connector - AND/OR/NOT, words that join conditions together

Contains - used with words to show that the field should �contain� these characters

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.

Database - an organized collection of related information

Database File - the whole thing, all of the records put together.  Also known as a table

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

Descend - backwards, Z-A, 10-1

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

Entry - data that is typed into the field

Field - a category of information;

Field Name � a label at the top of a database column that describes the kind of information to be stored in the column

Field to compare - where to look for the value

Find - a way to get information that is unique - only used when searching for unique words

Form View � used to display/design one record at a time and/or to enter information, can include pictures, borders, or special formatting

How to compare - <, >, =, <=, =>, contains (words)

List View � displaying more than one record at a time

Logical Field � can be one of two entries, basically YES or NO (or ON/OFF or TRUE/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 field, 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 (=)

OR - only meet one criteria, more answers

Query/Search - a method to find specific data that meets certain conditions or criteria

Record - all of the information about one item, all of the fields put together

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

Sort - arrange data in a particular order

Text Field � used to store alphanumeric information.  You may also hear this type of field called a character field

Value to compare - word/# that you are looking for

Wildcards � the * 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

Hosted by