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 . _________________________

(True/False)

5.0/5

(38)

Question 161

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

(True/False)

4.8/5

(37)

Question 162

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

(True/False)

4.9/5

(36)

Question 163

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

(True/False)

4.8/5

(47)

Question 164

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

(Multiple Choice)

4.9/5

(36)

Question 165

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

(Short Answer)

4.9/5

(37)

Question 166

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

(True/False)

4.9/5

(36)

Question 167

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

(Multiple Choice)

4.8/5

(25)

Question 168

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

(Short Answer)

4.8/5

(37)

Question 169

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

(Essay)

5.0/5

(29)

Question 170

The CONCATENATE function breaks a text string into separate strings.

(True/False)

5.0/5

(37)

Question 171

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

(True/False)

4.8/5

(33)

Question 172

You can enter optional field descriptions in Table ____ View.

(Multiple Choice)

4.8/5

(23)

Question 173

The Greeting Line button is found on the ____ group.

(Multiple Choice)

4.8/5

(42)

Question 174

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

(Essay)

4.9/5

(40)

Question 175

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

(Multiple Choice)

4.8/5

(35)

Question 176

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

(True/False)

4.7/5

(33)

Question 177

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

(True/False)

4.9/5

(39)

Question 178

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

(Short Answer)

4.9/5

(40)

Question 179

The space before or after paragraphs is called ____.

(Multiple Choice)

4.8/5

(36)

Question 180

Showing 161 - 180 of 321

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 ____.

Module 4: Integrating Word and Excel Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

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 ____.

Module 4: Integrating Word and Excel Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

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.