Question 1

Results of a query are narrowed by using the Or logical operator.  ____________________

Accepted Answer

A) True 
 B)False  False

Question 2

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 A

Question 3

In the criterion,

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 C

Question 4

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 5

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 6

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

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 8

Match between columns
                        Premises: Functions that perform arithmetic operations on selected records in a database.

Accepted Answer

The Answer of comparison operator and aggregate functions and Zoom is...

Question 9

Match between columns
                        Premises: A dialog box used to enter text, expressions, or other values.

Accepted Answer

The Answer of logical operators and Ctrl + End and is...

Question 10

The first field specified in the sorting process is called the ____________________ field.

Accepted Answer

The answer of The first field specified in the sorting...

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

The ascending sort order for the Date/Time data type sorts dates from ____________________.

Accepted Answer

oldest to

Question 15

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 16

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 17

The contents of query datasheet are permanent . ____________________

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

Accepted Answer

The Answer of sort field and aggregate functions and theme is...

Question 19

Date criteria are automatically enclosed in ____ when entered in a query design.

Accepted Answer

A) quotes 
B) parenthesis 
C) brackets 
D) number signs 
A) quotes 
B) parenthesis 
C) brackets 
D) number signs

Question 20

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

Accepted Answer

A) True 
 B)False

Results of a query are narrowed by using the Or logical operator. ____________________

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,

Which view must be used to delete an entire record?

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

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

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

The first field specified in the sorting process is called the ____________________ field.

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

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

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

The ascending sort order for the Date/Time data type sorts dates from ____________________.

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

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

The contents of query datasheet are permanent . ____________________

Date criteria are automatically enclosed in ____ when entered in a query design.

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

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

Results of a query are narrowed by using the Or logical operator. ____________________

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,

Which view must be used to delete an entire record?

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

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

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

The first field specified in the sorting process is called the ____________________ field.

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

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

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

The ascending sort order for the Date/Time data type sorts dates from ____________________.

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

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

The contents of query datasheet are permanent . ____________________

Date criteria are automatically enclosed in ____ when entered in a query design.

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

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