Question 1

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 2

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

Question 3

The AutoFilter sort method works on a(n)____ field(s).

Accepted Answer

A)  multiple 
B)  10 fields 
C)  adjacent 
D)  single 
A)  multiple 
B)  10 fields 
C)  adjacent 
D)  single

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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.
A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.
Operators that allow two or more conditions to be combined such as And.
Functions that perform arithmetic operations on selected records in a database.
A type of query in which you specify the fields and records you want Access to select.
The field used to determine the order of records in a datasheet.
The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.
A dialog box used to enter text, expressions, or other values.
The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.
A criterion or rule that determines which records are selected when a query is run.

Accepted Answer

The Answer of Ctrl + End and select query and is...

Question 7

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

Hiding a field in Datasheet view removes the field from the current table.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

Accepted Answer

A)  SUM 
B)  New Row 
C)  Totals 
D)  Add All 
A)  SUM 
B)  New Row 
C)  Totals 
D)  Add All

Question 13

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 14

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 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

The process of rearranging records in a specified order or sequence is referred to as sorting .

Accepted Answer

A) True 
 B)False

Question 20

The contents of query datasheet are permanent .

Accepted Answer

A) True 
 B)False

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

A ____________________ is a set of records that answers the question resulting from a query.

The AutoFilter sort method works on a(n)____ field(s).

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

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

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

Hiding a field in Datasheet view removes the field from the current table.

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

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?

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

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

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

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.

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

Which comparison operator matches a pattern that includes wildcards?

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

The process of rearranging records in a specified order or sequence is referred to as sorting .

The contents of query datasheet are permanent .

Word Module Access Module Creating a Database

Access Module : Building a Database and Defining Table Relationships

Word Module Creating and Editing a Document

Word Module 2: Navigating and Formatting a Document

Excel Module Getting Started With Excel

Excel Module Formatting Workbook Text and Data

Excel Module Performing Calculations With Formulas and Functions

Powerpoint Module Creating a Presentation

Managing Your Files

Communicating With Microsoft Outlook Angel

Productivity Apps for School and Work

Filters

Exam 3: Access Module Maintaining and Querying a Database

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

A ____________________ is a set of records that answers the question resulting from a query.

The AutoFilter sort method works on a(n)____ field(s).

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

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

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

Hiding a field in Datasheet view removes the field from the current table.

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

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?

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

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

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

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.

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

Which comparison operator matches a pattern that includes wildcards?

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

The process of rearranging records in a specified order or sequence is referred to as sorting .

The contents of query datasheet are permanent .

Word Module Access Module Creating a Database

Access Module : Building a Database and Defining Table Relationships

Word Module Creating and Editing a Document

Word Module 2: Navigating and Formatting a Document

Excel Module Getting Started With Excel

Excel Module Formatting Workbook Text and Data

Excel Module Performing Calculations With Formulas and Functions

Powerpoint Module Creating a Presentation

Managing Your Files

Communicating With Microsoft Outlook Angel

Productivity Apps for School and Work

Filters