Question 1

If you type the last 2 digits of a year as 13, such as 1/1/13, Access assumes that they signify:

Accepted Answer

A)  1813 
B)  1913 
C)  2013 
D)  You must type 4 digits for year data. 
A)  1813 
B)  1913 
C)  2013 
D)  You must type 4 digits for year data. C

Question 2

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Accepted Answer

A) True 
 B)False  False

Question 3

Which query criteria are equivalent to "Marketing" ?

Accepted Answer

A)  "marketing" 
B)  "MARKETING" 
C)  "mArKeTiNg" 
D)  All of the above 
A)  "marketing" 
B)  "MARKETING" 
C)  "mArKeTiNg" 
D)  All of the above D

Question 4

In the figure above, the parameter criteria is ____.

Accepted Answer

A)  Descending 
B)  Group By 
C)  5 
D)  There is no parameter criteria in the figure. 
A)  Descending 
B)  Group By 
C)  5 
D)  There is no parameter criteria in the figure.

Question 5

Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?

Accepted Answer

A)  Delete 
B)  Update 
C)  Append 
D)  Make-Table 
A)  Delete 
B)  Update 
C)  Append 
D)  Make-Table

Question 6

Refer to the figure above. Describe what you would do to show all of the records in the Courses table even if there were no related Enrollments records.

Accepted Answer

Click opti

Question 7

A table has a(n) _________________________ record when information in the foreign key field of the "many" table doesn't have a matching entry in the primary key field.

Accepted Answer

The answer of A table has a(n) _________________________ record when...

Question 8

Match between columns
                        Premises: Adds a group of records from one or more tables to another table
Changes all selected records
Removes a group of records from one or more tables
Creates a new table from all or part of the data in one or more tables
Makes global changes to the values in a field

Accepted Answer

The Answer of Action query and Append query and Update is...

Question 9

Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?

Accepted Answer

A)  [Enter the first character of the company name:] is the parameter prompt. 
B)  & is the wildcard. 
C)  "*" is the second parameter prompt. 
D)  All of the above. 
A)  [Enter the first character of the company name:] is the parameter prompt. 
B)  & is the wildcard. 
C)  "*" is the second parameter prompt. 
D)  All of the above.

Question 10

Which action query would you use if you wanted to export records to another Access database?

Accepted Answer

A)  Make-Table 
B)  Top Values 
C)  Update 
D)  Delete 
A)  Make-Table 
B)  Top Values 
C)  Update 
D)  Delete

Question 11

Which of the following is NOT a type of action query?

Accepted Answer

A)  Select 
B)  Delete 
C)  Update 
D)  Make-table 
A)  Select 
B)  Delete 
C)  Update 
D)  Make-table

Question 12

When you click the Append button from the Query Type list, the _________________________ To row is added to the query design grid.

Accepted Answer

The answer of When you click the Append button from...

Question 13

When you click the Update button from the Query Type list, the _________________________ To row is added to the query design grid.

Accepted Answer

The answer of When you click the Update button from...

Question 14

When you run an action query Access prompts you with an "Are you sure?" message before actually changing the data.

Accepted Answer

A) True 
 B)False

Question 15

List the four types of action queries and give an example of what each would do.

Accepted Answer

1.  A Delete query would be created to r

Question 16

It is wise to make a current backup of the database before running any action query.

Accepted Answer

A) True 
 B)False

Question 17

In the figure above, what does item 2 toggle on and off?

Accepted Answer

A)  Criteria row 
B)  Totals row 
C)  Show row 
D)  Sort row 
A)  Criteria row 
B)  Totals row 
C)  Show row 
D)  Sort row

Question 18

Which button do you use to complete an action query?

Accepted Answer

A)  View 
B)  Select 
C)  Show 
D)  Run 
A)  View 
B)  Select 
C)  Show 
D)  Run

Question 19

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?

Accepted Answer

A)  >=[Enter start date:] and 
B)  LIKE [Enter the first character of the last name:] & "*" 
C)  >=[Enter start date:] 
D)  None of the above 
A)  >=[Enter start date:] and 
B)  LIKE [Enter the first character of the last name:] & "*" 
C)  >=[Enter start date:] 
D)  None of the above

Question 20

A(n) _________________________ query is one that makes changes to the data. There are several types of these queries.

Accepted Answer

The answer of A(n) _________________________ query is one that makes...

If you type the last 2 digits of a year as 13, such as 1/1/13, Access assumes that they signify:

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Which query criteria are equivalent to "Marketing" ?

In the figure above, the parameter criteria is ____.

Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?

Refer to the figure above. Describe what you would do to show all of the records in the Courses table even if there were no related Enrollments records.

A table has a(n) _________________________ record when information in the foreign key field of the "many" table doesn't have a matching entry in the primary key field.

Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?

Which action query would you use if you wanted to export records to another Access database?

Which of the following is NOT a type of action query?

When you click the Append button from the Query Type list, the _________________________ To row is added to the query design grid.

When you click the Update button from the Query Type list, the _________________________ To row is added to the query design grid.

When you run an action query Access prompts you with an "Are you sure?" message before actually changing the data.

List the four types of action queries and give an example of what each would do.

It is wise to make a current backup of the database before running any action query.

In the figure above, what does item 2 toggle on and off?

Which button do you use to complete an action query?

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?

A(n) _________________________ query is one that makes changes to the data. There are several types of these queries.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 11: Creating Advanced Queries

If you type the last 2 digits of a year as 13, such as 1/1/13, Access assumes that they signify:

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Which query criteria are equivalent to "Marketing" ?

In the figure above, the parameter criteria is ____.

Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?

Refer to the figure above. Describe what you would do to show all of the records in the Courses table even if there were no related Enrollments records.

A table has a(n) _________________________ record when information in the foreign key field of the "many" table doesn't have a matching entry in the primary key field.

Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?

Which action query would you use if you wanted to export records to another Access database?

Which of the following is NOT a type of action query?

When you click the Append button from the Query Type list, the _________________________ To row is added to the query design grid.

When you click the Update button from the Query Type list, the _________________________ To row is added to the query design grid.

When you run an action query Access prompts you with an "Are you sure?" message before actually changing the data.

List the four types of action queries and give an example of what each would do.

It is wise to make a current backup of the database before running any action query.

In the figure above, what does item 2 toggle on and off?

Which button do you use to complete an action query?

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?

A(n) _________________________ query is one that makes changes to the data. There are several types of these queries.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters