• Shuffle
Toggle On
Toggle Off
• Alphabetize
Toggle On
Toggle Off
• Front First
Toggle On
Toggle Off
• Both Sides
Toggle On
Toggle Off
Toggle On
Toggle Off
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

Play button

Play button

Progress

1/24

Click to flip

24 Cards in this Set

• Front
• Back
 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 Number field. AVG 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 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 Number field. SUM 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