Question 1

The process of rearranging records in a specified order or sequence is referred to as sorting.____________________

Accepted Answer

A) True 
 B)False  True

Question 2

It is not possible to create a query from more than one table.____________________

Accepted Answer

A) True 
 B)False  False

Question 3

The default query type for Access is the Crosstab query.____________________

Accepted Answer

A) True 
 B)False  False

Question 4

The condition "Seattle" for the field City in a student database is an example of what type of value?

Accepted Answer

A) text value 
B) field value 
C) comparison value 
D) criteria value 
A) text value 
B) field value 
C) comparison value 
D) criteria value

Question 5

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

Accepted Answer

A) modify 
B) rename 
C) delete the existing query 
D) include comparison operators 
A) modify 
B) rename 
C) delete the existing query 
D) include comparison operators

Question 6

The most simple technique to use for filtering records is Filter By Form.____________________

Accepted Answer

A) True 
 B)False

Question 7

It is more efficient to use the Query Wizard for common,informational queries than to design your own query.____________________

Accepted Answer

A) True 
 B)False

Question 8

A ____________________ is a set of records that answers the question resulting from a query.

Accepted Answer

The answer of A ____________________ is a set of records...

Question 9

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.____________________

Accepted Answer

A) True 
 B)False

Question 10

Identify the letter of the choice that best matches the phrase or definition.
-Operators that allow two or more conditions to be combined such as And.

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 11

The primary key of a table must be unique for each record;however,the ____ sort field does not have to be unique.

Accepted Answer

A) table 
B) chronological 
C) primary 
D) adjacent 
A) table 
B) chronological 
C) primary 
D) adjacent

Question 12

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

Accepted Answer

A) reconstructing 
B) maintaining 
C) developing 
D) editing 
A) reconstructing 
B) maintaining 
C) developing 
D) editing

Question 13

A calculated field created in a query generates results when ____.

Accepted Answer

A) the database is opened 
B) the query's underlying table is opened 
C) when a report is created 
D) when the query is run 
A) the database is opened 
B) the query's underlying table is opened 
C) when a report is created 
D) when the query is run

Question 14

The default group in the Navigation Pane is ____.

Accepted Answer

A) Object Type 
B) All Access Objects 
C) Table 
D) Design Grids 
A) Object Type 
B) All Access Objects 
C) Table 
D) Design Grids

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

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 16

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Accepted Answer

The answer of Typing a value in a highlighted field...

Question 17

Hiding a field in Datasheet view removes the field from the current table.____________________

Accepted Answer

A) True 
 B)False

Question 18

Data may be sorted in a table datasheet,a form,and a ____.

Accepted Answer

A) report 
B) query datasheet 
C) record 
D) related table 
A) report 
B) query datasheet 
C) record 
D) related table

Question 19

Identify the letter of the choice that best matches the phrase or definition.
-The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

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 20

When the sort field data for each record in a database is different,the sort field is ____.

Accepted Answer

A) ascending 
B) unique 
C) nonunique 
D) descending 
A) ascending 
B) unique 
C) nonunique 
D) descending

The process of rearranging records in a specified order or sequence is referred to as sorting.____________________

It is not possible to create a query from more than one table.____________________

The default query type for Access is the Crosstab query.____________________

The condition "Seattle" for the field City in a student database is an example of what type of value?

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

The most simple technique to use for filtering records is Filter By Form.____________________

It is more efficient to use the Query Wizard for common,informational queries than to design your own query.____________________

A ____________________ is a set of records that answers the question resulting from a query.

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.____________________

Identify the letter of the choice that best matches the phrase or definition. -Operators that allow two or more conditions to be combined such as And.

The primary key of a table must be unique for each record;however,the ____ sort field does not have to be unique.

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

A calculated field created in a query generates results when ____.

The default group in the Navigation Pane is ____.

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Hiding a field in Datasheet view removes the field from the current table.____________________

Data may be sorted in a table datasheet,a form,and a ____.

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

When the sort field data for each record in a database is different,the sort field is ____.

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

The process of rearranging records in a specified order or sequence is referred to as sorting.____________________

It is not possible to create a query from more than one table.____________________

The default query type for Access is the Crosstab query.____________________

The condition "Seattle" for the field City in a student database is an example of what type of value?

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

The most simple technique to use for filtering records is Filter By Form.____________________

It is more efficient to use the Query Wizard for common,informational queries than to design your own query.____________________

A ____________________ is a set of records that answers the question resulting from a query.

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.____________________

Identify the letter of the choice that best matches the phrase or definition. -Operators that allow two or more conditions to be combined such as And.

The primary key of a table must be unique for each record;however,the ____ sort field does not have to be unique.

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

A calculated field created in a query generates results when ____.

The default group in the Navigation Pane is ____.

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Hiding a field in Datasheet view removes the field from the current table.____________________

Data may be sorted in a table datasheet,a form,and a ____.

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

When the sort field data for each record in a database is different,the sort field is ____.

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