Access 2007 (Tutorial 3)
Order by
51 terms
Terms | Definitions |
|---|---|
 Aggregate function | A function that performs an arithmetic operation on selected records in a database. |
| All Table | The default group of objects in the Access Navigation Pane. |
| Alternate Fill/Back Color button | The Access button that lets you change the alternating background color of a datasheet. |
| And logical operator | The logical operator you use in a query when you want a record selected only if two or more conditions are met. |
| AutoFilter | An Access feature that enables you to quickly sort and display field values in various ways. |
| Calculated field | A fields that displays the results of an expression in a query datasheet or a form or report, but does not exists as a field in the database. |
| Comparison operator | In a query, an operator that asks Access to compare the value in a database field to a condition value and to select all the records for which the relationship is true. |
| Condition | A criterion, or rule, that determines which records are selected in a query. |
| Datasheet selector | A box in the upper-left corner of a datasheet that lets you select the entire datasheet. |
| Design grid | The portion of the Query window in Design view in which you specify the fields and record selection criteria for the query you are creating. |
| Editing mode | The mode in which you can insert or delete characters in a field value based on the location of the insertion point. |
| Exact match | A type of query in which the value in the specified field must match the condition exactly in order for the record to be included in the query results. |
| Expand indicator | In a datasheet, the plus sign that lets you display the related records in the subdatasheet. |
| Expression | A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation. |
| Expression builder | An Access tool that makes it easy for you to create an expression in a query by providing boxes for entering the expression, buttons for common operators, and lists of expression elements, such as tables and field names. |
| F2 key | The function key you press to switch between navigation mode and editing mode. |
| Field list | A small window listing the fields contained in a table. |
| Filter | A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of records. |
| Filter By Form | A filtering technique that changes the datasheet to display empty fields, allowing you to select a value from a list in any blank field to apply a filter that selects only those records containing that value. |
| Filter By Selection | A filtering technique that lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field. |
| Find command | A command you use to serach for data in a form or datasheet so that you can display only those records you want to view. |
| Group by Operator | In a query, an operator that divides the selected records into groups based on the values in the specified field. |
| Logical operator | In a query, an operator that allows you to combine two or more conditions. |
| Maintain (a database) | To add, change, and delete records in database tables to keep them current and accurate. |
| Navigation mode | The mode in which Access selects an entire field value, and your typed entry replaces the highlighted field value. |
| Nonunique sort field | A sort field for which more than one records can have the same value. |
| Or logical operator | The logical operator you use in a query when you want a record selected if at least one of the specified conditions is met. |
| Plus sign | In a datasheet, a symbol indicating that records have related records in another table. |
| Primary sort field | The first sort field specified that determines the order of records in a datasheet. |
| Query by example (QBE) | An example of the information you are requesting from Access in a query. |
| Query Wizard | An Access tool that asks you a series of questions, and then creates a query based on your answers. |
| Recordset | The set of records that results from running a query. |
| Run (a query) | To answer a query and display the results. |
| Secondary sort field | A second field that determines the order of records that are already sorted by the primary sort field. |
| Select query | A query in which you specify the fields and records you want Access to select, and the results are returned in the form of a datasheet. |
| Sort | To rearrange records in a specified order or sequence. |
| Sort field | The field used to determine the order or records in a datasheet. |
| Subdatasheet | A datasheet that displays the records related to the current record. |
| Tables and Related Views | The default category of objects in the Access Navigation Pane. |
| Unique sort field | A sort field whose value is different for each record. |
| Update (a database) | To add, change, and delete records in database tables to keep them current and accurate. |
| Zoom box | A large text box you can use to enter text, expressions, or other values when working with queries. |
| = | Comparison operator meaning equal to (optional; default operator) |
| < | Comparison operator meaning less than. |
| <= | Comparison operator meaning less than or equal to. |
| > | Comparison operator meaning greater than. |
| >= | Comparison operator meaning greater than or equal to. |
| < > | Comparison operator meaning not equal to. |
| Between...And... | Comparison operator meaning between two values (inclusive) |
| In ( ) | Comparison operator meaning in a list of values |
| Like | Comparison operator that matches a pattern that includes wildcards. |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.