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

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

(Essay)

4.7/5

(32)

Question 101

Exciting is the name of one of the Animation categories of effects.

(True/False)

4.7/5

(45)

Question 102

Photo Album is a type of PowerPoint ____.

(Multiple Choice)

4.8/5

(40)

Question 103

You cannot use the fill handle to copy a formula with an external reference indicator.

(True/False)

4.8/5

(41)

Question 104

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

(True/False)

4.8/5

(35)

Question 105

If you release the mouse before you reach a connector site, a(n) ____ is created at the end of the connector.

(Multiple Choice)

4.8/5

(39)

Question 106

The _____ function calculates the current date only.

(Multiple Choice)

4.9/5

(30)

Question 107

Sand is a Texture fill in PowerPoint.

(True/False)

4.8/5

(30)

Question 108

The space between lines of text in the same paragraph is called ____.

(Multiple Choice)

4.9/5

(36)

Question 109

The Relationships button is found on the Design tab of the ribbon.

(True/False)

4.8/5

(28)

Question 110

Why would you want to merge data from an Access database with a letter you create in Word? How can you initiate the merge process?

(Essay)

4.8/5

(43)

Question 111

____________________ determine(s) the distance between the edge of the text and all four edges of the text box.

(Short Answer)

4.8/5

(36)

Question 112

What data type sequences each new record with the next available integer?

(Multiple Choice)

4.9/5

(37)

Question 113

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

(True/False)

4.8/5

(41)

Question 114

The Table button is on the Insert tab.

(True/False)

4.9/5

(35)

Question 115

You export an Access table to Word when you will not need to update the exported information when the database information changes.

(True/False)

4.9/5

(42)

Question 116

It is often easier to add and delete columns and rows using the mouse.

(True/False)

4.8/5

(30)

Question 117

In the Simple Query Wizard dialog box, the _____ button add all fields to the query datasheet.

(Multiple Choice)

4.8/5

(30)

Question 118

Each field must be given an associated field description.

(True/False)

5.0/5

(31)

Question 119

To show paragraph marks, click the Show/Hide button in the _____ group.

(Multiple Choice)

4.8/5

(32)

Question 120

Showing 101 - 120 of 321

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

Exciting is the name of one of the Animation categories of effects.

Photo Album is a type of PowerPoint ____.

You cannot use the fill handle to copy a formula with an external reference indicator.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

If you release the mouse before you reach a connector site, a(n) ____ is created at the end of the connector.

The _____ function calculates the current date only.

Sand is a Texture fill in PowerPoint.

The space between lines of text in the same paragraph is called ____.

The Relationships button is found on the Design tab of the ribbon.

Why would you want to merge data from an Access database with a letter you create in Word? How can you initiate the merge process?

____________________ determine(s) the distance between the edge of the text and all four edges of the text box.

What data type sequences each new record with the next available integer?

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

The Table button is on the Insert tab.

You export an Access table to Word when you will not need to update the exported information when the database information changes.

It is often easier to add and delete columns and rows using the mouse.

In the Simple Query Wizard dialog box, the _____ button add all fields to the query datasheet.

Each field must be given an associated field description.

To show paragraph marks, click the Show/Hide button in the _____ group.

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

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

Exciting is the name of one of the Animation categories of effects.

Photo Album is a type of PowerPoint ____.

You cannot use the fill handle to copy a formula with an external reference indicator.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

If you release the mouse before you reach a connector site, a(n) ____ is created at the end of the connector.

The _____ function calculates the current date only.​

Sand is a Texture fill in PowerPoint.

The space between lines of text in the same paragraph is called ____.

The Relationships button is found on the Design tab of the ribbon.

Why would you want to merge data from an Access database with a letter you create in Word? How can you initiate the merge process?

____________________ determine(s) the distance between the edge of the text and all four edges of the text box.

What data type sequences each new record with the next available integer?

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

The Table button is on the Insert tab.

You export an Access table to Word when you will not need to update the exported information when the database information changes.

It is often easier to add and delete columns and rows using the mouse.

In the Simple Query Wizard dialog box, the _____ button add all fields to the query datasheet.

Each field must be given an associated field description.

To show paragraph marks, click the Show/Hide button in the _____ group.​

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 _____ function calculates the current date only.

To show paragraph marks, click the Show/Hide button in the _____ group.