Question 1

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 transferring data between different software programs. The values in a CSV file are typically separated by a comma, which can be used to divide the data into columns when opened in a program like Microsoft Excel or Google Sheets. These columns can then be manipulated and analyzed as needed. Some programs may also have the ability to separate the data into cells of a table, but this may not be as common as using columns of a worksheet. Therefore, the best choice is either a. or b.

Question 2

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 most commonly used delimiters in CSV files to separate the values of each field in a record.

Question 3

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

Exporting data typically involves transferring data from the current database to another file format or location, not importing it into the current database.

Question 4

You can import data stored in a workbook into a new or existing database table.

Accepted Answer

This is possible in many database management systems such as Microsoft Access, MySQL, and Oracle. The data can be imported from various sources including Excel workbooks.

Question 5

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 Import & Link group is specifically designed for importing data from external sources, such as text files. The Export group is for sending data out of Access, while the External Data and Internal Data groups are more general and do not necessarily pertain to importing external data.

Question 6

You can use any document as a form letter, including documents that you create from scratch or a template.

Accepted Answer

This statement is true. Any document can be used as a form letter, including those that are created from scratch or from a template.

Question 7

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 8

The default setting for a mail merge is to print one record in the data source.

Accepted Answer

The default setting for a mail merge is typically to print all records in the data source, not just one.

Question 9

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

Accepted Answer

Data can be exported to various formats including Word documents, HTML documents, and Excel workbooks.

Question 10

When a field name in the data source contains a space, the merge field in Word replaces the space with a question mark.

Accepted Answer

When a field name in the data source contains a space, the merge field in Word replaces the space with an underscore symbol, not a question mark.

Question 11

Most word processors, including Word, can open files with the .rtf file name extension.

Accepted Answer

RTF (Rich Text Format) is a file format that can be opened by most word processors, including Microsoft Word. The .rtf file name extension is commonly used for word processing documents that need to be compatible across different platforms and applications.

Question 12

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 table is the best option as it allows for easy organization and manipulation of the data. Columns, diagrams, and charts may not be the most suitable for storing raw data.

Question 13

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 is a correct description of a form letter.

Question 14

You can start a mail merge from Word, but not from Access.

Accepted Answer

You can start a mail merge from Access, using the "Mail Merge Wizard" or the "Mail Merge" option in the "External Data" tab.

Question 15

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 16

When data is formatted using comma separators, it is called limited data.

Accepted Answer

Data formatted using comma separators is actually called comma-separated values (CSV) data. It is not limited data.

Question 17

If you don't want to print the letter for the currently displayed record, click Exclude this recipient in the Mail Merge pane.

Accepted Answer

This statement is true. Clicking "Exclude this recipient" in the Mail Merge pane will prevent the letter from being printed for the currently displayed record.

Question 18

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 you export 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.

Question 19

The Text fields have the default properties as well, which includes a default Field Size property of 385 characters.

Accepted Answer

The default Field Size property for Text fields in databases like Microsoft Access is 255 characters, not 385.

Question 20

If you select the option for Access to create a primary key, Access will create a field named ID at the beginning of the table and assign it the AutoNumber data type.

Accepted Answer

Access will create a field named ID at the beginning of the table and assign it the AutoNumber data type if the option to create a primary key is selected.

Quiz 6: Access Lesson 6: Integrating Access

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

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