Get premium membership and access questions with answers, video lessons as well as revision papers.
(i) Queries are often used as the basis for forms and reports or other queries in database.
Unlike filters, queries can be saved and used as a data source for other Ms Access objects such as reports, forms or data access pages.
(ii) Queries allow you to perform calculations in a database.
(iii) Queries allow you to make changes to data (modify)
(iv) Queries allow the user to extract or retrieve a subset of data from one (or more) tables in a database or from other queries. This means that instead of scanning the whole table, you can pre-define the categories of information which will be sought.
(v) Queries also allow the user to join multiple tables. For example, if you have a table called "customers" and a table called"invoices", you can use a query to join the two tables.
When you run a query that joins these tables, you can get results showing the name of the customer (from the customer table) and all associated invoices (from the invoice table).
maurice.mutuku answered the question on April 12, 2018 at 05:36
- 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)
- What are the data types used in Ms Access?(Solved)
List and explain examples of data types used in Ms Access.
Date posted: April 11, 2018. Answers (1)