Question 1

Changing the _____ property for a field does not change the actual data stored in the field.

Accepted Answer

A)   Short Text
B)   Primary Key
C)   Decimal Places
D)   Number

Question 2

When you import Excel data into an existing Access table, you relate the data to the table.

Accepted Answer

False - ap...

Question 3

How do you rename a table?

Accepted Answer

A)   Right-click the object tab in the Access window, and then click Rename.
B)   Right-click the table in the Navigation Pane, and then click Rename.
C)   Click the table in the Navigation Pane, and then click the Rename button.
D)   Open the table in Table Datasheet view, and then click the Rename button.

Question 4

The _____ key field is the linking field on the "many" side of the relationship.

Accepted Answer

A)   primary
B)   referential
C)   AutoNumber
D)   foreign

Question 5

You can import Access table data from which of the following Office apps? Select all the options that apply.

Accepted Answer

A)   PowerPoint
B)   Access
C)   Excel
D)   Outlook

Question 6

____ makes a duplicate copy of the data in the Access database.

Accepted Answer

A)   Linking
B)   Compacting
C)   Importing
D)   Relating

Question 7

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

Accepted Answer

A)   properties
B)   links
C)   tables
D)   keys

Question 8

To move a field in the query design grid, click its_____, and then drag it left or right.

Accepted Answer

A)   field tag
B)   field key
C)   field string
D)   field selector

Question 9

If a field named Price displays values with three decimal places, what should you do to display the values accurately?

Accepted Answer

A)   Increase the number of decimal places.
B)   Re-enter the field values.
C)   Change the data type of the field.
D)   Decrease the number of decimal places.

Question 10

When can you rename a table?

Accepted Answer

A)   immediately after you open the table
B)   after you close the table
C)   when you open the table in Datasheet view
D)   when you open the table in Design view

Question 11

You can set the Field Size property for a field with a Short Text data type.

Accepted Answer

A) True 
 B)False

Question 12

What happens if you delete a field from a table that contains data?

Accepted Answer

A)   Access stores the deleted data in a new table.
B)   Access stores the deleted data in a new field in the same table.
C)   You can append the deleted data to an existing table.
D)   You delete all the data in the field.

Question 13

You can import table data from _____.

Accepted Answer

A)   another Access database
B)   a PDF file
C)   a Word document
D)   an email message

Question 14

Which of the following are properties you can set for a Currency field? Select all the options that apply.

Accepted Answer

A)   Format
B)   Decimal Places
C)   Default Value
D)   Field Size

Question 15

You can use the _____ to copy data from Excel to Access.

Accepted Answer

A)   Linking Spreadsheet Wizard
B)   Import Spreadsheet Wizard
C)   Edit Relationships dialog box
D)   Copy Data dialog box

Question 16

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

Accepted Answer

A) True 
 B)False

Question 17

To relate two fields in a one-to-many relationship, you connect them using a _____.

Accepted Answer

A)   subdatasheet
B)   common field
C)   field key
D)   data type

Question 18

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Accepted Answer

A) True 
 B)False

Question 19

Which process is most like copying and pasting?

Accepted Answer

A)   importing
B)   relating
C)   querying
D)   linking

Question 20

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

Accepted Answer

A)   Import the data into a new table.
B)   Append the data to an existing table.
C)   Link to the workbook by creating a linked table.
D)   Import the data into a new report.

Exam 2: Formatting Workbook Text and Data

You can import Access table data from which of the following Office apps? Select all the options that apply.

Correct AnswerverifiedShow Answer

The _____ key field is the linking field on the "many" side of the relationship.

Correct AnswerverifiedShow Answer

Which process is most like copying and pasting?

Correct AnswerverifiedShow Answer

You can import table data from _____.

Correct AnswerverifiedShow Answer

You can set the Field Size property for a field with a Short Text data type.

Correct AnswerverifiedShow Answer

When can you rename a table?

Correct AnswerverifiedShow Answer

Which of the following are properties you can set for a Currency field? Select all the options that apply.

Correct AnswerverifiedShow Answer

To relate two fields in a one-to-many relationship, you connect them using a _____.

Correct AnswerverifiedShow Answer

When you import Excel data into an existing Access table, you relate the data to the table.

Correct AnswerverifiedFalse - ap...View AnswerShow Answer

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

Correct AnswerverifiedShow Answer

To move a field in the query design grid, click its_____, and then drag it left or right.

Correct AnswerverifiedShow Answer

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

Correct AnswerverifiedShow Answer

____ makes a duplicate copy of the data in the Access database.

Correct AnswerverifiedShow Answer

You can use the _____ to copy data from Excel to Access.

Correct AnswerverifiedShow Answer

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

Correct AnswerverifiedShow Answer

What happens if you delete a field from a table that contains data?

Correct AnswerverifiedShow Answer

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Correct AnswerverifiedShow Answer

If a field named Price displays values with three decimal places, what should you do to display the values accurately?

Correct AnswerverifiedShow Answer

Changing the _____ property for a field does not change the actual data stored in the field.

Correct AnswerverifiedShow Answer

How do you rename a table?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False - ap...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified