Question 1

Explain what you know about delimited and fixed-width file formats.

Accepted Answer

The answer of Explain what you know about delimited and...

Question 2

What rules should you keep in mind when you are appending data into an existing table?

Accepted Answer

The answer of What rules should you keep in mind...

Question 3

What are some common errors that occur when creating a new table or appending to an existing table?

Accepted Answer

The answer of What are some common errors that occur...

Question 4

Which of the following field code characters informs the document to format a number with two decimal places?
A) number sign (#)
B) dollar sign ($)
C) comma (,)
D) .00

Accepted Answer

The field code character ".00" is used to inform the document to format a number with two decimal places.

Question 5

With labels,which of the following field codes does Word automatically insert at the beginning of each record? A) < < NewRecord > > B) < < NextRecord > > C) < < NewField > D) < < NextField > >

Accepted Answer

Word automatically inserts the field code < < NextRecord > > at the beginning of each record with labels. This code instructs Word to begin a new record on the next label.

Question 6

When linking to an Excel worksheet,it is best to open the worksheet in __________________ to ensure that the linking process works as you intend.
A) Design view
B) Datasheet view
C) Report view
D) Print Preview view

Accepted Answer

When linking to an Excel worksheet, it is best to open the worksheet in Datasheet view. This view presents the data in a table format, similar to Excel, making it easier to work with the data and ensure the linking process aligns with your intentions.

Question 7

Which of the following errors occurs when you attempt to add records where the primary key column contains inconsistent,missing,or duplicated data?
A) error with importing the file
B) subscript out of range
C) primary key error
D) truncated text value

Accepted Answer

A primary key constraint ensures that a column or combination of columns contain unique values and that no null values are allowed. If inconsistent, missing, or duplicated data is provided, then the primary key constraint cannot be enforced and a primary key error will occur.

Question 8

Which of the following can you use mail merge to create?
A) name badges
B) product tags
C) project folder labels
D) all of the above

Accepted Answer

Mail merge can be used to create all of the above options - name badges, product tags, and project folder labels - and more. It is a useful tool for generating large numbers of personalized documents with minimal effort.

Question 9

What is XML and how does it compare to HTML?

Accepted Answer

The answer of What is XML and how does it...

Question 10

Which of the following field code characters displays a comma?
A) number sign (#)
B) dollar sign ($)
C) comma (,)
D) .00

Accepted Answer

The field code character for comma is ",". None of the other options display a comma.

Question 11

Why might you want to export Access data into Excel? What should you consider when exporting to Excel?

Accepted Answer

The answer of Why might you want to export Access...

Question 12

Explain what you know about creating mailing labels using data from Microsoft Access.

Accepted Answer

The answer of Explain what you know about creating mailing...

Question 13

What are the characteristics of a text file? What is the import process for text files?

Accepted Answer

The answer of What are the characteristics of a text...

Question 14

What is the error log? How is an error log useful?

Accepted Answer

The answer of What is the error log? How is...

Question 15

When is it a good idea to link to a text file?
A) when you will primarily work with the data in the text file
B) when you want to use Access's query capabilities
C) when you want to use Access's reporting capabilities
D) all of the above

Accepted Answer

Linking to a text file is a good idea when you primarily work with the data in the text file, want to use Access's query capabilities, and/or want to use Access's reporting capabilities. By linking to the text file, you can easily access and work with the data without having to import it into Access. Additionally, you can take advantage of Access's powerful features to manipulate and analyze the data, as well as generate reports based on it. Therefore, all three options presented in the question are valid reasons to link to a text file.

Question 16

What is mail merge? What steps does the Microsoft Word Mail Merge Wizard walk you through?

Accepted Answer

The answer of What is mail merge? What steps does...

Question 17

What do you need to do prior to importing an Excel file?
A) display Datasheet view
B) launch the Import Text Wizard button
C) review the XML tags
D) ensure that the formatting of the Excel file is correct

Accepted Answer

Prior to importing an Excel file, it is important to ensure that the formatting of the file is correct. This includes checking for consistent data types in each column, removing any merged cells or blank rows/columns, and ensuring that column headers are clearly labeled. Failing to do so may result in errors or data loss during the import process.

Question 18

What is a linked table and why might you want to link to a table instead of import it?

Accepted Answer

The answer of What is a linked table and why...

Question 19

Which of the following field code characters informs the document that number formatting should be applied to the merge field?
A) number sign (#)
B) dollar sign ($)
C) comma (,)
D) .00

Accepted Answer

The number sign (#) is used in field codes to specify that number formatting should be applied to a merge field in a document. This allows for the proper formatting of numerical data.

Quiz 3: Creating and Using Queries

Explain what you know about delimited and fixed-width file formats.

What rules should you keep in mind when you are appending data into an existing table?

What are some common errors that occur when creating a new table or appending to an existing table?

Which of the following field code characters informs the document to format a number with two decimal places?

With labels,which of the following field codes does Word automatically insert at the beginning of each record?

When linking to an Excel worksheet,it is best to open the worksheet in __________________ to ensure that the linking process works as you intend.

Which of the following errors occurs when you attempt to add records where the primary key column contains inconsistent,missing,or duplicated data?

Which of the following can you use mail merge to create?

What is XML and how does it compare to HTML?

Which of the following field code characters displays a comma?

Why might you want to export Access data into Excel? What should you consider when exporting to Excel?

Explain what you know about creating mailing labels using data from Microsoft Access.

What are the characteristics of a text file? What is the import process for text files?

What is the error log? How is an error log useful?

When is it a good idea to link to a text file?

What is mail merge? What steps does the Microsoft Word Mail Merge Wizard walk you through?

What do you need to do prior to importing an Excel file?

What is a linked table and why might you want to link to a table instead of import it?

Which of the following field code characters informs the document that number formatting should be applied to the merge field?