Question 1

Sylvia wants to align the right edges of the labels on a form.After selecting the controls in Form Design view, what should she do?

Accepted Answer

A)  Click the Align Right button on the Home tab. 
B)  Click the Size/Space button on the Arrange tab and then click To Right. 
C)  Click the Alignment button on the Home tab three times. 
D)  Click the Align button on the Arrange tab and then click Right. 
A)  Click the Align Right button on the Home tab. 
B)  Click the Size/Space button on the Arrange tab and then click To Right. 
C)  Click the Alignment button on the Home tab three times. 
D)  Click the Align button on the Arrange tab and then click Right.

Question 2

After Update is a typical event for a table macro.

Accepted Answer

A) True 
 B)False

Question 3

A report is an easy-to-use data entry and navigation screen.

Accepted Answer

A) True 
 B)False

Question 4

Create a(n) _____ query to change the name of a supervisor in an Employee table.

Accepted Answer

A)  Make-Table 
B)  Update 
C)  Self-Join 
D)  Target 
A)  Make-Table 
B)  Update 
C)  Self-Join 
D)  Target

Question 5

What must you do before setting a database password?

Accepted Answer

A)  Back up the database. 
B)  Open the database in Exclusive mode. 
C)  Encrypt the database. 
D)  Split the database. 
A)  Back up the database. 
B)  Open the database in Exclusive mode. 
C)  Encrypt the database. 
D)  Split the database.

Question 6

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

Accepted Answer

A)  Import the data into a new table. 
B)  Append the data to an existing table. 
C)  Link to the workbook by creating a linked table. 
D)  Import the data into a new report. 
A)  Import the data into a new table. 
B)  Append the data to an existing table. 
C)  Link to the workbook by creating a linked table. 
D)  Import the data into a new report.

Question 7

Where does a background image appear in a report?

Accepted Answer

A)  behind the other controls 
B)  in front of the other controls 
C)  to the right of the other controls 
D)  to the left of the other controls 
A)  behind the other controls 
B)  in front of the other controls 
C)  to the right of the other controls 
D)  to the left of the other controls

Question 8

A macro may contain one or more _____, the tasks that you want Access to perform.

Accepted Answer

A)  events 
B)  conditions 
C)  actions 
D)  queries 
A)  events 
B)  conditions 
C)  actions 
D)  queries

Question 9

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

Accepted Answer

A) True 
 B)False

Question 10

If you _____ in the Form Wizard, you can create a form with a subform.

Accepted Answer

A)  select fields from a single table 
B)  select fields from related tables 
C)  sort the records based on more than one field 
D)  select the tabular form layout 
A)  select fields from a single table 
B)  select fields from related tables 
C)  sort the records based on more than one field 
D)  select the tabular form layout

Question 11

You can add rows to the query grid, but you cannot delete them.

Accepted Answer

A) True 
 B)False

Question 12

Access creates fields with _____ properties as combo boxes on new forms.

Accepted Answer

A)  Scroll Bar 
B)  Control Box 
C)  List 
D)  Lookup 
A)  Scroll Bar 
B)  Control Box 
C)  List 
D)  Lookup

Question 13

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

Accepted Answer

A) True 
 B)False

Question 14

After creating a report with the Report Wizard, you cannot add a sort to the report.

Accepted Answer

A) True 
 B)False

Question 15

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

Accepted Answer

A) True 
 B)False

Question 16

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 17

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _____ button on the Form Layout Tools Arrange tab.

Accepted Answer

A)  Spreadsheet 
B)  Tabular 
C)  Layout 
D)  Group 
A)  Spreadsheet 
B)  Tabular 
C)  Layout 
D)  Group

Question 18

The goal of building one-to-many relationships between tables is to minimize _____ data.

Accepted Answer

A)  misspelled 
B)  rarely used 
C)  numeric 
D)  redundant 
A)  misspelled 
B)  rarely used 
C)  numeric 
D)  redundant

Question 19

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

Accepted Answer

A)  security 
B)  exclusive mode 
C)  window design 
D)  startup 
A)  security 
B)  exclusive mode 
C)  window design 
D)  startup

Question 20

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

Accepted Answer

A)  XSD 
B)  XLSX 
C)  XP 
D)  HTML 
A)  XSD 
B)  XLSX 
C)  XP 
D)  HTML

Sylvia wants to align the right edges of the labels on a form.After selecting the controls in Form Design view, what should she do?

After Update is a typical event for a table macro.

A report is an easy-to-use data entry and navigation screen.

Create a(n) _____ query to change the name of a supervisor in an Employee table.

What must you do before setting a database password?

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

Where does a background image appear in a report?

A macro may contain one or more _____, the tasks that you want Access to perform.

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

If you _____ in the Form Wizard, you can create a form with a subform.

You can add rows to the query grid, but you cannot delete them.

Access creates fields with _____ properties as combo boxes on new forms.

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

After creating a report with the Report Wizard, you cannot add a sort to the report.

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

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?

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _____ button on the Form Layout Tools Arrange tab.

The goal of building one-to-many relationships between tables is to minimize _____ data.

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

Sylvia wants to align the right edges of the labels on a form.After selecting the controls in Form Design view, what should she do?

After Update is a typical event for a table macro.

A report is an easy-to-use data entry and navigation screen.

Create a(n) _____ query to change the name of a supervisor in an Employee table.

What must you do before setting a database password?

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

Where does a background image appear in a report?

A macro may contain one or more _____, the tasks that you want Access to perform.

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

If you _____ in the Form Wizard, you can create a form with a subform.

You can add rows to the query grid, but you cannot delete them.

Access creates fields with _____ properties as combo boxes on new forms.

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

After creating a report with the Report Wizard, you cannot add a sort to the report.

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

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?

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _____ button on the Form Layout Tools Arrange tab.

The goal of building one-to-many relationships between tables is to minimize _____ data.

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters