Question 1

____ is the default entry for each field in the Total row of the query design grid.

Accepted Answer

A) Group By 
B) SUM 
C) Totals 
D) Maximum 
A) Group By 
B) SUM 
C) Totals 
D) Maximum

Question 2

Which comparison operator matches a pattern that includes wildcards?

Accepted Answer

A) Between...And... 
B) Or 
C) Not 
D) Like 
A) Between...And... 
B) Or 
C) Not 
D) Like

Question 3

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

Question 4

A sort field is unique if more than one record can have the same value for the sort field. __________________

Accepted Answer

A) True 
 B)False

Question 5

Which aggregate function would be used to calculate the lowest field value for the selected records?

Accepted Answer

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

Question 6

Which aggregate function supports the Yes/No field data type?

Accepted Answer

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

Question 7

The default name for a new Access query is ____________________.

Accepted Answer

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

Question 8

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 9

Match between columns
                        Premises: The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Accepted Answer

The Answer of Ctrl + End and Zoom box and is...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Case-Based Critical Thinking Questions Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
-When creating a query to determine which plants need full sun, which fields must be included in the query?

Accepted Answer

A) Plant Name and When to Plant 
B) Amount of Sun and Annual 
C) Plant Name and Amount of Sun 
D) Amount of Sun and When to Plant 
A) Plant Name and When to Plant 
B) Amount of Sun and Annual 
C) Plant Name and Amount of Sun 
D) Amount of Sun and When to Plant

Question 12

Fields included in a query may be modified after the query is saved.  ____________________

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

Accepted Answer

The Answer of theme and comparison operator and select query is...

Question 14

The + symbol is an example of a(n)____ operator.

Accepted Answer

A) arithmetic 
B) logical 
C) comparison 
D) calculation 
A) arithmetic 
B) logical 
C) comparison 
D) calculation

Question 15

The ___________________ command allows hidden fields to be redisplayed.

Accepted Answer

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

Question 16

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 17

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

Accepted Answer

The answer of The _________________ prompts for information by asking...

Question 18

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 19

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 20

Statistical information such as totals and averages is calculated using ____.

Accepted Answer

A) comparison operators 
B) mathematical operators 
C) aggregate functions 
D) logical functions 
A) comparison operators 
B) mathematical operators 
C) aggregate functions 
D) logical functions

____ is the default entry for each field in the Total row of the query design grid.

Which comparison operator matches a pattern that includes wildcards?

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

A sort field is unique if more than one record can have the same value for the sort field. __________________

Which aggregate function would be used to calculate the lowest field value for the selected records?

Which aggregate function supports the Yes/No field data type?

The default name for a new Access query is ____________________.

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

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

Fields included in a query may be modified after the query is saved. ____________________

The + symbol is an example of a(n)____ operator.

The ___________________ command allows hidden fields to be redisplayed.

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

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

The default group in the Navigation Pane is ____.

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

Statistical information such as totals and averages is calculated using ____.

Access-Module 1: 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 Forms

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

____ is the default entry for each field in the Total row of the query design grid.

Which comparison operator matches a pattern that includes wildcards?

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

A sort field is unique if more than one record can have the same value for the sort field. __________________

Which aggregate function would be used to calculate the lowest field value for the selected records?

Which aggregate function supports the Yes/No field data type?

The default name for a new Access query is ____________________.

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

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

Fields included in a query may be modified after the query is saved. ____________________

The + symbol is an example of a(n)____ operator.

The ___________________ command allows hidden fields to be redisplayed.

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

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

The default group in the Navigation Pane is ____.

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

Statistical information such as totals and averages is calculated using ____.

Access-Module 1: 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 Forms

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