Question 1

Match between columns
                        Premises: Used to apply animation settings from one object to another
Used to change the order of animation
A type of animation
To copy the format of one object to another
Used to make an animation run after clicking another
Used to anchor a line or arrow
A type of fill
Used to draw the same shape over and over without having to select tool
A type of tab
Identifies the position of an indent level on the ruler

Accepted Answer

The Answer of Emphasis and Format Painter and Trigger and is...

Question 2

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 3

The lines that divide columns and rows are called grids.

Accepted Answer

The lines that divide columns and rows are called cell borders in a table or spreadsheet, not grids. Grids refer to a larger structural system used for layout and design, which can include but is not limited to the division of rows and columns.

Question 4

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 5

You can convert text that is sep arated by a comma into a table.​

Accepted Answer

This can be done using the "Text to Table" feature in Microsoft Word or by importing the text into a spreadsheet program like Microsoft Excel or Google Sheets.

Question 6

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Accepted Answer

The answer of The ____________________ property provides an easy-to-use visual...

Question 7

The Table button is on the Insert tab.

Accepted Answer

The Table button can be found on the Insert tab in Microsoft Word.

Question 8

Pressing [Enter] moves the insertion point to the next cell in the row.

Accepted Answer

Pressing [Enter] moves the insertion point to the next cell in the column, not the row.

Question 9

How does the Enforce Referential Integrity option relate to the creation of orphan records?

Accepted Answer

The answer of How does the Enforce Referential Integrity option...

Question 10

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.​
A)Edit
B)Fields
C)Properties
D)Design

Accepted Answer

The answer of To modify fields and field properties in...

Question 11

Match between columns
                        Premises: Stores numbers from 0 to 255
Stores numbers in the range of 10 to the -324th to +324th power
Stores numbers from -2,147,483,648 to 2,147,483,647
Stores numbers times 10 to the -38th to +38th power
Determines the largest number that can be entered in a field

Accepted Answer

The Answer of Field size and Double and Long integer is...

Question 12

How can you animate objects in PowerPoint?

Accepted Answer

The answer of How can you animate objects in PowerPoint?...

Question 13

A printout of the Relationships window is called the ____________________ report.

Accepted Answer

The answer of A printout of the Relationships window is...

Question 14

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.​

Accepted Answer

The answer of You can only use the Draw pointer...

Question 15

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Accepted Answer

The answer of A(n) ____________________ record is a record in...

Question 16

What are font themes and how do you go about modifying the font themes in PowerPoint?

Accepted Answer

The answer of What are font themes and how do...

Question 17

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?

Accepted Answer

The answer of Kelsey wants to create queries to answer...

Question 18

To change the direction of text in a text object, use the Text Direction button in the _____ group on the Ho me tab.​
A)Font
B)Drawing
C)Paragraph
D)Editing

Accepted Answer

The answer of To change the direction of text in...

Question 19

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Accepted Answer

The answer of Explain why using an employee's last name...

Question 20

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.
A) Validation Rule
B) Description Rule
C) Input Mask
D) Validation Text

Accepted Answer

The answer of Use the ____ property to display an...

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

Match each term with its correct description.

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

The lines that divide columns and rows are called grids.

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

You can convert text that is sep arated by a comma into a table.

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

The Table button is on the Insert tab.

Pressing [Enter] moves the insertion point to the next cell in the row.

How does the Enforce Referential Integrity option relate to the creation of orphan records?

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.

Match the following common Number field properties with the correct description.

How can you animate objects in PowerPoint?

A printout of the Relationships window is called the ____________________ report.

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

What are font themes and how do you go about modifying the font themes in PowerPoint?

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?

To change the direction of text in a text object, use the Text Direction button in the _____ group on the Ho me tab.

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

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

Match each term with its correct description.

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

The lines that divide columns and rows are called grids.

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

You can convert text that is sep arated by a comma into a table.​

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

The Table button is on the Insert tab.

Pressing [Enter] moves the insertion point to the next cell in the row.

How does the Enforce Referential Integrity option relate to the creation of orphan records?

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.​

Match the following common Number field properties with the correct description.

How can you animate objects in PowerPoint?

A printout of the Relationships window is called the ____________________ report.

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.​

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

What are font themes and how do you go about modifying the font themes in PowerPoint?

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?

To change the direction of text in a text object, use the Text Direction button in the _____ group on the Ho me tab.​

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

You can convert text that is sep arated by a comma into a table.

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.

To change the direction of text in a text object, use the Text Direction button in the _____ group on the Ho me tab.