1. Which is
the acceptable way to Concatenate 2 fields with a space between them?
A. (FirstName)&” “&(LastName)
B. [FirstName]&”space“&[LastName]
C. [FirstName]&” “&[LastName]
Tip: Beginning Access, page 240
2. What Ribbon has the command for the Report Wizard?
A. Home
B. Insert
C. Create
D. Wizards
Tip: Beginning Access, page 243
3. When switching to Design View on a Report that includes a Parameter
Query, you need to enter a parameter before proceeding.
A. True
B. False
Tip: Beginning Access, page 249
4. Refer to
the Concatenation code: FullName: [FirstName]&” “&[LastName]. What is
the label of the new Field created?
A. FullName
B. New Field
C. Unnamed Field
D. Concatenated Name Field
Tip: Beginning Access, page 240
5. Refer to the new field LastNameFirst with the record Smith, Bill.
Which Concatenation will create this field?
A. [LastName]&” “&[FirstName]
B. [LastName]&”,“&[FirstName]
C. [LastName]&”comma“&[FirstName]
Tip: Beginning Access, page 241