Question 1

Entering _____ in the Column Width property for a combo box sets the width of the first column to 0.5" and the width of the second column to 2".

Accepted Answer

A)  '0.5;2 
B)  5;2 
C)  2;0.5 
D)  1:0.5;2:2 
A)  '0.5;2 
B)  5;2 
C)  2;0.5 
D)  1:0.5;2:2

Question 2

What criterion would you use to find numbers greater than or equal to 100?

Accepted Answer

A)  +100 
D)  >=100 
A)  +100 
D)  >=100

Question 3

The Patients table and the Visits table have a one-to-many relationship, with the Patients table being the parent table. Which of the following would you use the Find Unmatched Records Wizard to find?

Accepted Answer

A)  Orphan records in the Visits table 
B)  Records in the Patients table that have no related records in the Visits table 
C)  Duplicate records in the Visits table 
D)  Statistics for groups of records in the Visits table 
A)  Orphan records in the Visits table 
B)  Records in the Patients table that have no related records in the Visits table 
C)  Duplicate records in the Visits table 
D)  Statistics for groups of records in the Visits table

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

Using the Report Wizard, you can select the _____ for the report.

Accepted Answer

A)  font colors 
B)  layout 
C)  theme 
D)  font styles 
A)  font colors 
B)  layout 
C)  theme 
D)  font styles

Question 6

In the criterion 8/*/2021, the asterisk (*) is called a wildcard.

Accepted Answer

A) True 
 B)False

Question 7

If you select a(n) _____ control on a form in Form view, it means "yes" or "true".

Accepted Answer

A)  check box 
B)  option button 
C)  command button 
D)  option group 
A)  check box 
B)  option button 
C)  command button 
D)  option group

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

In which of the following circumstances would you copy an entire table?

Accepted Answer

A)  You want to export records to another format. 
B)  You want to create a query with a self join. 
C)  You want to make one table the parent table and the other the child table. 
D)  You want to use the same table structure as in another table. 
A)  You want to export records to another format. 
B)  You want to create a query with a self join. 
C)  You want to make one table the parent table and the other the child table. 
D)  You want to use the same table structure as in another table.

Question 11

You can use the arrow keys to move a selected control in Report Design view.

Accepted Answer

A) True 
 B)False

Question 12

The _____ button creates a new, blank report in Report Design view.

Accepted Answer

A)  Report Design 
B)  Report 
C)  Blank Report 
D)  Report Wizard 
A)  Report Design 
B)  Report 
C)  Blank Report 
D)  Report Wizard

Question 13

What could you do to clarify that the MonthlyRent field in a report contains dollar amounts?

Accepted Answer

A)  Apply the Percent format to the field. 
B)  Decrease the decimal places displayed in the field. 
C)  Apply the Currency format to the field. 
D)  Change the Special Effect property of the field. 
A)  Apply the Percent format to the field. 
B)  Decrease the decimal places displayed in the field. 
C)  Apply the Currency format to the field. 
D)  Change the Special Effect property of the field.

Question 14

A _____ allows you to work with records related to the record in the main form.

Accepted Answer

A)  subform 
B)  hyperlink 
C)  background form 
D)  related form 
A)  subform 
B)  hyperlink 
C)  background form 
D)  related form

Question 15

To remove the navigation bar from a form, set the _____ property to No.

Accepted Answer

A)  Navigation Buttons 
B)  Record Selectors 
C)  Previous and Next 
D)  Scroll Arrows 
A)  Navigation Buttons 
B)  Record Selectors 
C)  Previous and Next 
D)  Scroll Arrows

Question 16

When you split an Access database, what do you call the database containing all the tables?

Accepted Answer

A)  Front-end database 
B)  File-server database 
C)  Back-end database 
D)  Back-up database 
A)  Front-end database 
B)  File-server database 
C)  Back-end database 
D)  Back-up database

Question 17

A(n) _____ is a common control to place within an option group.

Accepted Answer

A)  option button 
B)  text box 
C)  command button 
D)  toggle button 
A)  option button 
B)  text box 
C)  command button 
D)  toggle button

Question 18

You can add one or more _____ to a tab control.

Accepted Answer

A)  property sheets 
B)  headers 
C)  pages 
D)  themes 
A)  property sheets 
B)  headers 
C)  pages 
D)  themes

Question 19

Which control allows you to type an entry or choose an entry from a list?

Accepted Answer

A)  combo box 
B)  list box 
C)  label 
D)  text box 
A)  combo box 
B)  list box 
C)  label 
D)  text box

Question 20

When you click the Application Parts button on the Create tab and then click Issues, you create a new database named Issues.

Accepted Answer

A) True 
 B)False

Entering _____ in the Column Width property for a combo box sets the width of the first column to 0.5" and the width of the second column to 2".

What criterion would you use to find numbers greater than or equal to 100?

The Patients table and the Visits table have a one-to-many relationship, with the Patients table being the parent table. Which of the following would you use the Find Unmatched Records Wizard to find?

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

Using the Report Wizard, you can select the _____ for the report.

In the criterion 8//2021, the asterisk () is called a wildcard.

If you select a(n) _____ control on a form in Form view, it means "yes" or "true".

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

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

In which of the following circumstances would you copy an entire table?

You can use the arrow keys to move a selected control in Report Design view.

The _____ button creates a new, blank report in Report Design view.

What could you do to clarify that the MonthlyRent field in a report contains dollar amounts?

A _____ allows you to work with records related to the record in the main form.

To remove the navigation bar from a form, set the _____ property to No.

When you split an Access database, what do you call the database containing all the tables?

A(n) _____ is a common control to place within an option group.

You can add one or more _____ to a tab control.

Which control allows you to type an entry or choose an entry from a list?

When you click the Application Parts button on the Create tab and then click Issues, you create a new database named Issues.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

Entering _____ in the Column Width property for a combo box sets the width of the first column to 0.5" and the width of the second column to 2".

What criterion would you use to find numbers greater than or equal to 100?

The Patients table and the Visits table have a one-to-many relationship, with the Patients table being the parent table. Which of the following would you use the Find Unmatched Records Wizard to find?

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

Using the Report Wizard, you can select the _____ for the report.

In the criterion 8/*/2021, the asterisk (*) is called a wildcard.

If you select a(n) _____ control on a form in Form view, it means "yes" or "true".

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

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

In which of the following circumstances would you copy an entire table?

You can use the arrow keys to move a selected control in Report Design view.

The _____ button creates a new, blank report in Report Design view.

What could you do to clarify that the MonthlyRent field in a report contains dollar amounts?

A _____ allows you to work with records related to the record in the main form.

To remove the navigation bar from a form, set the _____ property to No.

When you split an Access database, what do you call the database containing all the tables?

A(n) _____ is a common control to place within an option group.

You can add one or more _____ to a tab control.

Which control allows you to type an entry or choose an entry from a list?

When you click the Application Parts button on the Create tab and then click Issues, you create a new database named Issues.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

In the criterion 8//2021, the asterisk () is called a wildcard.