1. 70-210 Which of the following statements is true about expressions for calculated fields in Report Writer?

A: Calculated fields can only be used on Custom reports, not on primary and secondary copies of original reports.

B: A calculated field can only be used for calculations and can't be placed in the layout of a report.

C: Values must be placed in both the True and False case fields of a conditional expression.

D: A value should only be entered in the True case field of a conditional expression.

Correct Answers: C

2. 70-214 How many primary copies of an original report can be made in Report Writer?

A: 1

B: 2

C: 3

D: Unlimited

Correct Answers: A

3.  70-526 When the divider tool is placed in the body on a report layout, what restriction is made on the placement of new report fields?

A: Fields cannot be added to the body after the divider tool is placed.

B: Fields cannot be added to the right of the divider tool.

C: Fields cannot be added to the left of the divider tool.

D: Fields cannot be added to the body unless the grid is turned on.

Correct Answers: B

4. 70-216 How many branches of "1 to Many" relationships can you have when linking tables for a report?

A: 0

B: 1

C: 2

D: 5

Correct Answers: B

5. 70-270 Which table stores reports that have been modified in Report Writer?

A: Reports.dic

B: Dynamics.dic

C: Pathnames.doc

D: Dynamics.set

Correct Answers: A

6. 70-290 Which of the following is an advantage of creating a "1 to 1" relationship rather than a "1 to Many" relationship?

A: No advantages exist

B: User defined sorts become possible

C: Data from both tables can be placed on a report layout

D: Most linking restrictions only apply to 1 to Many relationships

Correct Answers: D

7. 70-306 Which of the following tools are available on a text report?

A:Divider Tool

B:Arrow Tool

C:Picture Tool

D:Line Tool

Correct Answers: A, B

8. 70-315 What function and operator are used to remove extra spacing between fields and then join the fields together on a report? (i.e. city, state, zip)

A:UCASE

B:STRIP

C:CONDENSE

D:CAT

Correct Answers: B, D

9.70-320 What function can help align fields that are placed in the report layout?

A: Sort

B: Grid

C: Linking

D: Body

Correct Answers: B

10.70-292 Which of the following expression types are supported for creating user defined fields with Report Writer?

A:Boolean

B:Fractional

C:Calculated

D:Conditional

Correct Answers: C, D