Question 1

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Accepted Answer

A) Tab 
B) Home + Up Arrow 
C) Up Arrow 
D) Ctrl+Home 
A) Tab 
B) Home + Up Arrow 
C) Up Arrow 
D) Ctrl+Home

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

Match between columns
                        Premises: The field used to determine the order of records in a datasheet.

Accepted Answer

The Answer of logical operators and Zoom box and condition is...

Question 6

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 7

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

Question 8

A query based on more than one table is a(n)____query.

Accepted Answer

A) multiple 
B) advanced 
C) relationship 
D) multitable 
A) multiple 
B) advanced 
C) relationship 
D) multitable

Question 9

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 10

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Accepted Answer

A) crosstab 
B) append 
C) query by example (QB
E)  
D) update 
A) crosstab 
B) append 
C) query by example (QB
E)  
D) update

Question 11

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n)____.

Accepted Answer

A) builder 
B) expression 
C) operator 
D) query 
A) builder 
B) expression 
C) operator 
D) query

Question 12

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 13

Match between columns
                        Premises: A type of query in which you specify the fields and records you want Access to select.

Accepted Answer

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

Question 14

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

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

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

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

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

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

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

A query based on more than one table is a(n)____query.

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

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n)____.

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 ____________________ is a set of records that answers the question resulting from a query.

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

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

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

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

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

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

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

A query based on more than one table is a(n)____query.

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

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n)____.

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 ____________________ is a set of records that answers the question resulting from a query.

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