Question 1

You can import data into Access from ____.
A) another Access database
B) a JPG file
C) a GIF file
D) a BMP file

Accepted Answer

Access allows importing data from another Access database, but not from image files like JPG, GIF, or BMP.

Question 2

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 "table select" button is used to select the contents of an entire table in Word.

Question 3

By integrating information created in Word, Excel, and Access, the information ____.
A) persists indefinitely
B) is guaranteed to be secure
C) is guaranteed to be accurate
D) works together

Accepted Answer

Integrating information from Word, Excel, and Access allows the data to work together, enabling seamless data sharing and collaboration across these applications.

Question 4

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

You can modify cell formatting in Excel without affecting the linked Access source table.

Question 5

If you are adding ten Excel 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 Excel records...

Question 6

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 a table in an Access database minimizes typing time by automatically transferring the data without manual entry.

Question 7

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

Only the data that you want to appear in the Access table should be included in the workbook, as Access is used for data management and analysis.

Question 8

If you need to create sales charts, order new products, complete purchase orders, and produce proposals to obtain new contracts, you can use ____ techniques in the Office suite to accomplish your tasks.
A) validation
B) authentication
C) certification
D) integration

Accepted Answer

Integration techniques in the Office suite allow you to combine different applications and tools to efficiently accomplish tasks like creating sales charts, ordering products, completing purchase orders, and producing proposals.

Question 9

After exporting 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

In Access, when you import data from Excel, the column headings in the Excel spreadsheet become the field names in the Access table.

Question 10

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

You can append the data to an existing table, which means adding the new data to the end of the existing table without altering the existing data.

Question 11

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.
A) current
B) static
C) secure
D) encrypted

Accepted Answer

Linking the data ensures that any updates made in one application are automatically reflected in the others, keeping the data current.

Question 12

You can enter data into an Access ____.
A) workbook
B) database
C) spreadsheet
D) attachment

Accepted Answer

A database is a collection of data that is organized in a way that makes it easy to access and manage. Access is a database management system that allows you to create and manage databases.

Question 13

You use the ____ command in Access to import data from an outside source.
A) New
B) Open
C) Get External Data
D) Export

Accepted Answer

The "Get External Data" command in Access is used to import data from external sources into an Access database.

Question 14

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

Accepted Answer

Excel is primarily designed for calculations and data analysis, offering advanced calculation tools that are not available in Access, which is a database management system.

Question 15

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.
A) values
B) locations
C) source code
D) data types

Accepted Answer

During the import process, Access allows you to change the data types of fields to ensure they match the intended format and usage within the database.

Question 16

In Microsoft Office 2010, the program that is used for calculations with data is ____.
A) Word
B) Excel
C) Access
D) PowerPoint

Accepted Answer

Excel is a spreadsheet program that is used for calculations with data.

Question 17

You can modify calculations based on the pasted data in Excel that is linked to an Access source table.

Accepted Answer

If the data is linked, changes in the Access source table will update in Excel, and you can modify calculations in Excel based on the updated data.

Question 18

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command.

Accepted Answer

The correct command to use is "Paste Special," which allows you to select from a variety of formatting options when pasting an object into Word.

Question 19

You cannot copy an Access table and paste it directly into Word as a link.

Accepted Answer

You can copy an Access table and paste it into Word as a link using the "Paste Special" feature, which allows you to paste it as a linked object.

Question 20

When pasting into a Word file from Access, ____ show where you will paste the table(s).
A) variables
B) locators
C) placeholders
D) buttons

Accepted Answer

The answer of When pasting into a Word file from...

Quiz 3: Integrating Word and Excel

You can import data into Access from ____.

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

By integrating information created in Word, Excel, and Access, the information ____.

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

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

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

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

If you need to create sales charts, order new products, complete purchase orders, and produce proposals to obtain new contracts, you can use ____ techniques in the Office suite to accomplish your tasks.

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

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

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

You can enter data into an Access ____.

You use the ____ command in Access to import data from an outside source.

Excel contains ____ tools not available in Access.

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

In Microsoft Office 2010, the program that is used for calculations with data is ____.

You can modify calculations based on the pasted data in Excel that is linked to an Access source table.

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command.

You cannot copy an Access table and paste it directly into Word as a link.

When pasting into a Word file from Access, ____ show where you will paste the table(s) .