Creating And Using Queries

This question bank verified by Studydeets

Questions Bank

Creating a Database and Tables
Using Design View, Data Validation, and Relationships
Creating and Using Queries
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

All Questions

Question 1

Free

True/False

When importing from an Excel file,the first row of the Excel file must contain the names of all of the fields in the Access table.

Choose correct answer/s

True

False

Check answer

Question 2

Free

True/False

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

Choose correct answer/s

True

False

Check answer

Question 3

Free

True/False

When importing a worksheet into a new table,the original Excel file is not changed in any way during the process.

Choose correct answer/s

True

False

Check answer

Question 4

Free

True/False

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

Choose correct answer/s

True

False

Check answer

Question 5

Free

True/False

A linked table contains records that you can see and edit.

Choose correct answer/s

True

False

Check answer

Question 6

True/False

A linked table provides read-only capabilities within Access.

Choose correct answer/s

True

False

To unlock the question

Question 7

True/False

In the Excel file,if you want to make modifications,the linked table must be open in access when you open the Excel file.

Choose correct answer/s

True

False

To unlock the question

Question 8

True/False

If the data in an Excel column contains some text and some numbers,the #Num! error may display in some cells.

Choose correct answer/s

True

False

To unlock the question

Question 9

True/False

If the data in an Excel column contains mostly numbers,but also includes some dates,every cell in the column will display in the date format.

Choose correct answer/s

True

False

To unlock the question

Question 10

True/False

Microsoft Word is the default text editor in Windows.

Choose correct answer/s

True

False

To unlock the question

Question 11

True/False

Typically a fixed-width file does not include the field names in the first row.

Choose correct answer/s

True

False

To unlock the question

Question 12

True/False

For fixed-width files,or delimited files that do not include field names,Access assigns field names of Field1,Field2,etc.

Choose correct answer/s

True

False

To unlock the question

Question 13

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 14

True/False

The process for importing a fixed-width text file is the same as the process for importing a delimited text file.

Choose correct answer/s

True

False

To unlock the question

Question 15

True/False

If an import process fails completely,the table is not created or updated.

Choose correct answer/s

True

False

To unlock the question

Question 16

True/False

Some import errors are recorded in an error log table that is automatically created by Access.

Choose correct answer/s

True

False

To unlock the question

Question 17

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 18

True/False

When exporting from Access to Excel,formulas used in expressions are exported.

Choose correct answer/s

True

False

To unlock the question

Question 19

True/False

Sometimes data you export from Access needs to be formatted as a text file instead of an Excel file.

Choose correct answer/s

True

False

To unlock the question

Question 20

True/False

Once you create an RTF file,you can edit it in Word.

Choose correct answer/s

True

False

To unlock the question