How can you calculate expressions when the data is not immediately available in a table? What is this called and how did you use this technique to answer the manager's questions for Jasmine?
What will be an ideal response?
If data is needed for a calculation but is not stored in a table, a query can be created to include that calculation. Then that query can be used in another query for additional calculations. This is called subquerying. The subquery is created by first building separate queries, using one as the source for the other, and then writing a master query that pulls the data from the first two queries together. To answer the question of how much does each subject contribute to total revenue, an aggregate query was created, then a query to calculate total revenue. When the two queries are used in the master query, a percent can be calculated.
You might also like to view...
________ allows a user to import up to one million rows of data from multiple sources, such as large corporate databases, public data feeds, spreadsheets, and text files on your computer
Fill in the blank(s) with the appropriate word(s).
Rasha is working in QuickBooks as a heavy storm begins. Her building is notorious for losing power during storms, so she wants to save her company file right away. How should she do this?
A. There is no need to save because QuickBooks automatically saves all actions. B. Choose File > Back Up Company > Save Company File. C. Click the Save icon at the top right of the QuickBooks window. D. Choose File > Company File > Save.
Bob is configuring egress filtering on his network, examining traffic destined for the Internet. His organization uses the public address range 12.8.195.0/24. Packets with which one of the following destination addresses should Bob permit to leave the network?
A. 12.8.195.15 B. 10.8.15.9 C. 192.168.109.55 D. 129.53.44.124
In a(n) ____________________ connection, a single character, or byte of data, is the unit of transfer between the sender and receiver.
Fill in the blank(s) with the appropriate word(s).