Exam 3: Access Module Maintaining and Querying a Database

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial.  He needs to answer the following questions using his database. Which plants need full sun? Which plants are Perennials? -When creating a query to determine which plants need full sun, which fields must be included in the query?

(Multiple Choice)
4.8/5
(41)

Fields included in a query may be modified after the query is saved. 

(True/False)
4.9/5
(31)

____ is the default entry for each field in the Total row of the query design grid.

(Multiple Choice)
4.8/5
(31)

Logical operators must be used in order to combine two or more conditions in a query. 

(True/False)
5.0/5
(38)

The ascending sort order for the Date/Time data type sorts dates from ____________________.

(Short Answer)
4.9/5
(37)

The default query type for Access is the Crosstab query. 

(True/False)
4.8/5
(32)
Showing 61 - 66 of 66
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)