Question 1

When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________

Accepted Answer

A) True 
 B)False

Question 2

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 3

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

Accepted Answer

A) True 
 B)False

Question 4

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?
-To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query.The Perennial field has a data type of Yes/No.Which criterion should Jorge use in the query for the Perennial field?

Accepted Answer

A) Yes 
B) >No 
C) check=yes 
D) 'yes' 
A) Yes 
B) >No 
C) check=yes 
D) 'yes'

Question 5

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 6

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Accepted Answer

The answer of The arrangement of records sorted in a...

Question 7

A calculated field is formatted using the ____ for the field.

Accepted Answer

A) Property Sheet 
B) Criteria 
C) Expression Builder 
D) Operator 
A) Property Sheet 
B) Criteria 
C) Expression Builder 
D) Operator

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

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 9

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

Accepted Answer

A) leftmost 
B) rightmost 
C) adjacent to the leftmost field 
D) adjacent to the rightmost field 
A) leftmost 
B) rightmost 
C) adjacent to the leftmost field 
D) adjacent to the rightmost field

Question 10

In the criterion,<=250,the operator will return values for the specified field that are ____.

Accepted Answer

A) less than 250 
B) equal to 250 
C) less than or equal to 250 
D) greater than or equal to 250 
A) less than 250 
B) equal to 250 
C) less than or equal to 250 
D) greater than or equal to 250

Question 11

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

Accepted Answer

The answer of To locate a specific field value or...

Question 12

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 13

Queries based on more than one table,must have a ____ field.

Accepted Answer

A) common 
B) similar 
C) text 
D) calculated 
A) common 
B) similar 
C) text 
D) calculated

Question 14

____ 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 15

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

Accepted Answer

A) navigation mode 
B) design mode 
C) editing mode 
D) selection mode 
A) navigation mode 
B) design mode 
C) editing mode 
D) selection mode

When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________

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

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

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

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

A calculated field is formatted using the ____ for the field.

Identify the letter of the choice that best matches the phrase or definition. -A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

In the criterion,<=250,the operator will return values for the specified field that are ____.

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

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

Queries based on more than one table,must have a ____ field.

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

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

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

When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________

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

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

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

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

A calculated field is formatted using the ____ for the field.

Identify the letter of the choice that best matches the phrase or definition. -A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

In the criterion,<=250,the operator will return values for the specified field that are ____.

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

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

Queries based on more than one table,must have a ____ field.

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

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

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