Term
|
Definition
|
|
Term
|
Definition
| To find numbers greater than or equal to 500, use which comparison operator? |
|
|
Term
|
Definition
| When referencing field names within an expression, surround the field name with ____. |
|
|
Term
|
Definition
| Which of the following is the correct expression to count the number of records using a field named City? |
|
|
Term
|
Definition
The wildcard character that stands for any group of characters is the ____. |
|
|
Term
| AT THE TOP OF EVERY PAGE (BUT BELOW THE REPORT HEADER ON PAGE ONE) |
|
Definition
| The Page Header section prints ____. |
|
|
Term
|
Definition
| Which of the following would most likely be used to display a Yes/No field on a form? |
|
|
Term
|
Definition
| Which technique would you use to select several controls in Form Design View? |
|
|
Term
|
Definition
| This control provides an easy way to initiate a command or run a macro. |
|
|
Term
|
Definition
| This control provides an easy way to initiate a command or run a macro. |
|
|
Term
|
Definition
| Which of the following is NOT a way to create a new form? |
|
|
Term
|
Definition
| Click the ____ View button from Query Design View to display the resulting fields and records from a query. |
|
|
Term
|
Definition
| Sorting in a Z to A, then 9 to 0 order is called a(n) ____ order. |
|
|
Term
|
Definition
| Text boxes bound to underlying fields are generally placed in this report section. |
|
|
Term
|
Definition
| A(n) ____ is a temporary view of the data whose criteria are discarded when you close the datasheet. |
|
|
Term
|
Definition
| After making modifications in Form Design View, click the ____ View button to view the form and enter data. |
|
|
Term
|
Definition
| After making modifications in Form Design View, click the ____ View button to view the form and enter data. |
|
|
Term
|
Definition
| A text box control bound to the field by which the records are grouped would most likely be found in which report section? |
|
|
Term
| GROUP HEADER AND GROUP FOOTER |
|
Definition
| Which two sections can be added to a report if you group records? |
|
|
Term
|
Definition
| The Group Header and Group Footer section can be turned on or off in which pane? |
|
|
Term
|
Definition
| ____ will find all records where there is any entry in the field, even if the entry is 0. |
|
|
Term
|
Definition
| This control is used to provide consistent descriptive text as you navigate from record to record. |
|
|
Term
|
Definition
| Which control is most commonly placed in the Report Header section? |
|
|
Term
|
Definition
| Which of the following is NOT a bound control? |
|
|
Term
|
Definition
| In Form Design View, you use the white arrow pointer to ____ controls. |
|
|
Term
|
Definition
| This button filters records that equal, do not equal, or are otherwise compared to the current value. |
|
|
Term
|
Definition
| Which of the following is NOT a common use for an Access report? |
|
|
Term
|
Definition
| Which control, when "pressed" displays "yes" information? |
|
|
Term
|
Definition
| The _______ button control provides an easy way to run a macro. |
|
|
Term
|
Definition
| Limiting conditions used to narrow the number of records on a datasheet |
|
|
Term
|
Definition
| Text boxes that display data in underlying records are generally placed in a report's _____ section. |
|
|
Term
|
Definition
| Text boxes that display data in underlying records are generally placed in a report's ________ section. |
|
|
Term
|
Definition
| The upper portion of Query Design View shows a table's ________ list. |
|
|
Term
|
Definition
| In Form Design View, the ______ List contains the database tables and fields from the record source. |
|
|
Term
|
Definition
| Creates a temporary subset of records |
|
|
Term
|
Definition
| In Query Design View, the query design ______ shows you the fields that you have requested for the query. |
|
|
Term
|
Definition
| The term ______ refers to sorting records plus providing a section before and after the group of records. |
|
|
Term
|
Definition
| Criterion that finds all records where no entry has been made in the field |
|
|
Term
|
Definition
| Paper orientation that is 11" wide by 8.5" tall is referred to as ______ orientation. |
|
|
Term
|
Definition
| Is ______ criteria will find all records where no entry has been made in the field. |
|
|
Term
|
Definition
| By default, records in a table datasheet are sorted on the _____ key field. |
|
|
Term
|
Definition
| Creates a datasheet of selected fields and records from one or more tables |
|
|
Term
|
Definition
| The lower pane in Query Design View |
|
|
Term
|
Definition
| A(n)______ is an Access object whose primary purpose is to create professional printouts. |
|
|
Term
|
Definition
| Putting records in ascending or descending order based on a field’s values |
|
|
Term
|
Definition
| Rules that determine how criteria is entered |
|
|
Term
|
Definition
| Calculated expressions are entered in _____ box controls. |
|
|
Term
|
Definition
| The ___ button control displays "yes" or "no" answers for a field. |
|
|
Term
|
Definition
| [Ctrl][Z] is the quick keystroke for the ______ command. |
|
|
Term
|
Definition
| Used to search for a pattern |
|
|
Term
|
Definition
| _____ are symbols you can use as substitutes for characters to find information that matches your find criteria. |
|
|
Term
|
Definition
| SQL is the acronym for “simple query language”. TRUE or FALSE? |
|
|
Term
|
Definition
| Once you have filtered a datasheet to display a subset of records, you cannot sort the records. TRUE or FALSE? |
|
|
Term
|
Definition
| A filter can be used to create calculated fields. TRUE or FALSE? |
|
|
Term
|
Definition
| A filter cannot be saved as a query. TRUE or FALSE? |
|
|
Term
|
Definition
| You would use line and rectangle controls to add data to a form. TRUE or FALSE? |
|
|
Term
|
Definition
| A calculation can begin with a <>, >, or equal sign. TRUE or FALSE? |
|
|
Term
|
Definition
| In Form Design View, the pointer that looks like a white arrow will move records. TRUE or FALSE? |
|
|
Term
|
Definition
| Forms have more sections than reports do. TRUE or FALSE? |
|
|
Term
|
Definition
| If a multicolored report is printed on a black and white printer, its colors will stay true. TRUE or FALSE? |
|
|
Term
|
Definition
| The Find and Replace dialog box allows you to specify whether Access looks for search criteria in a single field or in the entire datasheet. TRUE or FALSE? |
|
|
Term
|
Definition
| Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field. TRUE or FALSE? |
|
|
Term
|
Definition
| A query can be used to create calculated fields. TRUE or FALSE? |
|
|
Term
|
Definition
| On a form, text box controls display data from an underlying record source. TRUE or FALSE? |
|
|
Term
|
Definition
| The Report Wizard applies many formatting choices to a report. TRUE or FALSE? |
|
|
Term
|
Definition
| Calculated expressions within text boxes start with an equal sign. TRUE or FALSE? |
|
|
