Purchase Solution

Summarizing query and explaining functions and grouping

Not what you're looking for?

Ask Custom Question

Explain the key concepts that are involved in summarizing data in a query. Include an explanation of functions and grouping. Please provide some examples to illustrate your points.

Purchase this Solution

Solution Summary

The expert summarizes query and explains the functions and grouping. The key concepts that are involved in summarizing data in a query are given.

Solution Preview

Please see attached file

Explain the key concepts that are involved in summarizing data in a query. Include an explanation of functions and grouping. Please provide some examples to illustrate your points.

The process of taking numerous records and collapsing them into a single summary record is called Data Aggregation. It is very important to decide before hand what records must be considered to be included in the summary and in what pattern should they appear. Data can be summarized on the basis of attributes that already exist in the database, and also those that are derived from the database. Once the data to summarize has been decided on, it is imperative to decide how to aggregate the data. Data can be aggregated in innumerably many ...

Purchase this Solution


Free BrainMass Quizzes
Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C# variables and classes

This quiz contains questions about C# classes and variables.

Javscript Basics

Quiz on basics of javascript programming language.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.