Question 1

To create a custom slide layout, you choose from one of eight different placeholders . _________________________

Accepted Answer

A) True 
 B)False

Question 2

For a Date/Time field, use the Format property to display the date 1/17/2017 as January 17, 2017.

Accepted Answer

A) True 
 B)False

Question 3

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading.​ ____________________

Accepted Answer

A) True 
 B)False

Question 4

To save a database with a new name, click the File tab and select the Save As New Database command.​

Accepted Answer

A) True 
 B)False

Question 5

The Finish & Merge button is located in the _____ group on the Mailings tab.

Accepted Answer

A)  Mail Merge 
B)  Results 
C)  Finish 
D)  Merge

Question 6

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Accepted Answer

The answer of The Row ____________________ Lookup property stores the...

Question 7

To quickly remove all Lookup properties, change the Display Control property to Combo Box. 
_________________________

Accepted Answer

A) True 
 B)False

Question 8

If you export an Access report to Word, you can use the tools in Word to convert the report into a(n) ____.

Accepted Answer

A)  list 
B)  table 
C)  chart 
D)  outline

Question 9

Connector tools connect shapes with a(n) ____________________ or arrow.

Accepted Answer

The answer of Connector tools connect shapes with a(n) ____________________...

Question 10

Describe the different ways you can sort data in a table and how to do so.

Accepted Answer

The answer of Describe the different ways you can sort...

Question 11

The CONCATENATE function breaks a text string into separate strings.

Accepted Answer

A) True 
 B)False

Question 12

The Split Cells command allows you to split a table into two tables.

Accepted Answer

A) True 
 B)False

Question 13

You can enter optional field descriptions in Table ____ View.

Accepted Answer

A)  SQL 
B)  Query 
C)  Design 
D)  Layout

Question 14

The Greeting Line button is found on the ____ group.

Accepted Answer

A)  Name & Address 
B)  Insert Address 
C)  Write & Insert Fields 
D)  Address

Question 15

Anne Michael is working with the table shown below.  Explain what will happen when she works with the PaymentNo field in Datasheet View. 
Field Name 
Data Type 
PaymentNo 
AutoNumber 
PaymentDate 
Date/Type 
PaymentAmt 
Currency 
SalesNo 
Number

Accepted Answer

The answer of Anne Michael is working with the table...

Question 16

Which of the following is NOT defined in Table Design View?

Accepted Answer

A)  field names 
B)  field entries 
C)  data types 
D)  field properties

Question 17

A font set defines two fonts-a major font for headings and a minor font for body text. _________________________

Accepted Answer

A) True 
 B)False

Question 18

Access 2007-2016 databases are not readable by Access 2003.​

Accepted Answer

A) True 
 B)False

Question 19

You can reference, or ____________________ to, data in other sheets and in other workbooks.

Accepted Answer

The answer of You can reference, or ____________________ to, data...

Question 20

The space before or after paragraphs is called ____.

Accepted Answer

A)  line spacing 
B)  leading 
C)  paragraph spacing 
D)  double spacing

Exam 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

To create a custom slide layout, you choose from one of eight different placeholders . _________________________

For a Date/Time field, use the Format property to display the date 1/17/2017 as January 17, 2017.

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading. ____________________

To save a database with a new name, click the File tab and select the Save As New Database command.

The Finish & Merge button is located in the _____ group on the Mailings tab.

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

To quickly remove all Lookup properties, change the Display Control property to Combo Box. _________________________

If you export an Access report to Word, you can use the tools in Word to convert the report into a(n) ____.

Connector tools connect shapes with a(n) ____________________ or arrow.

Describe the different ways you can sort data in a table and how to do so.

The CONCATENATE function breaks a text string into separate strings.

The Split Cells command allows you to split a table into two tables.

You can enter optional field descriptions in Table ____ View.

The Greeting Line button is found on the ____ group.

Anne Michael is working with the table shown below. Explain what will happen when she works with the PaymentNo field in Datasheet View. Field Name Data Type PaymentNo AutoNumber PaymentDate Date/Type PaymentAmt Currency SalesNo Number

Which of the following is NOT defined in Table Design View?

A font set defines two fonts-a major font for headings and a minor font for body text. _________________________

Access 2007-2016 databases are not readable by Access 2003.

You can reference, or ____________________ to, data in other sheets and in other workbooks.

The space before or after paragraphs is called ____.

Exam 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

To create a custom slide layout, you choose from one of eight different placeholders . _________________________

For a Date/Time field, use the Format property to display the date 1/17/2017 as January 17, 2017.

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading.​ ____________________

To save a database with a new name, click the File tab and select the Save As New Database command.​

The Finish & Merge button is located in the _____ group on the Mailings tab.

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

To quickly remove all Lookup properties, change the Display Control property to Combo Box. _________________________

If you export an Access report to Word, you can use the tools in Word to convert the report into a(n) ____.

Connector tools connect shapes with a(n) ____________________ or arrow.

Describe the different ways you can sort data in a table and how to do so.

The CONCATENATE function breaks a text string into separate strings.

The Split Cells command allows you to split a table into two tables.

You can enter optional field descriptions in Table ____ View.

The Greeting Line button is found on the ____ group.

Anne Michael is working with the table shown below. Explain what will happen when she works with the PaymentNo field in Datasheet View. Field Name Data Type PaymentNo AutoNumber PaymentDate Date/Type PaymentAmt Currency SalesNo Number

Which of the following is NOT defined in Table Design View?

A font set defines two fonts-a major font for headings and a minor font for body text. _________________________

Access 2007-2016 databases are not readable by Access 2003.​

You can reference, or ____________________ to, data in other sheets and in other workbooks.

The space before or after paragraphs is called ____.

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading. ____________________

To save a database with a new name, click the File tab and select the Save As New Database command.

Access 2007-2016 databases are not readable by Access 2003.