Question 1

Match between columns
                        Premises: Center
Shape Outline
Align Right
Background Color or Shape Fill
Align Left
Underline
Font Color
Alternate Row Color

Accepted Answer

The Answer of Item 1 and Item 3 and Item is...

Question 2

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 3

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Accepted Answer

The answer of The ____________________ source is the table or...

Question 4

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 one of the sizing handles (except the large one in the upper-left corner in Form Design View)?

Accepted Answer

A)    
B)    
C)    
D)  None of the above. 
A)    
B)    
C)    
D)  None of the above.

Question 5

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

Accepted Answer

A) True 
 B)False

Question 6

A(n) ____________________ key field contains unique data for each record.

Accepted Answer

The answer of A(n) ____________________ key field contains unique data...

Question 7

In Access, data entry screens are called forms . _________________________

Accepted Answer

A) True 
 B)False

Question 8

Which Access object contains all of the raw data within the database?

Accepted Answer

A)  query 
B)  form 
C)  table 
D)  module 
A)  query 
B)  form 
C)  table 
D)  module

Question 9

Which of the following is NOT a common report embellishment?

Accepted Answer

A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons 
A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons

Question 10

Critical Thinking Questions Case 1-2
Lauren wants to create an Access database of the musical instruments she owns.
Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

Accepted Answer

A)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System 
A)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System

Question 11

____ View lets you make some design changes to a form while you are browsing the data.

Accepted Answer

A)  Layout 
B)  Design 
C)  Browse 
D)  Data 
A)  Layout 
B)  Design 
C)  Browse 
D)  Data

Question 12

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

A) True 
 B)False

Question 13

The Page Footer section prints ____.

Accepted Answer

A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records 
A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records

Question 14

Which form creation tool can you use to create a form from scratch in Form Design View?

Accepted Answer

A)  Form 
B)  Blank Form 
C)  Form Design 
D)  Form Wizard 
A)  Form 
B)  Blank Form 
C)  Form Design 
D)  Form Wizard

Question 15

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

Accepted Answer

A) True 
 B)False

Question 16

Press [Esc] once to undo a change to the current field.

Accepted Answer

A) True 
 B)False

Question 17

In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes.

Accepted Answer

A)  second 
B)  third 
C)  fourth 
D)  fifth 
A)  second 
B)  third 
C)  fourth 
D)  fifth

Question 18

A join line is also called a(n) ____ line.

Accepted Answer

A)  query 
B)  link 
C)  connection 
D)  objectivity 
A)  query 
B)  link 
C)  connection 
D)  objectivity

Question 19

Which is NOT true about Access?

Accepted Answer

A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access. 
A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access.

Question 20

Enter OR criteria on different Criteria rows in the query design grid.

Accepted Answer

A) True 
 B)False

A query can be used to create calculated fields.

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

A(n) ____________________ key field contains unique data for each record.

In Access, data entry screens are called forms . _________________________

Which Access object contains all of the raw data within the database?

Which of the following is NOT a common report embellishment?

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

____ View lets you make some design changes to a form while you are browsing the data.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

The Page Footer section prints ____.

Which form creation tool can you use to create a form from scratch in Form Design View?

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

Press [Esc] once to undo a change to the current field.

In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes.

A join line is also called a(n) ____ line.

Which is NOT true about Access?

Enter OR criteria on different Criteria rows in the query design grid.

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

A query can be used to create calculated fields.

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

A(n) ____________________ key field contains unique data for each record.

In Access, data entry screens are called forms . _________________________

Which Access object contains all of the raw data within the database?

Which of the following is NOT a common report embellishment?

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

____ View lets you make some design changes to a form while you are browsing the data.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

The Page Footer section prints ____.

Which form creation tool can you use to create a form from scratch in Form Design View?

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

Press [Esc] once to undo a change to the current field.

In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes.

A join line is also called a(n) ____ line.

Which is NOT true about Access?

Enter OR criteria on different Criteria rows in the query design grid.

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