Question 1

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

Accepted Answer

A)  Modify Function 
B)  Modify Expression 
C)  Modify Calculation 
D)  Modify Data Type 
A)  Modify Function 
B)  Modify Expression 
C)  Modify Calculation 
D)  Modify Data Type

Question 2

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

Accepted Answer

A)  750.25 
B)  750.2 
C)  750 
D)  751 
A)  750.25 
B)  750.2 
C)  750 
D)  751

Question 3

Which Access object contains all of the data in the database?

Accepted Answer

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

Question 4

When you create an option group on a form, you enter the Option Value property for each option button.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following could you use to export records to a new table?

Accepted Answer

A)  Parameter query 
B)  Make-Table query 
C)  Update query 
D)  Delete query 
A)  Parameter query 
B)  Make-Table query 
C)  Update query 
D)  Delete query

Question 6

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

Accepted Answer

A)  parameter 
B)  summary 
C)  action 
D)  crosstab 
A)  parameter 
B)  summary 
C)  action 
D)  crosstab

Question 7

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

Accepted Answer

A)  Control 
B)  Form 
C)  Button 
D)  Field 
A)  Control 
B)  Form 
C)  Button 
D)  Field

Question 8

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

Accepted Answer

A) True 
 B)False

Question 9

You switch to Report Layout view to display the entire report as it will appear when printed.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following object prefixes is short for Visual Basic and applies to standard (global) modules?

Accepted Answer

A)  mod 
B)  bas 
C)  vis 
D)  sub 
A)  mod 
B)  bas 
C)  vis 
D)  sub

Question 11

You reference a submacro in a macro list using the command Submacro().

Accepted Answer

A) True 
 B)False

Question 12

Each page of a(n) _____ control is a container for other controls, such as text boxes or command buttons.

Accepted Answer

A)  attachment 
B)  tab 
C)  option group 
D)  combo box 
A)  attachment 
B)  tab 
C)  option group 
D)  combo box

Question 13

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 14

What should you do when you are finished working with a database?

Accepted Answer

A)  Open and then save each object in the database. 
B)  Close the Navigation Pane. 
C)  Sign out so other people can use the database. 
D)  Close the database. 
A)  Open and then save each object in the database. 
B)  Close the Navigation Pane. 
C)  Sign out so other people can use the database. 
D)  Close the database.

Question 15

Which of the following import options means data is not copied from Excel to Access, but stored in the original workbook?

Accepted Answer

A)  Link 
B)  Import 
C)  Append 
D)  Embed 
A)  Link 
B)  Import 
C)  Append 
D)  Embed

Question 16

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

Accepted Answer

A) True 
 B)False

Question 17

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

Accepted Answer

A) True 
 B)False

Question 18

To resize the Detail section in Report Design view, you _____.

Accepted Answer

A)  drag the bottom margin of the Detail section 
B)  drag the right margin of the report 
C)  drag in the vertical ruler 
D)  drag the Detail section bar 
A)  drag the bottom margin of the Detail section 
B)  drag the right margin of the report 
C)  drag in the vertical ruler 
D)  drag the Detail section bar

Question 19

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

Accepted Answer

A) True 
 B)False

Question 20

What would you use to quickly create an Issues table and related forms?

Accepted Answer

A)  a Custom Table 
B)  a Quick Part 
C)  an Application Part 
D)  an Outlook task 
A)  a Custom Table 
B)  a Quick Part 
C)  an Application Part 
D)  an Outlook task

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

Which Access object contains all of the data in the database?

When you create an option group on a form, you enter the Option Value property for each option button.

Which of the following could you use to export records to a new table?

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

You switch to Report Layout view to display the entire report as it will appear when printed.

Which of the following object prefixes is short for Visual Basic and applies to standard (global) modules?

You reference a submacro in a macro list using the command Submacro().

Each page of a(n) _____ control is a container for other controls, such as text boxes or command buttons.

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

What should you do when you are finished working with a database?

Which of the following import options means data is not copied from Excel to Access, but stored in the original workbook?

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

To resize the Detail section in Report Design view, you _____.

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

What would you use to quickly create an Issues table and related forms?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

Which Access object contains all of the data in the database?

When you create an option group on a form, you enter the Option Value property for each option button.

Which of the following could you use to export records to a new table?

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

You switch to Report Layout view to display the entire report as it will appear when printed.

Which of the following object prefixes is short for Visual Basic and applies to standard (global) modules?

You reference a submacro in a macro list using the command Submacro().

Each page of a(n) _____ control is a container for other controls, such as text boxes or command buttons.

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

What should you do when you are finished working with a database?

Which of the following import options means data is not copied from Excel to Access, but stored in the original workbook?

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

To resize the Detail section in Report Design view, you _____.

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

What would you use to quickly create an Issues table and related forms?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters