Question 1

To create a new database, click the  __________ desktop database button.​

Accepted Answer

The answer of To create a new database, click the...

Question 2

When the Paste Special dialog box is open in Word, select the ____ option to paste text as formatted text.
A) Formatted Text (RTF)
B) Unformatted Text
C) Plain Text
D) Unformatted Unicode Text

Accepted Answer

Selecting the "Formatted Text (RTF)" option will paste the text with its formatting intact, making it the best choice for pasting formatted text. The other options will either remove all formatting (Unformatted Text and Plain Text) or only preserve Unicode characters without any formatting (Unformatted Unicode Text).

Question 3

In Excel, to adjust the column widths to Autofit, select the data, click the ____________________ button in the Cells group, then click AutoFit Column Width.

Accepted Answer

The answer of In Excel, to adjust the column widths...

Question 4

If an Access table is the ____ of the data in a table in Word, whenever you change the data in the Access table, the linked data in Word also changes.
A) destination
B) image
C) source
D) copy

Accepted Answer

The source of data is the original data that is being pulled into another program or application. In this case, the Access table is the source of the data being linked into the Word document. Therefore, whenever changes are made in the original source (Access table), those changes will be reflected in the linked data in Word. The other answer choices don't fit as well, as destination implies where the linked data is going (not where it's coming from), image and copy both suggest a duplication of the original data rather than a linkage, which is not an accurate description of the situation.

Question 5

To copy a table in Word, click the table select button, and then click the Copy button in the _____ group.​
A) ​Table Copy
B) ​Clipboard
C) Advanced
D) ​Copy & Paste

Accepted Answer

The correct group to click on to copy a table in Word is the Clipboard group. The other options listed are not groups within Word and do not apply to copying tables.

Question 6

When you open a linked Excel file, click _____ if prompted and click Update in response to the message​. ​
A) ​Enable Content
B) ​Activate
C) ​Manage Link
D) ​Refresh

Accepted Answer

When opening a linked Excel file, it is important to enable content if prompted. This will ensure that any updates or changes made to the linked file will be reflected in the current file. Additionally, if a message appears asking to update the link, clicking "Update" will ensure that the most recent version of the linked file is being used.

Question 7

In Word, you can click the ____ button to select the contents of an entire table.
A) Tables and Borders
B) Insert Table
C) Insert Hyperlink
D) table select

Accepted Answer

The answer of In Word, you can click the ____...

Question 8

After pasting data into Excel that is linked to an Access source table, you can ____.
A) delete rows
B) modify cell formatting
C) delete columns
D) modify the Access source table from Excel

Accepted Answer

The answer of After pasting data into Excel that is...

Question 9

If you enter the formula =C2*D2 into a cell, you are performing a(n) _____ calculation. ​
A) ​addition
B) ​subtraction
C) ​multiplication
D) ​division

Accepted Answer

The formula =C2*D2 represents a multiplication calculation.

Question 10

After importing Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.
A) data cells
B) row ids
C) record pointers
D) field names

Accepted Answer

When importing Excel data into Access, the column headings in the Excel spreadsheet become field names in the Access table.

Question 11

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.
A) titles
B) data
C) subtitles
D) charts

Accepted Answer

When exporting from Excel to Access, only the data that needs to be added to the Access table should be included. Titles, subtitles, and charts are not necessary for the importing process and may lead to errors or confusion during the import.

Question 12

You can minimize typing time by ____ Excel data directly into a table in an Access database.
A) importing
B) exporting
C) compressing
D) encrypting

Accepted Answer

Importing Excel data directly into an Access database saves time by avoiding manual data entry. The data can be easily mapped to the corresponding fields in the Access table. This option is not available with exporting, compressing, or encrypting.

Question 13

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.​
A) ​Styles
B) ​Formatting
C) ​Editing
D) ​Font

Accepted Answer

The Borders list arrow is located in the Font group on the Home tab in Excel.

Question 14

In the Get External Data - Excel Spreadsheet dialog box, the Browse button ____.
A) closes the window
B) opens a dialog box
C) opens the specified file
D) appends a record

Accepted Answer

The Browse button in the Get External Data - Excel Spreadsheet dialog box opens a browse dialog box that allows the user to navigate to and select the desired Excel file for importing external data.

Question 15

You can copy an existing table from Word and paste it into a new Access ____________________.

Accepted Answer

The answer of You can copy an existing table from...

Question 16

Excel contains ____ tools not available in Access.
A) data storage
B) copy
C) calculation
D) pasting

Accepted Answer

Excel has more advanced calculation and formula features compared to Access. Access primarily focuses on data storage and retrieval, while Excel is designed for more complex calculations and data analysis. Copying, pasting, and data storage are available in both programs.

Question 17

To apply the accounting format to a range of selected cells, click the Accounting Number Format button in the ____________________ group.

Accepted Answer

The answer of To apply the accounting format to a...

Question 18

If you are adding ten Word records to an existing Access table, you should ensure that the Access table has ____.
A) at least one record
B) the same number of records
C) more than ten records
D) less than ten records

Accepted Answer

The answer of If you are adding ten Word records...

Question 19

If you want to paste a Word table into an Access table that already contains records, you need to make sure that the Word table contains the same number of ___________________ as the Access table.

Accepted Answer

The answer of If you want to paste a Word...

Question 20

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.
A) extract
B) overwrite
C) append
D) join

Accepted Answer

Choosing to append the data to an existing table ensures that you do not overwrite any existing data and allows for easier management of data within the database.

Quiz 11: Integration 2: Integrating Word Excel and Access

To create a new database, click the __________ desktop database button.

When the Paste Special dialog box is open in Word, select the ____ option to paste text as formatted text.

In Excel, to adjust the column widths to Autofit, select the data, click the ____________________ button in the Cells group, then click AutoFit Column Width.

If an Access table is the ____ of the data in a table in Word, whenever you change the data in the Access table, the linked data in Word also changes.

To copy a table in Word, click the table select button, and then click the Copy button in the _____ group.

When you open a linked Excel file, click _____ if prompted and click Update in response to the message.

In Word, you can click the ____ button to select the contents of an entire table.

After pasting data into Excel that is linked to an Access source table, you can ____.

If you enter the formula =C2*D2 into a cell, you are performing a(n) _____ calculation.

After importing Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

You can minimize typing time by ____ Excel data directly into a table in an Access database.

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.

In the Get External Data - Excel Spreadsheet dialog box, the Browse button ____.

You can copy an existing table from Word and paste it into a new Access ____________________.

Excel contains ____ tools not available in Access.

To apply the accounting format to a range of selected cells, click the Accounting Number Format button in the ____________________ group.

If you are adding ten Word records to an existing Access table, you should ensure that the Access table has ____.

If you want to paste a Word table into an Access table that already contains records, you need to make sure that the Word table contains the same number of ___________________ as the Access table.

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

Quiz 11: Integration 2: Integrating Word Excel and Access

To create a new database, click the __________ desktop database button.​

When the Paste Special dialog box is open in Word, select the ____ option to paste text as formatted text.

In Excel, to adjust the column widths to Autofit, select the data, click the ____________________ button in the Cells group, then click AutoFit Column Width.

If an Access table is the ____ of the data in a table in Word, whenever you change the data in the Access table, the linked data in Word also changes.

To copy a table in Word, click the table select button, and then click the Copy button in the _____ group.​

When you open a linked Excel file, click _____ if prompted and click Update in response to the message​. ​

In Word, you can click the ____ button to select the contents of an entire table.

After pasting data into Excel that is linked to an Access source table, you can ____.

If you enter the formula =C2*D2 into a cell, you are performing a(n) _____ calculation. ​

After importing Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

You can minimize typing time by ____ Excel data directly into a table in an Access database.

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.​

In the Get External Data - Excel Spreadsheet dialog box, the Browse button ____.

You can copy an existing table from Word and paste it into a new Access ____________________.

Excel contains ____ tools not available in Access.

To apply the accounting format to a range of selected cells, click the Accounting Number Format button in the ____________________ group.

If you are adding ten Word records to an existing Access table, you should ensure that the Access table has ____.

If you want to paste a Word table into an Access table that already contains records, you need to make sure that the Word table contains the same number of ___________________ as the Access table.

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

To create a new database, click the __________ desktop database button.

To copy a table in Word, click the table select button, and then click the Copy button in the _____ group.

When you open a linked Excel file, click _____ if prompted and click Update in response to the message.

If you enter the formula =C2*D2 into a cell, you are performing a(n) _____ calculation.

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.