Question 1

In a form, how you can highlight the CustomerType text box only when it contains the value New?

Accepted Answer

A)  Apply conditional formatting to the CustomerType text box. 
B)  Change the font color of the text "New" the first time it appears in the form. 
C)  Move the CustomerType text box to the top of the form. 
D)  Use the Format Painter to apply a highlight to the CustomerType text box. 
A)  Apply conditional formatting to the CustomerType text box. 
B)  Change the font color of the text "New" the first time it appears in the form. 
C)  Move the CustomerType text box to the top of the form. 
D)  Use the Format Painter to apply a highlight to the CustomerType text box.

Question 2

Which argument of the MessageBox macro action determines the icon in the message dialog box?

Accepted Answer

A)  Message 
B)  View 
C)  Title 
D)  Type 
A)  Message 
B)  View 
C)  Title 
D)  Type

Question 3

How do you start the Performance Analyzer?

Accepted Answer

A)  Click the Database Tools tab, and then click the Document Database button. 
B)  Click the Database Tools tab, and then click the Analyze Performance button. 
C)  Click the Database Tools tab, and then click the Analyze Database button. 
D)  Click the File tab, click Options, and then click Analyze Performance. 
A)  Click the Database Tools tab, and then click the Document Database button. 
B)  Click the Database Tools tab, and then click the Analyze Performance button. 
C)  Click the Database Tools tab, and then click the Analyze Database button. 
D)  Click the File tab, click Options, and then click Analyze Performance.

Question 4

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

Accepted Answer

A)  to the right of the City field 
B)  to the left of the City field 
C)  in the first column of the query design grid 
D)  below the City field 
A)  to the right of the City field 
B)  to the left of the City field 
C)  in the first column of the query design grid 
D)  below the City field

Question 5

What Field Size should you set for a State field that stores two-character state abbreviations?

Accepted Answer

A)  255 
B)  5 
C)  2 
D)  0 
A)  255 
B)  5 
C)  2 
D)  0

Question 6

Which argument of the OpenReport macro action determines the report to open?

Accepted Answer

A)  Title 
B)  On Click 
C)  View 
D)  Report Name 
A)  Title 
B)  On Click 
C)  View 
D)  Report Name

Question 7

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 8

A line chart uses horizontal bars to compare values, such as annual sales for a company's sales representatives.

Accepted Answer

A) True 
 B)False

Question 9

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

Accepted Answer

A) True 
 B)False

Question 10

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

Accepted Answer

A)  right inner 
B)  orphan outer 
C)  select inner 
D)  right outer 
A)  right inner 
B)  orphan outer 
C)  select inner 
D)  right outer

Question 11

You can use a _____ to add, change, or delete table data based on conditions you specify.

Accepted Answer

A)  conditional format 
B)  datasheet filter 
C)  data macro 
D)  macro program 
A)  conditional format 
B)  datasheet filter 
C)  data macro 
D)  macro program

Question 12

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

Accepted Answer

A)  Total 
B)  Sum 
C)  Count 
D)  Avg 
A)  Total 
B)  Sum 
C)  Count 
D)  Avg

Question 13

In a CSV text file, a comma often separates each field value from another field value.

Accepted Answer

A) True 
 B)False

Question 14

To change the fonts in all the forms and reports in the database, you can change the _____.

Accepted Answer

A)  conditional formatting 
B)  control layout 
C)  theme fonts 
D)  orientation 
A)  conditional formatting 
B)  control layout 
C)  theme fonts 
D)  orientation

Question 15

When building an action query, you do not change data until you click the _____ button.

Accepted Answer

A)  Update 
B)  Select 
C)  Run 
D)  View 
A)  Update 
B)  Select 
C)  Run 
D)  View

Question 16

To run a macro from a form, add a check box control to the form.

Accepted Answer

A) True 
 B)False

Question 17

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

Accepted Answer

A) True 
 B)False

Question 18

How is the font set for a table in Table Datasheet view?

Accepted Answer

A)  Access controls the font automatically. 
B)  You use the Format box on the Table Tools Design tab. 
C)  Access prompts you for the font when you create the table. 
D)  You use the Font box on the Home tab. 
A)  Access controls the font automatically. 
B)  You use the Format box on the Table Tools Design tab. 
C)  Access prompts you for the font when you create the table. 
D)  You use the Font box on the Home tab.

Question 19

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

Accepted Answer

A) True 
 B)False

Question 20

What can you add to a macro to test logical conditions and execute statements only if the conditions are true?

Accepted Answer

A)  Submacro program flow 
B)  MessageBox action 
C)  If program flow 
D)  RunCode action 
A)  Submacro program flow 
B)  MessageBox action 
C)  If program flow 
D)  RunCode action

In a form, how you can highlight the CustomerType text box only when it contains the value New?

Which argument of the MessageBox macro action determines the icon in the message dialog box?

How do you start the Performance Analyzer?

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

What Field Size should you set for a State field that stores two-character state abbreviations?

Which argument of the OpenReport macro action determines the report to open?

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

A line chart uses horizontal bars to compare values, such as annual sales for a company's sales representatives.

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

You can use a _____ to add, change, or delete table data based on conditions you specify.

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

In a CSV text file, a comma often separates each field value from another field value.

To change the fonts in all the forms and reports in the database, you can change the _____.

When building an action query, you do not change data until you click the _____ button.

To run a macro from a form, add a check box control to the form.

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

How is the font set for a table in Table Datasheet view?

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

What can you add to a macro to test logical conditions and execute statements only if the conditions are true?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

In a form, how you can highlight the CustomerType text box only when it contains the value New?

Which argument of the MessageBox macro action determines the icon in the message dialog box?

How do you start the Performance Analyzer?

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

What Field Size should you set for a State field that stores two-character state abbreviations?

Which argument of the OpenReport macro action determines the report to open?

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

A line chart uses horizontal bars to compare values, such as annual sales for a company's sales representatives.

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

You can use a _____ to add, change, or delete table data based on conditions you specify.

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

In a CSV text file, a comma often separates each field value from another field value.

To change the fonts in all the forms and reports in the database, you can change the _____.

When building an action query, you do not change data until you click the _____ button.

To run a macro from a form, add a check box control to the form.

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

How is the font set for a table in Table Datasheet view?

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

What can you add to a macro to test logical conditions and execute statements only if the conditions are true?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters