Access-Project 2
Terms
undefined, object
copy deck
- Less than (<), greater than (>), and NOT (not equal to) are examples of____.
- comparison operators
- To omit duplicates from a query, use the Properties command and change the Unique Values property to ___.
- yes
- To include the Total row in the design grid, right-click the grid, and then click __ on the shortcut menu.
- Totals
- To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ___.
- zoom
- To use a built-in statistic in a query, include the statistic in the ___ row in the design grid.
- Total
- To find the largest warranty amount for a marina, select ___ as the entry in the Totals row for the Warranty column.
- MAX
- To save a query, click the ___button on the toolbar after the query has been created and then assign a name to the query.
- save
- To execute or run a query, click the __ button on the Query Design toolbar.
- Run
- To calculate the total warranty amount for clients of technician 36, select ___ as the entry in the Total row for the Warranty column, select Where as the entry in the Total row for the Tech number column, and enter 36 in the Criteria row for the Tech Nu
- SUM
- the wildcard symbols availalbe for use in a query are the ___ and the ___.
- question mark and asterisk
- To indicate grouping in Access, select ___ as the entry in the Total row for the field to be used for grouping.
- Group By
- When an expression is entered for a calculated field, the field name used in the expression must be enclosed in ___.
- square brackets
- Use a query to __ tables; that is to find record in two tables taht have identical values in matching fields.
- join
- If the wrong field is placed in the grid inadvertently, click Delete on the __ menu to remove it.
- Edit
- The general name for the type of approach that Access uses for querying a database is QBE, which means_____
- Query-by-Example
- The set of records that make up the answer to a query will be displayed in __ view.
- Datasheet
- to clear all the entries in the design grid, click ___ on the Edit menu.
- Clear Grid
- To add an additional table to a query, click __ on the shortcut menu for the upper pane of the Select Query window.
- show table
- You create a query by making entries in a special window called a_________window.
- Select Query
- To find all marinas whos warranty amount is $1,500.00, enter ___ in the Criteria row of the Warranty column in the accompanying figure.
- 1500
- To find all marinas whose names begin with Ne, enter ___ in the Criteria row of he Name column in the accompanying figure.
- Like Ne*
- To find all marinas whose non-warranty amount is greater than $100.00, enter ____ in the Criteria row of the Non-Warranty column in the accompanying figure.
- >100
- To find all marinas whose name is either Elend Marina or Elent Marina, enter ___ in the Criteria row of the Name column in the accompanying figure.
- Like Elen? Marina