Study Guides (299,519)
US (149,858)
UTK (1,553)
AGNR (3)

AGNR 292 Quiz: 292 Quiz 3 study guideExamPremium

2 pages45 viewsSpring 2019

Agriculture and Natural Resources
Course Code
AGNR 292
Kimberly Campbell
Study Guide

This preview shows half of the first page. to view the full 2 pages of the document.
1) 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.
a. Leftmost
b. Rightmost
c. Adjacent to the leftmost field
d. Adjacent to the rightmost field
2) In the criterion, <=250, the operator will return values for the specified field that are
a. Less than 250
b. Equal to 250
c. Less than or equal to 250
d. Great than or equal to 250
3) Queries based on more than one table, must have a ___________ field.
a. Common
b. Similar
c. Text
d. Calculated
4) Statistical information such as totals and averages is calculated using __________.
a. Comparison operators
b. Mathematical operators
c. Aggregate functions
d. Logical functions
5) Which view must be used to delete an entire record
a. Design
b. Query
c. Navigation
d. Datasheet
You're Reading a Preview

Unlock to view full version

Subscribers Only

Loved by over 2.2 million students

Over 90% improved by at least one letter grade.