Question 1

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

Accepted Answer

A)  4 
B)  >=4 
C)  "Is 4" 
A)  4 
B)  >=4 
C)  "Is 4"

Question 2

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

Accepted Answer

A)  question marks (?) 
B)  quotation marks (") 
C)  dashes (-) 
D)  asterisks (*) 
A)  question marks (?) 
B)  quotation marks (") 
C)  dashes (-) 
D)  asterisks (*)

Question 3

Which argument of the MessageBox macro action determines the text in the message dialog box?

Accepted Answer

A)  Message 
B)  View 
C)  Title 
D)  Type 
A)  Message 
B)  View 
C)  Title 
D)  Type

Question 4

You modify the Set New Page property of a section to force each section to start printing at the top of a new page.

Accepted Answer

A) True 
 B)False

Question 5

You set the opening Display Form for a database using the Access Preferences dialog box.

Accepted Answer

A) True 
 B)False

Question 6

You use the _____ button in the Sort & Filter group to use features such as Save As Query and Clear All Filters.

Accepted Answer

A)  Filter By Selection 
B)  Filter by Form 
C)  Advanced 
D)  Comparison 
A)  Filter By Selection 
B)  Filter by Form 
C)  Advanced 
D)  Comparison

Question 7

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

Accepted Answer

A)  paste 
B)  cut 
C)  copy 
D)  rename 
A)  paste 
B)  cut 
C)  copy 
D)  rename

Question 8

A _____ is a grid that displays fields as columns and records as rows.

Accepted Answer

A)  query 
B)  datasheet 
C)  logical table 
D)  report 
A)  query 
B)  datasheet 
C)  logical table 
D)  report

Question 9

In Form Layout view, what happens when you select a text box and then click the Align Right button on the Home tab?

Accepted Answer

A)  The edge of the text box is right-aligned with other text boxes. 
B)  The contents of the text box are right-aligned. 
C)  The text box moves to the right edge of the form. 
D)  The text box moves to the right of its label. 
A)  The edge of the text box is right-aligned with other text boxes. 
B)  The contents of the text box are right-aligned. 
C)  The text box moves to the right edge of the form. 
D)  The text box moves to the right of its label.

Question 10

To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.

Accepted Answer

A)  Send 
B)  Email 
C)  Share 
D)  Attach 
A)  Send 
B)  Email 
C)  Share 
D)  Attach

Question 11

What can you do when a report has blank pages in Print Preview?

Accepted Answer

A)  Delete the blank page. 
B)  Click the Margins button on the Print Preview tab to change the report margins. 
C)  Insert a page break control. 
D)  Click the Zoom button on the Print Preview tab to hide the blank pages. 
A)  Delete the blank page. 
B)  Click the Margins button on the Print Preview tab to change the report margins. 
C)  Insert a page break control. 
D)  Click the Zoom button on the Print Preview tab to hide the blank pages.

Question 12

Deleting a text box in Form Layout view _____.

Accepted Answer

A)  deletes the data from the field 
B)  does not delete the text box in Form Design view 
C)  deletes the field from the underlying table 
D)  removes the text box from the form 
A)  deletes the data from the field 
B)  does not delete the text box in Form Design view 
C)  deletes the field from the underlying table 
D)  removes the text box from the form

Question 13

What is the main purpose of a form?

Accepted Answer

A)  to provide an easy-to-use format for entering and editing records 
B)  to prevent changes to the data in tables 
C)  to display records without allowing changes to them 
D)  to preview the contents of reports 
A)  to provide an easy-to-use format for entering and editing records 
B)  to prevent changes to the data in tables 
C)  to display records without allowing changes to them 
D)  to preview the contents of reports

Question 14

What do you change when you drag the right border of a form in Form Design view?

Accepted Answer

A)  the width of all the form controls 
B)  the margins of the form 
C)  the layout of the form 
D)  the width of the form 
A)  the width of all the form controls 
B)  the margins of the form 
C)  the layout of the form 
D)  the width of the form

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

A _____ module is stored as a part of the form or report in which it was created.

Accepted Answer

A)  global 
B)  class 
C)  standard 
D)  sub 
A)  global 
B)  class 
C)  standard 
D)  sub

Question 17

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

Accepted Answer

A)  Decrease the number of decimal places. 
B)  Increase the number of decimal places. 
C)  Apply the Percent format to the field. 
D)  Apply the Comma Number format to the field. 
A)  Decrease the number of decimal places. 
B)  Increase the number of decimal places. 
C)  Apply the Percent format to the field. 
D)  Apply the Comma Number format to the field.

Question 18

When you split an Access database, what do you call the database stored on your computer?

Accepted Answer

A)  Client-end database 
B)  Object database 
C)  Front-end database 
D)  Table database 
A)  Client-end database 
B)  Object database 
C)  Front-end database 
D)  Table database

Question 19

If the _____ property for a form control is set to No, you cannot edit data in the control in Form view.

Accepted Answer

A)  Locked 
B)  Edit 
C)  Display Data 
D)  Control Source 
A)  Locked 
B)  Edit 
C)  Display Data 
D)  Control Source

Question 20

To change an inner join relationship between tables for one query only to an outer join, you double-click the join line in Relationship Design view.

Accepted Answer

A) True 
 B)False

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

Which argument of the MessageBox macro action determines the text in the message dialog box?

You modify the Set New Page property of a section to force each section to start printing at the top of a new page.

You set the opening Display Form for a database using the Access Preferences dialog box.

You use the _____ button in the Sort & Filter group to use features such as Save As Query and Clear All Filters.

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

A _____ is a grid that displays fields as columns and records as rows.

In Form Layout view, what happens when you select a text box and then click the Align Right button on the Home tab?

To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.

What can you do when a report has blank pages in Print Preview?

Deleting a text box in Form Layout view _____.

What is the main purpose of a form?

What do you change when you drag the right border of a form in Form Design view?

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

A _____ module is stored as a part of the form or report in which it was created.

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

When you split an Access database, what do you call the database stored on your computer?

If the _____ property for a form control is set to No, you cannot edit data in the control in Form view.

To change an inner join relationship between tables for one query only to an outer join, you double-click the join line in Relationship Design view.

Excel 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 1: Access 2019

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

Which argument of the MessageBox macro action determines the text in the message dialog box?

You modify the Set New Page property of a section to force each section to start printing at the top of a new page.

You set the opening Display Form for a database using the Access Preferences dialog box.

You use the _____ button in the Sort & Filter group to use features such as Save As Query and Clear All Filters.

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

A _____ is a grid that displays fields as columns and records as rows.

In Form Layout view, what happens when you select a text box and then click the Align Right button on the Home tab?

To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.

What can you do when a report has blank pages in Print Preview?

Deleting a text box in Form Layout view _____.

What is the main purpose of a form?

What do you change when you drag the right border of a form in Form Design view?

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

A _____ module is stored as a part of the form or report in which it was created.

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

When you split an Access database, what do you call the database stored on your computer?

If the _____ property for a form control is set to No, you cannot edit data in the control in Form view.

To change an inner join relationship between tables for one query only to an outer join, you double-click the join line in Relationship Design view.

Excel 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters