Test
Access 3
Preguntas del test (10)
1Which of the following functions counts the number of records that have a value in the field?
- AAvg
- BSum
- CCount
- DMax
2When structuring a criteria expression with a parameter that includes one or more wildcards, where can the wildcards be positioned?
- Aat the end
- Bat the beginning
- Cat the beginning and end
- Dany of the above
3Which of the following criterion expressions searches for a ShippingDate field that is greater than January 1, 2019?
- A>1/1/2019
- B>"1/1/2019"
- C>#1/1/2019#
- D>=#1/1/2019#
4Which of the following displays when you build the formula Agent's Name: Left([FirstName],1) &". "&[LastName].
- AJohn Smith
- BJohn.Smith
- CJ.Smith
- DJ. Smith
5After you create a query in Design view, what do you need to do in order to see the results?
- ASelect the table to include in the query.
- BSelect the fields to include in the query.
- CEnter criterion into the query.
- DRun the query.
6Which of the following functions rounds a value?
- ALeft
- BUCase
- Ciif
- DRound
7How many fields can you add to the query design grid?
- A5 or fewer
- B6 to 10
- C11 to 15
- Das many as you like
8Which symbol must be used to specify criterion for the Date/Time data type?
- A$
- B?
- C*
- D#
9Which of the following groups of commands includes buttons to insert and delete fields in the design grid?
- AQuery Wizard
- BQuery Design
- CQuery Setup
- DQuery Type
10Which of the following is added to the design grid of a summary query?
- AAND operator
- BOR operator
- CTotal row
- DCount function
Información
- Descripción
- Access 3 final review
- Autor
- Holly Harper
- Idioma
- English
- Visitas
- 8
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test