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 1/13/04 |