Question 1

Access may base queries on one or more tables or queries.____________________

Accepted Answer

A) True 
 B)False

Question 2

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n)____.

Accepted Answer

A) builder 
B) expression 
C) operator 
D) query 
A) builder 
B) expression 
C) operator 
D) query

Question 3

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

Accepted Answer

A) Table Name 
B) Custom 
C) Query Name 
D) Relationship 
A) Table Name 
B) Custom 
C) Query Name 
D) Relationship

Question 4

The ___________________ command allows hidden fields to be redisplayed.

Accepted Answer

The answer of The ___________________ command allows hidden fields to...

Question 5

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

Accepted Answer

A) Run 
B) Append 
C) Show 
D) Design 
A) Run 
B) Append 
C) Show 
D) Design

Question 6

The ____ command removes the display of one or more fields in Datasheet view.

Accepted Answer

A) Hide Fields 
B) Unhide Fields 
C) Remove Fields 
D) Display Fields 
A) Hide Fields 
B) Unhide Fields 
C) Remove Fields 
D) Display Fields

Question 7

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Accepted Answer

A) crosstab 
B) append 
C) query by example (QB
E)  
D) update 
A) crosstab 
B) append 
C) query by example (QB
E)  
D) update

Question 8

Access database objects are divided into categories on the Navigation Pane.____________________

Accepted Answer

A) True 
 B)False

Question 9

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

Accepted Answer

A) Query Type 
B) Show/Hide 
C) Query Setup 
D) Results 
A) Query Type 
B) Show/Hide 
C) Query Setup 
D) Results

Question 10

The AutoFilter sort method works on a(n)____ field(s).

Accepted Answer

A) multiple 
B) 10 fields 
C) adjacent 
D) single 
A) multiple 
B) 10 fields 
C) adjacent 
D) single

Question 11

Identify the letter of the choice that best matches the phrase or definition.
-Functions that perform arithmetic operations on selected records in a database.

Accepted Answer

A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query 
A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Question 12

Logical operators must be used in order to combine two or more conditions in a query.____________________

Accepted Answer

A) True 
 B)False

Question 13

The comparison operator,,is used to insert a condition that means ____.

Accepted Answer

A) greater than 
B) And 
C) less than 
D) not equal to 
A) greater than 
B) And 
C) less than 
D) not equal to

Question 14

Identify the letter of the choice that best matches the phrase or definition.
-A criterion or rule that determines which records are selected when a query is run.

Accepted Answer

A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query 
A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Question 15

A field with the Short Text data type sorted in descending order will display the data in which order?

Accepted Answer

A) A to Z 
B) lowest to highest 
C) Z to A 
D) highest to lowest 
A) A to Z 
B) lowest to highest 
C) Z to A 
D) highest to lowest

Question 16

Which view must be used to delete an entire record?

Accepted Answer

A) Design 
B) Query 
C) Navigation 
D) Datasheet 
A) Design 
B) Query 
C) Navigation 
D) Datasheet

Question 17

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

Accepted Answer

A) SUM 
B) New Row 
C) Totals 
D) Add All 
A) SUM 
B) New Row 
C) Totals 
D) Add All

Question 18

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

Accepted Answer

A) True 
 B)False

Question 19

The default name for a new Access query is ____________________.

Accepted Answer

The answer of The default name for a new Access...

Question 20

The contents of query datasheet are permanent.____________________

Accepted Answer

A) True 
 B)False

Access may base queries on one or more tables or queries.____________________

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n)____.

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

The ___________________ command allows hidden fields to be redisplayed.

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

The ____ command removes the display of one or more fields in Datasheet view.

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Access database objects are divided into categories on the Navigation Pane.____________________

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

The AutoFilter sort method works on a(n)____ field(s).

Identify the letter of the choice that best matches the phrase or definition. -Functions that perform arithmetic operations on selected records in a database.

Logical operators must be used in order to combine two or more conditions in a query.____________________

The comparison operator,< >,is used to insert a condition that means ____.

Identify the letter of the choice that best matches the phrase or definition. -A criterion or rule that determines which records are selected when a query is run.

A field with the Short Text data type sorted in descending order will display the data in which order?

Which view must be used to delete an entire record?

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

The default name for a new Access query is ____________________.

The contents of query datasheet are permanent.____________________

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 3: Maintaining and Querying a Database

Access may base queries on one or more tables or queries.____________________

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n)____.

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

The ___________________ command allows hidden fields to be redisplayed.

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

The ____ command removes the display of one or more fields in Datasheet view.

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Access database objects are divided into categories on the Navigation Pane.____________________

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

The AutoFilter sort method works on a(n)____ field(s).

Identify the letter of the choice that best matches the phrase or definition. -Functions that perform arithmetic operations on selected records in a database.

Logical operators must be used in order to combine two or more conditions in a query.____________________

The comparison operator,< >,is used to insert a condition that means ____.

Identify the letter of the choice that best matches the phrase or definition. -A criterion or rule that determines which records are selected when a query is run.

A field with the Short Text data type sorted in descending order will display the data in which order?

Which view must be used to delete an entire record?

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

The default name for a new Access query is ____________________.

The contents of query datasheet are permanent.____________________

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters