Question 1

The join line between the Appointments and Treatments tables has an arrow pointing to the Treatments table. What join type does this indicate?

Accepted Answer

A)  one-to-many 
B)  inner 
C)  left outer 
D)  SQL 
A)  one-to-many 
B)  inner 
C)  left outer 
D)  SQL

Question 2

How can you list the records in a query datasheet in A-Z order by CustomerName?

Accepted Answer

A)  Click a value in the CustomerName field, and then click the Descending button. 
B)  Click a value in the CustomerName field, and then click the Ascending button. 
C)  Click the Advanced button, and then click Filter By Form. 
D)  Click the CustomerName column heading. 
A)  Click a value in the CustomerName field, and then click the Descending button. 
B)  Click a value in the CustomerName field, and then click the Ascending button. 
C)  Click the Advanced button, and then click Filter By Form. 
D)  Click the CustomerName column heading.

Question 3

To close a form in Form Design view and keep Access running, you _____.

Accepted Answer

A)  right-click the form tab, and then click Close on the shortcut menu. 
B)  right-click the form in the Navigation Pane, and then click Close on the shortcut menu. 
C)  click the Close button on the title bar 
D)  drag the form tab to the Navigation Pane 
A)  right-click the form tab, and then click Close on the shortcut menu. 
B)  right-click the form in the Navigation Pane, and then click Close on the shortcut menu. 
C)  click the Close button on the title bar 
D)  drag the form tab to the Navigation Pane

Question 4

What do you change when you drag the right border of a form in Form Design view?

Accepted Answer

A)  the width of all the form controls 
B)  the margins of the form 
C)  the layout of the form 
D)  the width of the form 
A)  the width of all the form controls 
B)  the margins of the form 
C)  the layout of the form 
D)  the width of the form

Question 5

You might want to create a function to calculate a value based on your company's unique business rules.

Accepted Answer

A) True 
 B)False

Question 6

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

Accepted Answer

A) True 
 B)False

Question 7

_____ a database means to identify the database file as safe to open.

Accepted Answer

A)  Securing 
B)  Enabling 
C)  Trusting 
D)  Splitting 
A)  Securing 
B)  Enabling 
C)  Trusting 
D)  Splitting

Question 8

Which of the following form controls could have an After Update event property that triggers a Sub procedure?

Accepted Answer

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

Question 9

How do you specify an outer join between two tables?

Accepted Answer

A)  In the Relationships window, click the Modify Join button. 
B)  In Query Design View, double-click the join line. 
C)  Add the "outer" criterion to the query design grid. 
D)  Change the order of the fields in the query design grid. 
A)  In the Relationships window, click the Modify Join button. 
B)  In Query Design View, double-click the join line. 
C)  Add the "outer" criterion to the query design grid. 
D)  Change the order of the fields in the query design grid.

Question 10

You can create a table in Table Datasheet view or Table Design view.

Accepted Answer

A) True 
 B)False

Question 11

A mail merge combines data from an Access table or form into a Word form letter.

Accepted Answer

A) True 
 B)False

Question 12

To display the VBA code for a form, click the Build button in one of the form's event properties.

Accepted Answer

A) True 
 B)False

Question 13

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Accepted Answer

A) True 
 B)False

Question 14

Which tab contains options for aligning the text in a report control?

Accepted Answer

A)  Home 
B)  Arrange 
C)  Format 
D)  Page Setup 
A)  Home 
B)  Arrange 
C)  Format 
D)  Page Setup

Question 15

What is the result of selecting the first name in the City column in Report Layout view and then clicking the Center button on the Home tab?

Accepted Answer

A)  The City column moves to the center of the report. 
B)  The City column aligns with the center of the column to its right. 
C)  All the names in the City column are centered. 
D)  Only the first name in the City column is centered. 
A)  The City column moves to the center of the report. 
B)  The City column aligns with the center of the column to its right. 
C)  All the names in the City column are centered. 
D)  Only the first name in the City column is centered.

Question 16

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Accepted Answer

A)  Simple Query Wizard 
B)  Find and Replace 
C)  Filter By Form 
D)  query design grid 
A)  Simple Query Wizard 
B)  Find and Replace 
C)  Filter By Form 
D)  query design grid

Question 17

Madelynn enforced referential integrity on all the one-to-many relationships in the Volunteers database. Provided all data entry was completed after the relationships were established, which join type would not be needed in the database?

Accepted Answer

A)  inner 
B)  self 
C)  right outer 
D)  left outer 
A)  inner 
B)  self 
C)  right outer 
D)  left outer

Question 18

If you move the City column in a table datasheet, _____.

Accepted Answer

A)  the City field also moves in Table Design view 
B)  you must switch to Table Design view and move the City field 
C)  you change the appearance of the table but not the structure 
D)  you must reassign properties for the City field 
A)  the City field also moves in Table Design view 
B)  you must switch to Table Design view and move the City field 
C)  you change the appearance of the table but not the structure 
D)  you must reassign properties for the City field

Question 19

If a SQL statement selects more than one field, which of the following characters do you use to separate the field names?

Accepted Answer

A)  comma (,) 
B)  period (.) 
C)  exclamation mark (!) 
D)  dash (-) 
A)  comma (,) 
B)  period (.) 
C)  exclamation mark (!) 
D)  dash (-)

Question 20

A check box and a command button display "yes" or "no" answers in a field.

Accepted Answer

A) True 
 B)False

The join line between the Appointments and Treatments tables has an arrow pointing to the Treatments table. What join type does this indicate?

How can you list the records in a query datasheet in A-Z order by CustomerName?

To close a form in Form Design view and keep Access running, you _____.

What do you change when you drag the right border of a form in Form Design view?

You might want to create a function to calculate a value based on your company's unique business rules.

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

_____ a database means to identify the database file as safe to open.

Which of the following form controls could have an After Update event property that triggers a Sub procedure?

How do you specify an outer join between two tables?

You can create a table in Table Datasheet view or Table Design view.

A mail merge combines data from an Access table or form into a Word form letter.

To display the VBA code for a form, click the Build button in one of the form's event properties.

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Which tab contains options for aligning the text in a report control?

What is the result of selecting the first name in the City column in Report Layout view and then clicking the Center button on the Home tab?

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Madelynn enforced referential integrity on all the one-to-many relationships in the Volunteers database. Provided all data entry was completed after the relationships were established, which join type would not be needed in the database?

If you move the City column in a table datasheet, _____.

If a SQL statement selects more than one field, which of the following characters do you use to separate the field names?

A check box and a command button display "yes" or "no" answers in a field.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

The join line between the Appointments and Treatments tables has an arrow pointing to the Treatments table. What join type does this indicate?

How can you list the records in a query datasheet in A-Z order by CustomerName?

To close a form in Form Design view and keep Access running, you _____.

What do you change when you drag the right border of a form in Form Design view?

You might want to create a function to calculate a value based on your company's unique business rules.

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

_____ a database means to identify the database file as safe to open.

Which of the following form controls could have an After Update event property that triggers a Sub procedure?

How do you specify an outer join between two tables?

You can create a table in Table Datasheet view or Table Design view.

A mail merge combines data from an Access table or form into a Word form letter.

To display the VBA code for a form, click the Build button in one of the form's event properties.

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Which tab contains options for aligning the text in a report control?

What is the result of selecting the first name in the City column in Report Layout view and then clicking the Center button on the Home tab?

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Madelynn enforced referential integrity on all the one-to-many relationships in the Volunteers database. Provided all data entry was completed after the relationships were established, which join type would not be needed in the database?

If you move the City column in a table datasheet, _____.

If a SQL statement selects more than one field, which of the following characters do you use to separate the field names?

A check box and a command button display "yes" or "no" answers in a field.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters