Question 1

You use _____ to mark up structured data so you can easily share the data with other programs.

Accepted Answer

A)  XML 
B)  HTML 
C)  ODBC 
D)  dBase 
A)  XML 
B)  HTML 
C)  ODBC 
D)  dBase

Question 2

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

Accepted Answer

A)  Select query with a self join. 
B)  Update query. 
C)  Select query with an outer join. 
D)  Append query. 
A)  Select query with a self join. 
B)  Update query. 
C)  Select query with an outer join. 
D)  Append query.

Question 3

When you import Excel data into an existing Access table, you relate the data to the table.

Accepted Answer

A) True 
 B)False

Question 4

What do you use to open a database in Exclusive mode?

Accepted Answer

A)  Create tab on the ribbon 
B)  Navigation Pane 
C)  Open dialog box 
D)  Access Options dialog box 
A)  Create tab on the ribbon 
B)  Navigation Pane 
C)  Open dialog box 
D)  Access Options dialog box

Question 5

If you move a text box in Form Design view, you _____.

Accepted Answer

A)  move the other text boxes in the column 
B)  move the label associated with that text box 
C)  must reset the margins of the form 
D)  change the tab order of the text box 
A)  move the other text boxes in the column 
B)  move the label associated with that text box 
C)  must reset the margins of the form 
D)  change the tab order of the text box

Question 6

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

Accepted Answer

A) True 
 B)False

Question 7

You can right-click a macro in the Navigation Pane to copy and paste it to create a backup.

Accepted Answer

A) True 
 B)False

Question 8

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

Accepted Answer

A) True 
 B)False

Question 9

How can you remove a label from a control layout so you can move and resize the label separate from the other controls?

Accepted Answer

A)  Select the label and then click the Remove Layout button. 
B)  Drag the label to a blank part of the form. 
C)  Split the label horizontally or vertically. 
D)  Snap the label to the grid. 
A)  Select the label and then click the Remove Layout button. 
B)  Drag the label to a blank part of the form. 
C)  Split the label horizontally or vertically. 
D)  Snap the label to the grid.

Question 10

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

Accepted Answer

A) True 
 B)False

Question 11

To rename a field in Table Datasheet view, you change the text in the _____.

Accepted Answer

A)  column heading 
B)  first record 
C)  primary key 
D)  Navigation Pane 
A)  column heading 
B)  first record 
C)  primary key 
D)  Navigation Pane

Question 12

_____ modules are displayed as module objects in the Navigation Pane.

Accepted Answer

A)  Class 
B)  Standard 
C)  Macro 
D)  Method 
A)  Class 
B)  Standard 
C)  Macro 
D)  Method

Question 13

Which of the following views should you use to modify the size, position, and formatting of report controls while displaying live data?

Accepted Answer

A)  Report Design view 
B)  Report view 
C)  Report Layout view 
D)  Print Preview 
A)  Report Design view 
B)  Report view 
C)  Report Layout view 
D)  Print Preview

Question 14

What could you do to clarify that the TaxRate field in a report contains percentages?

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 15

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

Accepted Answer

A) True 
 B)False

Question 16

How can examining object dependencies help you when developing a database?

Accepted Answer

A)  It identifies potential performance problems. 
B)  It flags naming conflicts among database objects. 
C)  It deletes objects you have not used recently. 
D)  It can prevent you from deleting a query used by another object. 
A)  It identifies potential performance problems. 
B)  It flags naming conflicts among database objects. 
C)  It deletes objects you have not used recently. 
D)  It can prevent you from deleting a query used by another object.

Question 17

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

Accepted Answer

A)  properties 
B)  links 
C)  tables 
D)  keys 
A)  properties 
B)  links 
C)  tables 
D)  keys

Question 18

You use conditional formatting to highlight important data in a report.

Accepted Answer

A) True 
 B)False

Question 19

The On Current event of a form is triggered when you navigate through records.

Accepted Answer

A) True 
 B)False

Question 20

What is the advantage of grouping controls on a form?

Accepted Answer

A)  They look more attractive on the form. 
B)  You automatically organize them into difference sections. 
C)  You can apply the same changes to the controls all at once. 
D)  You can sort the controls within the group. 
A)  They look more attractive on the form. 
B)  You automatically organize them into difference sections. 
C)  You can apply the same changes to the controls all at once. 
D)  You can sort the controls within the group.

You use _____ to mark up structured data so you can easily share the data with other programs.

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

When you import Excel data into an existing Access table, you relate the data to the table.

What do you use to open a database in Exclusive mode?

If you move a text box in Form Design view, you _____.

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

You can right-click a macro in the Navigation Pane to copy and paste it to create a backup.

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

How can you remove a label from a control layout so you can move and resize the label separate from the other controls?

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

To rename a field in Table Datasheet view, you change the text in the _____.

_____ modules are displayed as module objects in the Navigation Pane.

Which of the following views should you use to modify the size, position, and formatting of report controls while displaying live data?

What could you do to clarify that the TaxRate field in a report contains percentages?

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

How can examining object dependencies help you when developing a database?

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

You use conditional formatting to highlight important data in a report.

The On Current event of a form is triggered when you navigate through records.

What is the advantage of grouping controls on a form?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

You use _____ to mark up structured data so you can easily share the data with other programs.

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

When you import Excel data into an existing Access table, you relate the data to the table.

What do you use to open a database in Exclusive mode?

If you move a text box in Form Design view, you _____.

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

You can right-click a macro in the Navigation Pane to copy and paste it to create a backup.

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

How can you remove a label from a control layout so you can move and resize the label separate from the other controls?

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

To rename a field in Table Datasheet view, you change the text in the _____.

_____ modules are displayed as module objects in the Navigation Pane.

Which of the following views should you use to modify the size, position, and formatting of report controls while displaying live data?

What could you do to clarify that the TaxRate field in a report contains percentages?

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

How can examining object dependencies help you when developing a database?

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

You use conditional formatting to highlight important data in a report.

The On Current event of a form is triggered when you navigate through records.

What is the advantage of grouping controls on a form?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters