Question 1

If the first row of the Excel file does not contain column headings,Access assigns field names of Field1,Field2,etc.

Accepted Answer

A) True 
 B)False

Question 2

If you saved the steps to an import action,you can use the Saved Imports button to run the import in the future.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following field code characters displays a comma?

Accepted Answer

A)  number sign (#) 
B)  dollar sign ($) 
C)  comma (,) 
D)  .00 
A)  number sign (#) 
B)  dollar sign ($) 
C)  comma (,) 
D)  .00

Question 4

One of the simplest ways to create and view an HTML file is in a text editor,such as Notepad.

Accepted Answer

A) True 
 B)False

Question 5

Using the XML and XSD files prevents you from having to modify the field properties in the new table,which saves time.

Accepted Answer

A) True 
 B)False

Question 6

When is it useful to establish a link between Excel and Access?

Accepted Answer

A)  when you database contains many files 
B)  when the data will be primarily used in Excel 
C)  when you want to use the query and reporting capabilities of Access 
D)  both B and C 
A)  when you database contains many files 
B)  when the data will be primarily used in Excel 
C)  when you want to use the query and reporting capabilities of Access 
D)  both B and C

Question 7

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

Accepted Answer

Instead of importing data into Access,yo

Question 8

Using Access,which of the following can you export to?

Accepted Answer

A)  PDF files 
B)  XPS files 
C)  Sharepoint Lists 
D)  all of the above 
A)  PDF files 
B)  XPS files 
C)  Sharepoint Lists 
D)  all of the above

Question 9

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

Accepted Answer

A)  error with importing the file 
B)  subscript out of range 
C)  primary key error 
D)  truncated text value 
A)  error with importing the file 
B)  subscript out of range 
C)  primary key error 
D)  truncated text value

Question 10

When creating a linked table,which of the following are possible errors that may occur?

Accepted Answer

A)  truncated text values 
B)  numbers display instead of dates 
C)  dates display instead of numbers 
D)  all of the above 
A)  truncated text values 
B)  numbers display instead of dates 
C)  dates display instead of numbers 
D)  all of the above

Question 11

Which of the following specify what information from the data source to include in the document?

Accepted Answer

A)  mail merge 
B)  merge fields 
C)  main document 
D)  data source 
A)  mail merge 
B)  merge fields 
C)  main document 
D)  data source

Question 12

When you export forms with a subform or reports with a subreport,the results can be inconsistent.

Accepted Answer

A) True 
 B)False

Question 13

In HTML,which of the following is always used in an end tag?

Accepted Answer

A)  p tag 
B)  tags 
C)  / 
D)  start tag 
A)  p tag 
B)  tags 
C)  / 
D)  start tag

Question 14

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

Accepted Answer

A)  number sign (#) 
B)  dollar sign ($) 
C)  comma (,) 
D)  .00 
A)  number sign (#) 
B)  dollar sign ($) 
C)  comma (,) 
D)  .00

Question 15

If the first row of an imported Excel file doesn't contain column headings,what field names does Access assign?

Accepted Answer

A)  Heading1,Heading2,etc. 
B)  Field1,Field2,etc. 
C)  Title1,Title2,etc. 
D)  Label1,Label2,etc. 
A)  Heading1,Heading2,etc. 
B)  Field1,Field2,etc. 
C)  Title1,Title2,etc. 
D)  Label1,Label2,etc.

Question 16

Which of the following is true when merging number and date fields from Access?

Accepted Answer

A)  the formatting may not transfer 
B)  the data may not transfer 
C)  incomplete data may transfer 
D)  all of the above 
A)  the formatting may not transfer 
B)  the data may not transfer 
C)  incomplete data may transfer 
D)  all of the above

Question 17

Which of the following may display in Access when you import data from an Excel column that contains mixed values?

Accepted Answer

A)  #Num! 
B)  ***** 
C)  11111 
D)  Error! 
A)  #Num! 
B)  ***** 
C)  11111 
D)  Error!

Question 18

In a mail merge,which of the following is the table or query used in the merge?

Accepted Answer

A)  mail merge 
B)  merge fields 
C)  main document 
D)  data source 
A)  mail merge 
B)  merge fields 
C)  main document 
D)  data source

Question 19

If a table already exists in the database,use the import option to append the data to an existing table.

Accepted Answer

A) True 
 B)False

Question 20

If importing Excel data into a new table,how does Access determine what data type to assign for a particular column of data?

Accepted Answer

A)  by looking at the first five rows of data 
B)  by looking at the first six rows of data 
C)  by looking at the first seven rows of data 
D)  by looking at the first eight rows of data 
A)  by looking at the first five rows of data 
B)  by looking at the first six rows of data 
C)  by looking at the first seven rows of data 
D)  by looking at the first eight rows of data

If the first row of the Excel file does not contain column headings,Access assigns field names of Field1,Field2,etc.

If you saved the steps to an import action,you can use the Saved Imports button to run the import in the future.

Which of the following field code characters displays a comma?

One of the simplest ways to create and view an HTML file is in a text editor,such as Notepad.

Using the XML and XSD files prevents you from having to modify the field properties in the new table,which saves time.

When is it useful to establish a link between Excel and Access?

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

Using Access,which of the following can you export to?

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

When creating a linked table,which of the following are possible errors that may occur?

Which of the following specify what information from the data source to include in the document?

When you export forms with a subform or reports with a subreport,the results can be inconsistent.

In HTML,which of the following is always used in an end tag?

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

If the first row of an imported Excel file doesn't contain column headings,what field names does Access assign?

Which of the following is true when merging number and date fields from Access?

Which of the following may display in Access when you import data from an Excel column that contains mixed values?

In a mail merge,which of the following is the table or query used in the merge?

If a table already exists in the database,use the import option to append the data to an existing table.

If importing Excel data into a new table,how does Access determine what data type to assign for a particular column of data?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 3: Creating and Using Queries

If the first row of the Excel file does not contain column headings,Access assigns field names of Field1,Field2,etc.

If you saved the steps to an import action,you can use the Saved Imports button to run the import in the future.

Which of the following field code characters displays a comma?

One of the simplest ways to create and view an HTML file is in a text editor,such as Notepad.

Using the XML and XSD files prevents you from having to modify the field properties in the new table,which saves time.

When is it useful to establish a link between Excel and Access?

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

Using Access,which of the following can you export to?

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

When creating a linked table,which of the following are possible errors that may occur?

Which of the following specify what information from the data source to include in the document?

When you export forms with a subform or reports with a subreport,the results can be inconsistent.

In HTML,which of the following is always used in an end tag?

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

If the first row of an imported Excel file doesn't contain column headings,what field names does Access assign?

Which of the following is true when merging number and date fields from Access?

Which of the following may display in Access when you import data from an Excel column that contains mixed values?

In a mail merge,which of the following is the table or query used in the merge?

If a table already exists in the database,use the import option to append the data to an existing table.

If importing Excel data into a new table,how does Access determine what data type to assign for a particular column of data?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters