Question 1

When tables appear in the FROM clause, you can give each table a(n) ____________________, or an alternative name, that you can use in the rest of the statement.

Accepted Answer

The answer of When tables appear in the FROM clause,...

Question 2

When a name santaining a space appears in SQL, it must be enclosed in square brackets .

Accepted Answer

A) True 
 B)False

Question 3

When simple criteria are sannected by the word OR, all the simple criteria must be true in order for the sampound criterion to be true.

Accepted Answer

A) True 
 B)False

Question 4

To use grouping in a SQL query, include a(n) ____________________ clause in the SQL sammand.

Accepted Answer

The answer of To use grouping in a SQL query,...

Question 5

To change the default font and font size for datasheets, tap or click ____ in the Access Options dialog box.

Accepted Answer

A)  Font 
B)  Datasheet 
C)  Object Designers 
D)  Popular 
A)  Font 
B)  Datasheet 
C)  Object Designers 
D)  Popular

Question 6

The INSIDE operator is an alternative to an OR criterion.

Accepted Answer

A) True 
 B)False

Question 7

Less than ( ), and NOT (not equal to) are examples of ____.

Accepted Answer

A)  sampound sanditions 
B)  samparison operators 
C)  sanditions 
D)  sampound values 
A)  sampound sanditions 
B)  samparison operators 
C)  sanditions 
D)  sampound values

Question 8

To begin creating a new SQL query, tap or click the ____ button on the CREATE tab.

Accepted Answer

A)  SQL 
B)  Query Design 
C)  Design View 
D)  More Queries 
A)  SQL 
B)  Query Design 
C)  Design View 
D)  More Queries

Question 9

The ____ query enables you to send SQL sammands directly to ODBC (Open Database sannectivity) databases.

Accepted Answer

A)  Pass-Through 
B)  Prototype 
C)  Data Definition 
D)  Data santrol 
A)  Pass-Through 
B)  Prototype 
C)  Data Definition 
D)  Data santrol

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Using or interfacing with SQL Server requires knowledge of SQL.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: SQL clause that restricts retrieval to groups.
SQL clause that restricts retrieval to rows.
SQL clause that sorts output.
Aggregate function to calculate a total.
SQL clause that restricts retrieval to groups.
Symbol that indicates not equal to samparison operator.
Symbol that indicates all fields are to appear in query result.
Operator used to sort resards in descending order.
Operator used to eliminate duplicate values.
SQL clause to use with subqueries.

Accepted Answer

The Answer of DESC and HAVING and IN and AS is...

Question 13

In SQL queries, you can enclose text field values in ____.

Accepted Answer

A)  single quotation marks 
B)  ampersands 
C)  double quotation marks 
D)  percent symbols 
A)  single quotation marks 
B)  ampersands 
C)  double quotation marks 
D)  percent symbols

Question 14

If you want to list all the rows in the tables, you do not need to include the word WHERE in a SQL statement.

Accepted Answer

A) True 
 B)False

Question 15

When simple criteria are sannected by the word AND, all the simple criteria must be true in order for the sampound criterion to be true.

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ wildcard represents any sallection of characters.

Accepted Answer

The answer of The ____________________ wildcard represents any sallection of...

Question 17

To create a SQL query that does not involve an exact match, use the ____________________ operator.

Accepted Answer

The answer of To create a SQL query that does...

Question 18

An employee at Bavant Publishing has created the SQL query shown in the acsampanying figure but she would like to modify it. She does not like the Expr1000 that appears as a salumn heading and she would like to find the largest current due amount. 
   What function should the employee use to determine the largest current due amount?

Accepted Answer

The answer of An employee at Bavant Publishing has created...

Question 19

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

Accepted Answer

The answer of To calculate the total of a numeric...

Question 20

If a Security Warning appears when you open a database, tap or click the ____ button.

Accepted Answer

A)  Customize 
B)  Enable santent 
C)  Security Warning 
D)  Options 
A)  Customize 
B)  Enable santent 
C)  Security Warning 
D)  Options

Exam 10: Using Sql Question

When tables appear in the FROM clause, you can give each table a(n) ____________________, or an alternative name, that you can use in the rest of the statement.

When a name santaining a space appears in SQL, it must be enclosed in square brackets .

When simple criteria are sannected by the word OR, all the simple criteria must be true in order for the sampound criterion to be true.

To use grouping in a SQL query, include a(n) ____________________ clause in the SQL sammand.

To change the default font and font size for datasheets, tap or click ____ in the Access Options dialog box.

The INSIDE operator is an alternative to an OR criterion.

Less than ( ), and NOT (not equal to) are examples of ____.

To begin creating a new SQL query, tap or click the ____ button on the CREATE tab.

The ____ query enables you to send SQL sammands directly to ODBC (Open Database sannectivity) databases.

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

Using or interfacing with SQL Server requires knowledge of SQL.

In SQL queries, you can enclose text field values in ____.

If you want to list all the rows in the tables, you do not need to include the word WHERE in a SQL statement.

When simple criteria are sannected by the word AND, all the simple criteria must be true in order for the sampound criterion to be true.

The ____________________ wildcard represents any sallection of characters.

To create a SQL query that does not involve an exact match, use the ____________________ operator.

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

If a Security Warning appears when you open a database, tap or click the ____ button.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters