Exam 3: Maintaining and Querying a Database

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? 

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

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

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

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

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

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

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

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.

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

 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. 

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

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

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

 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 ____________________ is a set of records that answers the question resulting from a query.

 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. 

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