FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Maintaining and Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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? -To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query.The Perennial field has a data type of Yes/No.Which criterion should Jorge use in the query for the Perennial field?

A) Yes
B) >No
C) check=yes
D) 'yes'

E) A) and B)
F) All of the above

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Identify the letter of the choice that best matches the phrase or definition. -A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

A sort field is unique if more than one record can have the same value for the sort field.__________________

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

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

Which aggregate function supports the Yes/No field data type?

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

In the criterion,<=250,the operator will return values for the specified field that are ____.

A calculated field is formatted using the ____ for the field.

When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Queries based on more than one table,must have a ____ field.

The + symbol is an example of a(n) ____ operator.