Exam 3: Maintaining and Querying a Database

 The ___________________ command allows hidden fields to be redisplayed.

 The default group in the Navigation Pane is ____. 

 The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query? 

 Which aggregate function would be used to calculate the lowest field value for the selected records? 

 Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

 The default query type for Access is the Crosstab query. ____________________ 

 The contents of query datasheet are permanent.____________________

 Hiding a field in Datasheet view removes the field from the current table. ____________________ 

 A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

 Results of a query are narrowed by using the Or logical operator. ____________________ 

 A criterion,or rule,that determines which records are selected when a query is run is called a(n) ____. 

 ____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane. 

 The ascending sort order for the Date/Time data type sorts dates from ____________________.

Identify the letter of the choice that best matches the phrase or definition. - The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing 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

 The comparison operator,< >,is used to insert a condition that means ____. 

 Statistical information such as totals and averages is calculated using ____. 

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? - After creating the query,Jorge must set criteria to have the query return only those plants that need full sun.  Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun? 

 Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

 The + symbol is an example of a(n) ____ operator. 

 The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?