Question 1

When you export data, you copy it from another Access database, an Excel workbook, a text file, or some other file format into an existing or new table in the current database.

Accepted Answer

The answer of When you export data, you copy it...

Question 2

When you start the mail merge from Access, ____.
A) Word sets the data source for you
B) You must choose a data source
C) Access sets the data source for you
D) none of the above

Accepted Answer

The answer of When you start the mail merge from...

Question 3

When data is formatted using comma separators, the comma is called a limiter .

Accepted Answer

When data is formatted using comma separators, the comma is referred to as a delimiter, not a limiter.

Question 4

Most programs have converters to separate the values in a CSV file into the ____.
A) columns of a worksheet
B) cells of a table
C) either a. or b.
D) neither a. nor b.

Accepted Answer

CSV files are commonly used for data storage and exchange. They contain data separated by commas, which can be imported into various programs for further analysis. Most programs that support CSV files have converters to separate the values into either columns of a worksheet or cells of a table, depending on the format of the program where the data is being imported. Therefore, the best choice is C, either a. or b.

Question 5

You can filter mail merge records by clicking the ____ link in the Refine recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab selected.
A) Refine
B) Filter
C) Sort
D) Edit

Accepted Answer

The correct choice is "Filter" because clicking the "Filter" link in the Refine recipient list section opens the Filter and Sort dialog box with the Filter Records tab selected, allowing you to filter mail merge records.

Question 6

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.
A) Mail Merge
B) Form Letter
C) Mailings
D) Insert

Accepted Answer

The Mailings tab contains the Write & Insert Fields group and is where the Insert Merge Field button is located. This allows you to add merge fields individually at the location of the insertion point. The other options (Mail Merge, Form Letter, and Insert) are not specific tabs or groups in Microsoft Word.

Question 7

You can export data to a(n) _____ format.
A) Word document
B) HTML document
C) Excel workbook
D) all of the above

Accepted Answer

The answer of You can export data to a(n) _____...

Question 8

When you need to export data from a database table to an Excel workbook, click the ____ tab on the Ribbon, and then click the Excel button in the Export group.
A) External Data
B) Export
C) Internal Data
D) Import

Accepted Answer

The External Data tab on the Ribbon is specifically designed for importing and exporting data to and from external sources such as Excel workbooks, text files, and other database systems. The Export group within the External Data tab contains options to export data from the database table to various formats, including Excel. Therefore, option A- External Data is the best choice in this scenario.

Question 9

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.
A) Export
B) Import & Link
C) External Data
D) Internal Data

Accepted Answer

The Text File button is located in the Import & Link group on the External Data tab. This button allows you to import data from a text file and create a new table in the database. Option A, Export, is not applicable as the question is about importing data. Option C, External Data, is the name of the tab and does not provide specific information about the required button. Option D, Internal Data, is not a relevant option.

Question 10

The data source for a form letter can be a(n) ____.
A) Word document
B) Excel workbook
C) Access database
D) any of the above

Accepted Answer

The data source for a form letter can be any of the above options. Word documents, Excel workbooks, and Access databases can all be used as a data source for a form letter. The choice ultimately depends on the type of data being used and the format of the form letter being created.

Question 11

In a CSV file, ____ separate the field values of each record in the data source.
A) commas
B) cells
C) colons
D) semi-colons

Accepted Answer

Commas are the standard delimiter used to separate the field values in a CSV (Comma-Separated Values) file. This allows the data to be easily imported and exported between different software programs and databases.

Question 12

When you use the data in a workbook to add records to a database table, the columns in the worksheet ____.
A) must be the same as the fields in the database
B) must contain the same type of data
C) both a. and b.
D) neither a. nor b.

Accepted Answer

The columns in the worksheet must be the same as the fields in the database (a.) and contain the same type of data (b.) in order for the records to be correctly added to the database table. This ensures that the data is properly mapped and formatted for the table.

Question 13

When you import data from a Word document, it is usually best to store it in a Word ____.
A) column
B) table
C) diagram
D) chart

Accepted Answer

Storing imported data from a Word document in a Word table is the most organized and efficient way to maintain the structure and formatting of the original data. Columns, diagrams, and charts may not be suitable for all types of data and may require additional formatting or manipulation.

Question 14

When you insert a merge field in a Word document, the field name is enclosed in double ____.
A) angle brackets
B) parentheses
C) quotation marks
D) none of the above

Accepted Answer

When you insert a merge field in a Word document, the field name is enclosed in double angle brackets (<< >>).

Question 15

In the Mail Merge Recipients dialog box, the ____ section provides options for sorting and filtering data, finding duplicate records, locating a specific recipient, and validating addresses.
A) Update recipient list
B) Import recipient list
C) Refine recipient list
D) Change recipient list

Accepted Answer

The Refine recipient list section allows users to sort and filter data, find duplicate records, locate specific recipients, and validate addresses. The other options listed (Update recipient list, Import recipient list, and Change recipient list) do not include these features.

Question 16

To start a mail merge using Access, open the database that contains the data source for the form letters, and then click the data source (table or query) in the ____ to select it.
A) Task pane
B) status bar
C) Ribbon
D) Navigation Pane

Accepted Answer

The Navigation Pane in Access is where the user can see and select the tables and queries available in the database. This is where the user should select the data source for the mail merge.

Question 17

A form letter is a document that you create using Microsoft Word and that contains codes to tell Word where to insert the record from the data source. The codes are the same as the field names used in the data source.

Accepted Answer

This statement is true.

Question 18

When you merge the data source with the form letter, one letter is printed for each record in the data source. In this case, the form letter is also called the primary document.

Accepted Answer

The answer of When you merge the data source with...

Question 19

When you export the data to Excel, it will be saved in Excel format, with each field in the table stored in a worksheet column and each record in the table stored as a row in the worksheet.

Accepted Answer

When exporting data to Excel, each field in the table is stored in a worksheet column and each record in the table is stored as a row in the worksheet.

Question 20

To create a filter using the Filter and Sort dialog box, use the Field list arrow to select the field to filter, use the Comparison list arrow to choose the filter operator, and then type a value in the ____ text box.
A) Compare to
B) Field
C) Comparison
D) Sort by

Accepted Answer

The "Compare to" text box is where the user types the value to be used as the filter criteria, based on the chosen field and filter operator.

Quiz 1: Microsoft Access Basics

When you export data, you copy it from another Access database, an Excel workbook, a text file, or some other file format into an existing or new table in the current database.

When you start the mail merge from Access, ____.

When data is formatted using comma separators, the comma is called a limiter .

Most programs have converters to separate the values in a CSV file into the ____.

You can filter mail merge records by clicking the ____ link in the Refine recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab selected.

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

You can export data to a(n) _____ format.

When you need to export data from a database table to an Excel workbook, click the ____ tab on the Ribbon, and then click the Excel button in the Export group.

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.

The data source for a form letter can be a(n) ____.

In a CSV file, ____ separate the field values of each record in the data source.

When you use the data in a workbook to add records to a database table, the columns in the worksheet ____.

When you import data from a Word document, it is usually best to store it in a Word ____.

When you insert a merge field in a Word document, the field name is enclosed in double ____.

In the Mail Merge Recipients dialog box, the ____ section provides options for sorting and filtering data, finding duplicate records, locating a specific recipient, and validating addresses.

To start a mail merge using Access, open the database that contains the data source for the form letters, and then click the data source (table or query) in the ____ to select it.

A form letter is a document that you create using Microsoft Word and that contains codes to tell Word where to insert the record from the data source. The codes are the same as the field names used in the data source.

When you merge the data source with the form letter, one letter is printed for each record in the data source. In this case, the form letter is also called the primary document.

When you export the data to Excel, it will be saved in Excel format, with each field in the table stored in a worksheet column and each record in the table stored as a row in the worksheet.

To create a filter using the Filter and Sort dialog box, use the Field list arrow to select the field to filter, use the Comparison list arrow to choose the filter operator, and then type a value in the ____ text box.