Filters
Question type

Study Flashcards

Case-Based Critical Thinking Questions 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? 


A)  Plant Name and When to Plant
B)  Amount of Sun and Annual 
C)  Plant Name and Amount of Sun
D)  Amount of Sun and When to Plant

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

C

 The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database. 


A)  reconstructing
B)  maintaining 
C)  developing
D)  editing

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

Correct Answer

verifed

verified

 The AutoFilter sort method works on a(n) ____ field(s) . 


A)  multiple
B)  10 fields 
C)  adjacent
D)  single

E) None of the above
F) C) and D)

Correct Answer

verifed

verified

 The condition "Seattle" for the field City in a student database is an example of what type of value? 


A)  text value
B)  field value 
C)  comparison value
D)  criteria value

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

Correct Answer

verifed

verified

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


A)  Count
B)  Average 
C)  Minimum
D)  Sum

E) A) and C)
F) A) and D)

Correct Answer

verifed

verified

A

 Access database objects are divided into categories on the Navigation Pane.____________________

A) True
B) False

Correct Answer

verifed

verified

 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

E) C) and D)
F) A) and C)

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition. - The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode. A)aggregate functions B)Zoom box C)theme D)logical operators E)comparison operator F)condition G)Ctrl + End H)Home I)sort field J)select query

Correct Answer

verifed

verified

  h

 Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon. 


A)  Run
B)  Append 
C)  Show
D)  Design

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

 A ____________________ is a set of records that answers the question resulting from a query.

Correct Answer

verifed

verified

 The most simple technique to use for filtering records is Filter By Form.____________________

A) True
B) False

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition. - A type of query in which you specify the fields and records you want Access to select. A)aggregate functions B)Zoom box C)theme D)logical operators E)comparison operator F)condition G)Ctrl + End H)Home I)sort field J)select query

Correct Answer

verifed

verified

 A combination of database fields,constants,and operators that are used to perform a calculation is called a(n) ____. 


A)  builder
B)  expression 
C)  operator
D)  query

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

 Which keyboard shortcut selects the first field value in the first record when in Navigation Mode? 


A)  Tab
B)  Home + Up Arrow 
C)  Up Arrow
D)  Ctrl+Home

E) B) and D)
F) C) and D)

Correct Answer

verifed

verified

 Access may base queries on one or more tables or queries.____________________

A) True
B) False

Correct Answer

verifed

verified

 It is not possible to create a query from more than one table. ____________________ 

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

 A field with the Short Text data type sorted in descending order will display the data in which order? 


A)  A to Z
B)  lowest to highest 
C)  Z to A
D)  highest to lowest

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

Correct Answer

verifed

verified

 To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon. 


A)  SUM
B)  New Row 
C)  Totals
D)  Add All

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition. - A criterion or rule that determines which records are selected when a query is run.


A) aggregate functions
B) Zoom box
C) theme
D) logical operators
E) comparison operator
F) condition
G) Ctrl + End
H) Home
I) sort field
J) select query

K) B) and H)
L) G) and H)

Correct Answer

verifed

verified

Showing 1 - 20 of 75

Related Exams

Show Answer