Question 311 / 1 pts________ is the process of arranging data in a specific order based on the value in afield.GroupingCascadingSortingFiltering Show
Question 321 / 1 ptsWhen creating a table sort on two or more fields, the first level of sorting is referred toas the ________ sort field. Get answer to your question and much more Question 331 / 1 ptsIt is not common for a user to need to see all data in all tables which is why creating a________ allowing a user to get a subset of data is so beneficial. Get answer to your question and much more 1 / 1 ptsThe Query window is broken into two parts, the table area and the ________. Get answer to your question and much more Question 351 / 1 ptsFields in the Query Design Grid include all of the following EXCEPT ________.fields that are listed as Primary Keysfields to be sorted on in query resultsfields to be searched on in the query resultsfields to be displayed in query results Question 361 / 1 ptsTo get the results of a Select Query, the user needs to click ________ from the ResultsGroup in the Design Tab. Get answer to your question and much more ExecuteRunStartQuestion 371 / 1 pts________ are the conditions that users can set in a query to identify the specific recordsthey want to return. Get answer to your question and much more Question 381 / 1 ptsAccess will place ________ around a text string within a query criteria that will limit theresults to their exact specifications. Get answer to your question and much more asterisks (*)dollar signs ($)Question 391 / 1 ptsThere are times that users need to use a field as part of their select, but do not want todisplay it on their query results. They can accomplish this by unchecking the ________box on the Query Design Grid for that field.displayshowhidecriteria Upload your study docs or become a Course Hero member to access this document Upload your study docs or become a Course Hero member to access this document End of preview. Want to read all 23 pages? Upload your study docs or become a Course Hero member to access this document #
Is the process of arranging data in a specific order based on the values in the fields?Sorting information or data. In computer science, arranging in an ordered sequence is called "sorting". Sorting is a common operation in many applications, and efficient algorithms to perform it have been developed.
What is the process of moving within a worksheet or workbook called?Glossary. What is the term for the values that a function used to perform operations or calculations?Argument. The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.
Which of the following functions determines the minimum value in a row or column?The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
|