4. Which is
true about Queries?
A. A Parameter Query asks a question before running the query, such as a
phone number.
B. A Select Query asks a question before running the query, such as a
phone number.
Tip: Beginning Access, page 194
5. Which of the following is true about the Data Source in Query Design
view?
(Give all
correct answers.)
A. Double-clicking the wildcard (*) results in adding one “everything”
field to the QBE grid.
B. Double-clicking the wildcard (*) adds a new, separate field for each
field in the Data Source
C. Double-clicking an individual Field in the Data Source adds that
Field being added to the QBE grid as a separate new Field.
Tip: Beginning Access, page 199
1. What does
Concatenation do?
A. Merges 2 or more cells in a form into one
B. Concentrates the data into just the first part of each field
C. Combines 2 or more fields into a single, new field
Tip: Beginning Access, page 186
2. Which is true about Concatenating Fields?
(Give all
correct answers.)
A. Anything, such as a space, in quotes is put between the Fields
B. The Field name is in Brackets, ie [First Name]
C. The new Field needs a label, or alias
Tip: Beginning Access, page 186
3. What command opens a new window where font size can be adjusted to
better view and work with the code displayed?
A. Zoom Into Code
B. Edit Code
C. Manipulate Code
D. View Code
Tip: Beginning Access, page 191
