Question 1

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Accepted Answer

A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode 
A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode

Question 2

You can add fields to a form in either Layout View or Design View.

Accepted Answer

A) True 
 B)False

Question 3

The lower pane of a split form displays a(n) datasheet view. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

Accepted Answer

A)  Form Wizard 
B)  More Forms 
C)  Split Form 
D)  Navigation 
A)  Form Wizard 
B)  More Forms 
C)  Split Form 
D)  Navigation

Question 5

You can press an arrow key to move a selected control.

Accepted Answer

A) True 
 B)False

Question 6

Critical Thinking Questions Case 4-1
Bradley plans to generate reports from an Access database that a colleague of his built. As he works with the reports, he decides to familiarize himself with each of the views that is available to him.
Bradley wants to focus on just the details of one of the reports, without seeing the data. Which of the following should he use?

Accepted Answer

A)  Report View 
B)  Layout View 
C)  Print Preview 
D)  Design View 
A)  Report View 
B)  Layout View 
C)  Print Preview 
D)  Design View

Question 7

On a form, ____________________ View is used to enter, edit, and delete data.

Accepted Answer

The answer of On a form, ____________________ View is used...

Question 8

Critical Thinking Questions Case 4-1
Bradley plans to generate reports from an Access database that a colleague of his built. As he works with the reports, he decides to familiarize himself with each of the views that is available to him.
Which of the following will Bradley use if he is looking for the optimal view for changing the positioning of some of his report controls while also reviewing the live data?

Accepted Answer

A)  Report View 
B)  Layout View 
C)  Print Preview 
D)  Design View 
A)  Report View 
B)  Layout View 
C)  Print Preview 
D)  Design View

Question 9

To add, delete, or change fields in a query, you use Query Design View.

Accepted Answer

A) True 
 B)False

Question 10

The wildcard character that stands for any single character is the ____.

Accepted Answer

A)  ampersand (&) 
B)  question mark (?) 
C)  exclamation mark (!) 
D)  caret (^) 
A)  ampersand (&) 
B)  question mark (?) 
C)  exclamation mark (!) 
D)  caret (^)

Question 11

Query Design View presents the fields you can use for a query in small windows called field ____.

Accepted Answer

A)  glossaries 
B)  lists 
C)  links 
D)  catalogs 
A)  glossaries 
B)  lists 
C)  links 
D)  catalogs

Question 12

The bottom button in the accompanying figure ____.

Accepted Answer

A)  sorts records in descending order 
B)  sorts records in ascending order 
C)  helps you navigate to the first, previous, next, last, or new record 
D)  removes the current sort order 
A)  sorts records in descending order 
B)  sorts records in ascending order 
C)  helps you navigate to the first, previous, next, last, or new record 
D)  removes the current sort order

Question 13

The navigation buttons on a datasheet display the total number of fields in the datasheet.

Accepted Answer

A) True 
 B)False

Question 14

The top button in the accompanying figure ____.

Accepted Answer

A)  sorts records in descending order 
B)  sorts records in ascending order 
C)  helps you select a single record or all records in a datasheet 
D)  removes the current sort order 
A)  sorts records in descending order 
B)  sorts records in ascending order 
C)  helps you select a single record or all records in a datasheet 
D)  removes the current sort order

Question 15

You can rename labels in Report Layout View.

Accepted Answer

A) True 
 B)False

Question 16

Use the ____________________ Form tool to create a form from scratch in Form Layout View.

Accepted Answer

The answer of Use the ____________________ Form tool to create...

Question 17

Case 3-1 You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them.
Which of the following appears when you point to the upper-left corner or edge of a selected control in Form Design View or the middle of the control in Form Layout View?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 18

Match between columns
                        Premises: Displays choices for a field
Used to run a macro
Used to visually separate information on a form
Used to provide a list of possible data entries
Provides consistent descriptive text as you navigate records
Best choice to display a field such as Veteran that has only two options, Yes or No
Creates a three-dimensional aspect on a form
Used to provide a list of options for a field plus the ability for the user to enter a new value

Accepted Answer

The Answer of Option button and Toggle button and Combo is...

Question 19

On a form, ____________________ View is used to modify controls and does not display data.

Accepted Answer

The answer of On a form, ____________________ View is used...

Question 20

The Group Footer section prints ____.

Accepted Answer

A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page 
A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

You can add fields to a form in either Layout View or Design View.

The lower pane of a split form displays a(n) datasheet view. _________________________

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

You can press an arrow key to move a selected control.

On a form, ____________________ View is used to enter, edit, and delete data.

To add, delete, or change fields in a query, you use Query Design View.

The wildcard character that stands for any single character is the ____.

Query Design View presents the fields you can use for a query in small windows called field ____.

The bottom button in the accompanying figure ____.

The navigation buttons on a datasheet display the total number of fields in the datasheet.

The top button in the accompanying figure ____.

You can rename labels in Report Layout View.

Use the ____________________ Form tool to create a form from scratch in Form Layout View.

On a form, ____________________ View is used to modify controls and does not display data.

The Group Footer section prints ____.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Excel 2013 Getting Started With Excel 2013

Filters

Exam 7: Access 2013 Getting Started With Access 2013

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

You can add fields to a form in either Layout View or Design View.

The lower pane of a split form displays a(n) datasheet view. _________________________

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

You can press an arrow key to move a selected control.

On a form, ____________________ View is used to enter, edit, and delete data.

To add, delete, or change fields in a query, you use Query Design View.

The wildcard character that stands for any single character is the ____.

Query Design View presents the fields you can use for a query in small windows called field ____.

The bottom button in the accompanying figure ____.

The navigation buttons on a datasheet display the total number of fields in the datasheet.

The top button in the accompanying figure ____.

You can rename labels in Report Layout View.

Use the ____________________ Form tool to create a form from scratch in Form Layout View.

On a form, ____________________ View is used to modify controls and does not display data.

The Group Footer section prints ____.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Excel 2013 Getting Started With Excel 2013

Filters