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 1

Multiple Choice

Review LaterAdd Note

Review Later

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

verified

C

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

 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

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

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

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

 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. 

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

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

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

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

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

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

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

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

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

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

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

 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. 

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.