Exam 8: Using SQL

To add records to a table, use the SQL _____ command.

If a criterion involves a date field, the value must be enclosed in curly braces { }.

To delete records in SQL, use the _____ command.

If a criterion involves a text field, the value must be enclosed in single or double quotation marks.

The accompanying figure shows a query result that is sorted by amount paid within business analyst. Amount Paid is the ____________________ sort key.

To begin creating a new SQL query, click the _____ button on the Create tab.

When two fields have the same name in more than one table, such as Client Number, you must ____________________ the field name.

To display a blank window to begin typing SQL commands, click _____ on the View menu.

The accompanying figure shows a SQL query to join two tables. In the query, it is necessary to _____ the Business Analyst Number because it appears in more than one table.

It is possible to place one query inside another. An inner query that is evaluated first is called a(n) ____________________.

SQL has special format rules for placement of terms and capitalization.

To enter a new SQL query after viewing the results of a query, click the View button arrow and then click _____ on the View button menu.

To sort data in descending order, follow a sort key with the word _____.

Queries that you construct in both Design view and SQL view require that the major sort key is to the left of the minor sort key in the list of fields to be included.

To change the default font and font size for datasheets, use the ____________________ dialog box.

Modified Multiple Choice Compound criteria are formed by connecting two or more simple criteria using _____.

Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.

To change the default font and/or font size for queries, click the Options button in the Backstage view and then click ____________________ in the Access Options dialog box.

When you create a basic SELECT-FROM-WHERE expression in SQL, a list of ____________________(s) follows the word FROM.