(a) Select query:
The following are the uses of a select query:
(i) Displaying the results in a database.
(ii) Retrieving data form one (or more) tables).
(iii) Viewing a subset of records.
(iv) Updating the records from within the datasheet.
(v) Grouping records and doing calculations ( sum, average, counts, totals and other types of calculations).
(b) Parameter query: This is a query that when run displays its own dialog box prompting you for information, such as criteria for retrieving records or a value you want to insert in a field.
(c) Action query: It is a query that makes changes to or moves many records in just one operation.
The following are the types of action queries:
(i) Delete query: A delete query deletes a group of records from one or more tables. Delete queries remove the entire record, not just selected fields within records. For example, you can run a query to delete students in the database who have been expelled in school.
(ii) Update query: Using update query, you can make global changes to a group of records in one or more tables. For example, you can raise marks by 10% for all Students ( or a subset of students).
(iii) Append query: An append query adds a group of records from one or more tables to the end of one or more tables. For example, suppose that you want to promote students in Form 1 to Form 2, you can append records into the Form 2 table and delete them using a Delete query form Form 1 table.
(iv) Make-table query: A make-table query creates a new table from data in one or more tables. For example, from school database, you can run a Make table query to create a particular Dormitory details table.
(v) Crosstab queries: Crosstab queries calculate a sum, average, count, or other types of total for data that is grouped by two types of information-one down the left side of the datasheet and another across the top.
maurice.mutuku answered the question on April 12, 2018 at 06:00
- Why would you use queries in databases?(Solved)
Give reasons why you would use queries in databases.
Date posted: April 12, 2018. Answers (1)
- State the applications of digital cameras(Solved)
State the applications of digital cameras.
Date posted: April 11, 2018. Answers (1)
- Giving examples, describe the various classifications of input devices(Solved)
Giving examples, describe the various classifications of input devices
Date posted: April 11, 2018. Answers (1)
- What is a datasheet?(Solved)
Define the term datasheet.
Date posted: April 11, 2018. Answers (1)
- What is a switchboard?(Solved)
Define switchboard.
Date posted: April 11, 2018. Answers (1)
- What are the main categories of controls found used in Ms Access?(Solved)
Discuss the main categories of controls found used in Ms Access.
Date posted: April 11, 2018. Answers (1)
- What is "Control" as used in form design?(Solved)
Define the term "Control" as used in form design
Date posted: April 11, 2018. Answers (1)
- What are the major sections of a form in design view?(Solved)
Discuss the major sections of a form in a design view.
Date posted: April 11, 2018. Answers (1)
- What are the views applicable to a form?(Solved)
List the views applicable to a form.
Date posted: April 11, 2018. Answers (1)
- What is a subform?(Solved)
Define a subform.
Date posted: April 11, 2018. Answers (1)
- What are the steps of creating a new form from a database wizard?(Solved)
Explain the steps of creating a new form from a database wizard.
Date posted: April 11, 2018. Answers (1)
- How would you create a backup copy of your file from your computer to an external storage such as a flash disk in a database...(Solved)
Explain how you would create a backup copy of your file from your computer to an external storage such as a flash disk in a database called CLASS, while using MS Access.
Date posted: April 11, 2018. Answers (1)
- How would you create Command Buttons that open other forms by using a wizard?(Solved)
Clearly describe the steps you would require to create Command Buttons that open the other forms by using a wizard.
Date posted: April 11, 2018. Answers (1)
- What are the steps required in adjusting the row height and column size in the datasheet view environment?(Solved)
Discuss the steps required in adjusting the row height and column size in the datasheet view environment.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Caption and Required properties of a field?(Solved)
Distinguish between Caption and Required properties of a field.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Indexed and default value?(Solved)
Differentiate between Indexed and default value.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Validation rule and Validation text?(Solved)
Distinguish between Validation rule and Validation text.
Date posted: April 11, 2018. Answers (1)
- What is the difference between Input mask and Format as properties of a field?(Solved)
Differentiate between Input mask and Format as properties of a field.
Date posted: April 11, 2018. Answers (1)
- What is the meaning of the term "index" as used in databases?(Solved)
Define the term "index" as used in database.
Date posted: April 11, 2018. Answers (1)
- What is the difference between a primary key and a foreign key?(Solved)
Distinguish between a primary key and a foreign key.
Date posted: April 11, 2018. Answers (1)