You select the AND operator in "Filtering a Table by Form". Choose the correct statement.Group of answer choicesYou cannot use AND to filter table in AccessThe records will be included in the results only if all the criteria are metThe records will be included in the results only if both criteria are exceeded.The records will be included in the results if at least one criterion is met

You need to define a criteria range if you want to:Group of answer choicesDo advanced filteringUse VLookup functionUse HLookup functiondo any kind of filtering

When would you use an Action query in Access?Group of answer choicesUsers will have to make query with multiple criterias and enhance itMore than one answer is correctUser is required to change the same information in many recordsUsers will have to enter a large number of new records

When entering criteria in the criteria range, criteria that conjunct with either/or  should be entered on _________.Group of answer choicesDifferent rowsSame rowSame columnAll of the answers are correct

Which of the following is a correct statment once you have created a calculated field in query in the Access?Group of answer choicesYou cannot change anythingYou can use it just like any other field in a queryIt will be stored in your excel worksheetYou cannot display it in the query results

Select the correct answerWhat is the purpose of the SQL HAVING clause?OptionsTo filter rows from a tableTo filter rows after groupingTo join two or more tablesTo sort rows in a table