Explain when you would use an SQL statement as a record source for a report.

What will be an ideal response?


An SQL statement can be used instead of a query as the basis for a report. Instead of creating a separate query, the report can pull the required data directly from the tables and apply the appropriate criteria. “Named” queries can be modified or deleted, therefore causing their connection to objects that depend on them to break.

Computer Science & Information Technology

You might also like to view...

What dangers are inherent in compaction?

What will be an ideal response?

Computer Science & Information Technology

Which output redirection operator is used to redirect a command's output to a file?

A. ^ (carrot) B. | (pipe) C. < (less than) D. > (greater than)

Computer Science & Information Technology

A search term is a phrase or keyword relevant to the content you are trying to find

Indicate whether the statement is true or false

Computer Science & Information Technology

Which laptop-pointing device is most commonly used today?

A. Trackball B. TouchStick C. Touchpad D. TrackPoint

Computer Science & Information Technology