| A | B |
|---|
| Alternative input methords | Methods of data imput other than traditional keyboard/mouse which use programs such as speech or handwriting recognition or features of PDAs |
| Arithmetic operators | Symbols used in mathematical expressions in queries to retrieve information from a database (Ex +, -, *, /) |
| Arrange | Placing data in a particular order |
| Ascending | Arranging data in A-Z or smallest to largest number order |
| Calculated column/field | A column or field containing data created by using a formula |
| Calculation | The process of computing data using formulas |
| Character or text data | Entries in a database or spreadsheet that represent text--such as phone numbers, names, color, size |
| Column width | The amount of space given a field or column |
| Columns | Vertical sections of the database table; corresponds to a field |
| Comparison Operators | Used in mathematical expressions in queries to compare pairs of values (ex: <, >, =) |
| Criteria expression | Used in a query to identify what information to retrieve from a database |
| Currency | Numeric type of data which adds a $ sign to the number. Also allows the number of decimals displayed to be determined |
| Data | Information keyed into a database; also known as an entry |
| Database | An efficient means of storing and retrieving data and printing reports from the stored data |
| Database Management System | A package of computer programs and documentation that lets someone establish and use a database; allows one to store and retrieve data according to his/her own criteria. (Example: Access) |
| Datasheet View | A method of viewing or inputting data that contains information about more than one record at a time; table with rows (records) and columns (fields); also known as list view |
| Date data | Entries in a database or spreadsheet that are formatted for a date in a particular style (ex: 01/01/00 or January 1, 2008) |
| Default | Preset conditions of the software which may be modified |
| Descending | Process of arranging data in Z-A or largest number to smallest number order |
| Design | Process of determining fields, field properties, and data types in a database |
| Edit | Change or modify the original entry |
| Entry | Data and formulas that are typed in a field |
| Field | one item of information in a record; represented by a column |
| Field naume | Title assigned to each field |
| Field properties | Additional design information about a database, such as field size, decimal places, and format |
| File | A saved database |
| Font | Group of characters (letters, numbers, and symbols) with a similar appearance |
| Footer | Repetitive text automatically printed at the bottom of a document, such as a page number |
| Form | Customized document to input data into a database or present data on a screen one record at a time |
| Form view | Customized manner of inputting data into a database or presenting data on the screen by viewing a form and putting data of only one record into each form |
| Format | Defining how information appears on a page |
| Header | Repetitive information that is automatically printed at the top of each page of a document |
| Key | Identifier for each record; data entry cannot be duplicated (Ex: Social Security number, part number); also known as Primary Key |
| Landscape | Page orientation (layout) that is wider than tall; horizontal |
| List View | Method of viewing or inputting data that contains information about more than one record at a time; a table with rows (records) and columns (fields); Also known as datasheet view |
| Numeric data | Entries in a database or spreadsheet that are formatted for numbers that can be used in calculations |
| Percent | A numeric type of data which adds a % symbol to a number |
| Primary sort | Method of sorting a column of data in a particular order by selecting the field to consider first when sorting |
| Query | Request for information from a database based on certain criteria |
| Record | Group of related fields of information; Everything on one row |
| Report | Specifications for output of data in a particular format |
| Retrieve | Loading information that has been stored |
| Right justified | Alignment that allows a document to have an even right margin |
| Row | Horizontal section of a database table; corresponds to a record in a database |
| Save | Storing a file on a disk or other storage medium for future use |
| Seach | Request to find a string of characters or particular data in a document |
| Secondary Sort | When sorting columns of data, the second column to consider when arranging given data |
| Sort | Arranging data ni a particular order |
| Table wizard | Feature that provides samples of tables, each with its own appropriate fields, which may be formatted in the document |
| Update | Add or change data in a document |
