QUESTION 1 You can create a query in Design view or with the Query Wizard. True

Question

QUESTION 1 You can create a query in Design view or with the Query Wizard. True False 1 points Saved QUESTION 2 You click the Run button to execute or run a query. True False 1 points Save Answer QUESTION 3 You can add a criterion into a query to search for records that meet a specific value. True False 1 points Save Answer QUESTION 4 You can use the Unique Values property to direct Access to only display records that don't include duplicated values. True False 1 points Save Answer QUESTION 5 A parameter query asks you to enter the specific criteria value when you run the query. True False

Explanation / Answer

1. TRUE,
Explanation: Design view or Query Design is used to create new queries in the Microsoft Access which is a database tool.

2. True,
Explanation: Run button is used to execute a query, in some applications instead of run, you can find execute button.

3. True,
Explanation: you can add a criterion into a query to search for a record that meets a specific value. You can add it in the where clause.
For example: select * from Students where Student_Name = 'John';
This query fetches the records from Students table in which student name is John.

4. True,
Explanation: Unique record can be retrieved by using Select Distinct query, and unique values for a field can be set by using unique constraint.   

5. True,
Explanation: A parameter query allows you to create a query that can be updated easily to reflect a new search term. When you open a parameter query, Access will prompt you for a search term and then show you query results that reflect your search. For example in the table student records, you want to retrieve the record for the students who are absent on the specific date, if we use the parameter query, the query asks for the user to enter the date, and we can change the date whenever we want.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.