Exam 3: Maintaining and Querying a Database

 Data may be sorted in a table datasheet,a form,and a ____. 

 The ____ command removes the display of one or more fields in Datasheet view. 

 The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

 Date criteria are automatically enclosed in ____ when entered in a query design. 

 The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Identify the letter of the choice that best matches the phrase or definition. - The field used to determine the order of records in a datasheet. 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 view must be used to delete an entire record? 

 To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

 Changes made to a field in a query datasheet updates the same field in the table on which the query is based. ____________________ 

Identify the letter of the choice that best matches the phrase or definition. - A dialog box used to enter text,expressions,or other values.

 Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Identify the letter of the choice that best matches the phrase or definition. - The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

 A calculated field is formatted using the ____ for the field. 

 In the criterion,<=250,the operator will return values for the specified field that are ____. 

 When the sort field data for each record in a database is different,the sort field is ____.