Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
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

image

Play button

image

Play button

image

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