Exam 8: Using SQL

To sort output in a SQL statement, use the ORDER BY clause.

When simple criteria are connected by the word _____, all the simple criteria must be true in order for the compound criterion to be true.

You cannot use copy and paste commands when you enter SQL commands.

To calculate the total of a numeric column, such as Amount Paid, use the ____________________ function.

To receive context-sensitive help on any of the keywords in a SQL query, click anywhere in the word about which you wish to obtain help, and then press F 5.

The UNIQUE operator eliminates duplicate values in the results of a query.

When simple criteria involve a numeric field, you type only the number, not commas or dollar signs.

To quit Access, click the ____ button on the right side of the Access title bar.

To sort in descending order, follow the name of the sort key with the DESC operator.

SQL is an abbreviation for Standard Query Language.

To change the font size for SQL queries, click File on the Ribbon, click Options in the Backstage view, and then click _____ in the Access Options dialog box.

To save a query, click the Save button on the Quick Access Toolbar.

When simple criteria are connected by the word _____, the compound criterion will be true whenever any of the simple criteria are true.

Because it is a common convention, and necessary in some version of SQL, place a semicolon (;) at the end of each SQL command.

To view the results of a SQL query, type the SQL statement and then click the _____ button to view the results.

The accompanying figure shows a SQL query to join two tables. A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n) _____ join.

You want to create a query that joins two tables. What three steps should you follow when you create the query?

The _____ query combines fields from more than one table into one query set.

To use the word NOT in a criterion, follow the criterion with the word NOT.