Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Creates a datasheet of selected fields and records from one or more tables The l

ID: 2408992 • Letter: C

Question

Creates a datasheet of selected fields and records from one or more tables

The lower pane in Query Design View

Limiting conditions used to narrow the number of records on a datasheet

Putting records in ascending or descending order based on a field’s values

Used to search for a pattern

Creates a temporary subset of records

Criterion that finds all records where no entry has been made in the field

Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

Is Null

wildcard

sorting

query

datasheet

filter

criteria

-a.b.c.d.e.f.g.h.

Creates a datasheet of selected fields and records from one or more tables

-a.b.c.d.e.f.g.h.

The lower pane in Query Design View

-a.b.c.d.e.f.g.h.

Limiting conditions used to narrow the number of records on a datasheet

-a.b.c.d.e.f.g.h.

Putting records in ascending or descending order based on a field’s values

-a.b.c.d.e.f.g.h.

Used to search for a pattern

-a.b.c.d.e.f.g.h.

Creates a temporary subset of records

-a.b.c.d.e.f.g.h.

Criterion that finds all records where no entry has been made in the field

-a.b.c.d.e.f.g.h.

Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

a.

Is Null

b.

wildcard

c.

sorting

d.

query

e.

datasheet

f.

filter

g.

criteria

h.

Explanation / Answer

1) Creates a datasheet of selected fields and records from one or more tables - d. query

2) The lower pane in Query Design View - h. Query Grid

3) Limiting conditions used to narrow the number of records on a datasheet - g. criteria

4) Putting records in ascending or descending order based on a field’s values - c. sorting

5) Used to search for a pattern - b. wildcard

6) Creates a temporary subset of records - f. filter

7) Criterion that finds all records where no entry has been made in the field - a. Is Null

8) Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines - e. datasheet

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote