Question 1

________ functions perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

Accepted Answer

The answer of ________ functions perform arithmetic operations,such as calculating...

Question 2

A filter is a condition you apply temporarily to a table or query.

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Aggregate function
Expression Builder
Total row
Property sheet
Special operator

Accepted Answer

The Answer of Where precise changes for each field can is...

Question 4

To manage larger tables,Access provides ways for you to quickly locate information within the datasheet.Once that information is found,it can then be easily replaced with another value using the ________.

Accepted Answer

The answer of To manage larger tables,Access provides ways for...

Question 5

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

Accepted Answer

A) True 
 B)False

Question 6

When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.

Accepted Answer

A)  AND 
B)  OR 
C)  NOT 
D)  BETWEEN 
A)  AND 
B)  OR 
C)  NOT 
D)  BETWEEN

Question 7

When you filter by selection,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

Accepted Answer

A) True 
 B)False

Question 8

________ are the lines connecting the tables that represent relationships.

Accepted Answer

The answer of ________ are the lines connecting the tables...

Question 9

In a query,if you wanted to display the largest value from the selected records,you would use the ________ aggregate function.

Accepted Answer

A)  Count 
B)  Sum 
C)  Minimum 
D)  Maximum 
A)  Count 
B)  Sum 
C)  Minimum 
D)  Maximum

Question 10

Which of the following is NOT used as a comparison operator?

Accepted Answer

A)  = 
B)   
C)   
A)  = 
B)   
C)

Question 11

A ________ query is used when you want to find the rows in one table that do not have a match in the other table.

Accepted Answer

A)  Find Duplicates 
B)  Crosstab 
C)  Find Unmatched 
D)  Simple 
A)  Find Duplicates 
B)  Crosstab 
C)  Find Unmatched 
D)  Simple

Question 12

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

Accepted Answer

The answer of A(n)________ is a foreign key in one...

Question 13

A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Accepted Answer

A)  wildcard character 
B)  Replace command 
C)  Find command 
D)  Find & Replace command 
A)  wildcard character 
B)  Replace command 
C)  Find command 
D)  Find & Replace command

Question 14

Which of the following is NOT a method used to open or switch views?

Accepted Answer

A)  To open an object in design view, right-click it in the Navigation Pane, and select Design View. 
B)  To open an object in default view, right-click it and select Edit. 
C)  To switch views for an already open object, on the Home tab, in the Views group, click the View arrow, and then select your preferred view. 
D)  To switch views for an already open object, right-click the object tab, and then select the preferred view. 
A)  To open an object in design view, right-click it in the Navigation Pane, and select Design View. 
B)  To open an object in default view, right-click it and select Edit. 
C)  To switch views for an already open object, on the Home tab, in the Views group, click the View arrow, and then select your preferred view. 
D)  To switch views for an already open object, right-click the object tab, and then select the preferred view.

Question 15

Null is the absence of any value and is different from blank or zero.

Accepted Answer

A) True 
 B)False

Question 16

To match any number of characters,you would use the ________ wildcard character.

Accepted Answer

To match any number

Question 17

A wildcard character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Accepted Answer

A) True 
 B)False

Question 18

________ operators are generally used with numbers and dates to find a range or a specific value.

Accepted Answer

The answer of ________ operators are generally used with numbers...

Question 19

The ________ allows you to move to the top and bottom of a table or scroll to a specific record.

Accepted Answer

A)  Forward and Backward arrows 
B)  Navigation bar 
C)  Arrows bar 
D)  Navigation Pane 
A)  Forward and Backward arrows 
B)  Navigation bar 
C)  Arrows bar 
D)  Navigation Pane

Question 20

A sort field can be a Short Text,Long Text,Number,Date/Time,Currency,AutoNumber,Yes/No,or Lookup Wizard field.

Accepted Answer

A) True 
 B)False

________ functions perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

A filter is a condition you apply temporarily to a table or query.

To manage larger tables,Access provides ways for you to quickly locate information within the datasheet.Once that information is found,it can then be easily replaced with another value using the ________.

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.

When you filter by selection,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

________ are the lines connecting the tables that represent relationships.

In a query,if you wanted to display the largest value from the selected records,you would use the ________ aggregate function.

Which of the following is NOT used as a comparison operator?

A ________ query is used when you want to find the rows in one table that do not have a match in the other table.

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Which of the following is NOT a method used to open or switch views?

Null is the absence of any value and is different from blank or zero.

To match any number of characters,you would use the ________ wildcard character.

A wildcard character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

________ operators are generally used with numbers and dates to find a range or a specific value.

The ________ allows you to move to the top and bottom of a table or scroll to a specific record.

A sort field can be a Short Text,Long Text,Number,Date/Time,Currency,AutoNumber,Yes/No,or Lookup Wizard field.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 13: Queries and Data Access

________ functions perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

A filter is a condition you apply temporarily to a table or query.

To manage larger tables,Access provides ways for you to quickly locate information within the datasheet.Once that information is found,it can then be easily replaced with another value using the ________.

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.

When you filter by selection,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

________ are the lines connecting the tables that represent relationships.

In a query,if you wanted to display the largest value from the selected records,you would use the ________ aggregate function.

Which of the following is NOT used as a comparison operator?

A ________ query is used when you want to find the rows in one table that do not have a match in the other table.

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Which of the following is NOT a method used to open or switch views?

Null is the absence of any value and is different from blank or zero.

To match any number of characters,you would use the ________ wildcard character.

A wildcard character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

________ operators are generally used with numbers and dates to find a range or a specific value.

The ________ allows you to move to the top and bottom of a table or scroll to a specific record.

A sort field can be a Short Text,Long Text,Number,Date/Time,Currency,AutoNumber,Yes/No,or Lookup Wizard field.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters