Question 1

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

Question 2

Match between columns
                        Premises: Operators that allow two or more conditions to be combined such as And.

Accepted Answer

The Answer of Home and logical operators and condition and is...

Question 3

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 condition and aggregate functions and logical operators is...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: 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

The Answer of theme and Ctrl + End and condition is...

Question 6

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 7

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 8

In the accompanying figure, the ____________________ of the Query window in Design View is outlined.

Accepted Answer

The answer of   
In the accompanying figure, the...

Question 9

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 10

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 11

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

Accepted Answer

The Answer of query and Home and comparison operator and is...

Question 12

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 13

Match between columns
                        Premises: A criterion or rule that determines which records are selected when a query is run.

Accepted Answer

The Answer of logical operators and sort field and query is...

Question 14

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 15

The default name for a new Access query is ____________________.

Accepted Answer

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

Question 16

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 17

To change the order fields in the query design grid, move a field by selecting it and then  ____________________  it to the new location.

Accepted Answer

The answer of To change the order fields in the...

Question 18

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

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

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

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

In the accompanying figure, the ____________________ of the Query window in Design View is outlined.

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 ____________________.

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

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

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

The default name for a new Access query is ____________________.

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

To change the order fields in the query design grid, move a field by selecting it and then ____________________ it to the new location.

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

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

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

Managing Your Files

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 Sharing a Database

Filters

Exam 4: Maintaining and Querying a Database

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

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

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

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

In the accompanying figure, the ____________________ of the Query window in Design View is outlined.

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 ____________________.

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

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

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

The default name for a new Access query is ____________________.

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

To change the order fields in the query design grid, move a field by selecting it and then ____________________ it to the new location.

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

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

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

Managing Your Files

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 Sharing a Database

Filters