Question 1

Which of the following is the most common type of bound control you can add to a form?

Accepted Answer

A)  label 
B)  command button 
C)  text box 
D)  combo box 
A)  label 
B)  command button 
C)  text box 
D)  combo box

Question 2

_____ view is a spreadsheet-like view of the data in a table.

Accepted Answer

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

Question 3

An XML file is a text file containing Extensible Markup Language tags that identify field names and data.

Accepted Answer

A) True 
 B)False

Question 4

Which process is most like copying and pasting?

Accepted Answer

A)  importing 
B)  relating 
C)  querying 
D)  linking 
A)  importing 
B)  relating 
C)  querying 
D)  linking

Question 5

When you select a control in Form Design view, you can use _____ to resize the control.

Accepted Answer

A)  arrow keys 
B)  conditional sizing 
C)  resizing handles 
D)  smart guides 
A)  arrow keys 
B)  conditional sizing 
C)  resizing handles 
D)  smart guides

Question 6

Which of the following form controls can you format by applying a style to it?

Accepted Answer

A)  label 
B)  image 
C)  button 
D)  text box 
A)  label 
B)  image 
C)  button 
D)  text box

Question 7

The programming language used in Access modules is called Visual Basic for _____.

Accepted Answer

A)  Access 
B)  Modules 
C)  Applications 
D)  Macros 
A)  Access 
B)  Modules 
C)  Applications 
D)  Macros

Question 8

In Form Layout view, you can edit the text in a _____ without changing any data.

Accepted Answer

A)  label 
B)  text box 
C)  field 
D)  record 
A)  label 
B)  text box 
C)  field 
D)  record

Question 9

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

Accepted Answer

A)  As the first action in the macro 
B)  After the OpenForm action 
C)  As the last action in the macro 
D)  Before the OpenForm action 
A)  As the first action in the macro 
B)  After the OpenForm action 
C)  As the last action in the macro 
D)  Before the OpenForm action

Question 10

A(n) data macro is a collection of actions within a single macro object.

Accepted Answer

A) True 
 B)False

Question 11

Why is it easy to import XML data into an Access table?

Accepted Answer

A)  All XML files use XML tags to structure data into fields and records. 
B)  Previous versions of Access created databases in the XML format. 
C)  XML files contain unstructured data. 
D)  XML files typically contain numeric data. 
A)  All XML files use XML tags to structure data into fields and records. 
B)  Previous versions of Access created databases in the XML format. 
C)  XML files contain unstructured data. 
D)  XML files typically contain numeric data.

Question 12

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

Accepted Answer

A) True 
 B)False

Question 13

What happens if you write VBA code in all lowercase letters?

Accepted Answer

A)  The Visual Basic Editor converts the code to the correct case. 
B)  The Visual Basic Editor displays a syntax error. 
C)  The Visual Basic Editor will not run the code when you click the Run button. 
D)  The Visual Basic Editor will treat the code as a comment. 
A)  The Visual Basic Editor converts the code to the correct case. 
B)  The Visual Basic Editor displays a syntax error. 
C)  The Visual Basic Editor will not run the code when you click the Run button. 
D)  The Visual Basic Editor will treat the code as a comment.

Question 14

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

Accepted Answer

A)  Access restores the changes to the field. 
B)  Access deletes the record. 
C)  Access deletes the field. 
D)  Access removes all changes to the record. 
A)  Access restores the changes to the field. 
B)  Access deletes the record. 
C)  Access deletes the field. 
D)  Access removes all changes to the record.

Question 15

Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?

Accepted Answer

A)  Click the Page Header section bar, and then press DELETE. 
B)  Drag the Page Header or Page Footer section bar to the Navigation Pane. 
C)  Click the Page Header or Page Footer section bar, and then click Remove on the Design tab. 
D)  Right-click the Page Footer section, and then click Page Header/Footer on the shortcut menu. 
A)  Click the Page Header section bar, and then press DELETE. 
B)  Drag the Page Header or Page Footer section bar to the Navigation Pane. 
C)  Click the Page Header or Page Footer section bar, and then click Remove on the Design tab. 
D)  Right-click the Page Footer section, and then click Page Header/Footer on the shortcut menu.

Question 16

Which of the following file formats can you import into Access?

Accepted Answer

A)  Word document 
B)  Email file attachments 
C)  PDF file 
D)  HTML document 
A)  Word document 
B)  Email file attachments 
C)  PDF file 
D)  HTML document

Question 17

Set the Locked property of a form control to Yes if you want to prevent users from entering data in the control.

Accepted Answer

A) True 
 B)False

Question 18

In a macro, a(n) _____ results in a true or false value.

Accepted Answer

A)  conditional expression 
B)  bang notation 
C)  Value argument 
D)  event 
A)  conditional expression 
B)  bang notation 
C)  Value argument 
D)  event

Question 19

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Accepted Answer

A) True 
 B)False

Question 20

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

Accepted Answer

A)  Start Function 
B)  Function 
C)  Option Function 
D)  Declare Function 
A)  Start Function 
B)  Function 
C)  Option Function 
D)  Declare Function

Which of the following is the most common type of bound control you can add to a form?

_____ view is a spreadsheet-like view of the data in a table.

An XML file is a text file containing Extensible Markup Language tags that identify field names and data.

Which process is most like copying and pasting?

When you select a control in Form Design view, you can use _____ to resize the control.

Which of the following form controls can you format by applying a style to it?

The programming language used in Access modules is called Visual Basic for _____.

In Form Layout view, you can edit the text in a _____ without changing any data.

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

A(n) data macro is a collection of actions within a single macro object.

Why is it easy to import XML data into an Access table?

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

What happens if you write VBA code in all lowercase letters?

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?

Which of the following file formats can you import into Access?

Set the Locked property of a form control to Yes if you want to prevent users from entering data in the control.

In a macro, a(n) _____ results in a true or false value.

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

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

Which of the following is the most common type of bound control you can add to a form?

_____ view is a spreadsheet-like view of the data in a table.

An XML file is a text file containing Extensible Markup Language tags that identify field names and data.

Which process is most like copying and pasting?

When you select a control in Form Design view, you can use _____ to resize the control.

Which of the following form controls can you format by applying a style to it?

The programming language used in Access modules is called Visual Basic for _____.

In Form Layout view, you can edit the text in a _____ without changing any data.

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

A(n) data macro is a collection of actions within a single macro object.

Why is it easy to import XML data into an Access table?

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

What happens if you write VBA code in all lowercase letters?

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?

Which of the following file formats can you import into Access?

Set the Locked property of a form control to Yes if you want to prevent users from entering data in the control.

In a macro, a(n) _____ results in a true or false value.

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

Excel 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters