Question 1

Which data type stores only one of two values?

Accepted Answer

A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null 
A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null

Question 2

The Page Header section prints ____.

Accepted Answer

A)  at the top of the first page 
B)  at the top of every page (but below the Report Header on the first page) 
C)  before every group of records 
D)  after every group of records 
A)  at the top of the first page 
B)  at the top of every page (but below the Report Header on the first page) 
C)  before every group of records 
D)  after every group of records

Question 3

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Accepted Answer

A)  record 
B)  table 
C)  database 
D)  object 
A)  record 
B)  table 
C)  database 
D)  object

Question 4

Which of the following is NOT a form view?

Accepted Answer

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

Question 5

A filter can be used to create calculated fields.

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 is ready to print his report, but he only wants to print specific pages of the report. On what tab can he find the options to accomplish this task?

Accepted Answer

A)  PRINT PREVIEW 
B)  PRINT OPTIONS 
C)  SELECTION 
D)  TOOLS 
A)  PRINT PREVIEW 
B)  PRINT OPTIONS 
C)  SELECTION 
D)  TOOLS

Question 7

Which of the following is the correct expression to count the number of records using a field named City?

Accepted Answer

A)  =Count([City]) 
B)  =Count[City] 
C)  =Count(City) 
D)  =Count{City} 
A)  =Count([City]) 
B)  =Count[City] 
C)  =Count(City) 
D)  =Count{City}

Question 8

The tasks that can be accomplished by each of the various report views are mutually exclusive.

Accepted Answer

A) True 
 B)False

Question 9

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Accepted Answer

The answer of If you use ____________________ View to design...

Question 10

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

Accepted Answer

The answer of In Query Design View, the query design...

Question 11

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Accepted Answer

A) True 
 B)False

Question 12

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet. ____________________

Accepted Answer

A) True 
 B)False

Question 13

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 is just getting started with one of the reports and he needs to quickly review it to see what it contains. He does not want his view to contain any page breaks. Which view 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 14

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

Accepted Answer

A)  Pinned space 
B)  Navigation Pane 
C)  Objects Bar 
D)  Objects Tab 
A)  Pinned space 
B)  Navigation Pane 
C)  Objects Bar 
D)  Objects Tab

Question 15

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

Accepted Answer

A) True 
 B)False

Question 16

You can apply more than one grouping order to a report.

Accepted Answer

A) True 
 B)False

Question 17

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

Accepted Answer

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

Question 18

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Question 19

Use the Align button on the DESIGN tab to align the edges of the controls with respect to one another. _________________________

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

Accepted Answer

The answer of A(n) ____________________ object allows a user to...

Which data type stores only one of two values?

The Page Header section prints ____.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Which of the following is NOT a form view?

A filter can be used to create calculated fields.

Which of the following is the correct expression to count the number of records using a field named City?

The tasks that can be accomplished by each of the various report views are mutually exclusive.

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet. ____________________

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

You can apply more than one grouping order to a report.

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

Tables contain all of the data in the database.

Use the Align button on the DESIGN tab to align the edges of the controls with respect to one another. _________________________

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

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

Which data type stores only one of two values?

The Page Header section prints ____.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Which of the following is NOT a form view?

A filter can be used to create calculated fields.

Which of the following is the correct expression to count the number of records using a field named City?

The tasks that can be accomplished by each of the various report views are mutually exclusive.

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet. ____________________

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

You can apply more than one grouping order to a report.

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

Tables contain all of the data in the database.

Use the Align button on the DESIGN tab to align the edges of the controls with respect to one another. _________________________

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

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