FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Formatting Workbook Text and Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following statements are true about one-to-many relationships? Select all the options that apply.

A) The primary key field is on the "one" side of a one-to-many relationship. between two tables.
B) A linking table connects the two related tables.
C) A record in one table may be related to many records in another table.
D) The foreign key field is on the "many" side of a one-to-many relationship.

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

You cannot modify the Field Size property of a Short Text field.

Correct Answer

verified

False - ca...

View Answer

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?

Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.

To import data from Excel to Access, you would begin by clicking the ____.

You typically increase the decimal places from 1 to 2 for a(n) _____ field.

To rename a table, you must use the Navigation Pane.

What data type should you assign to a WeeklySalary field?

You use the Insert Rows button on the Query Tools Design tab to _____.

The Import Spreadsheet Wizard helps you import Excel data into Access.

For a State field that stores two-letter state abbreviations, you can set the _____ property for the field in Table Datasheet view.

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

What Field Size should you set for a State field that stores two-character state abbreviations?

Which of the following are good candidates for a primary key field for a Customer table? Select all the options that apply.