Question: Why are calculated fields created with database queries? Why not create them directly with reports?

Why are calculated fields created with database queries? Why not create them directly with reports?

Step by Step Solution

★★★★★

3.26 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

This question asks why calculated fields in Access are created with database queries rather tha... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

102-B-A-I-S (559).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Q:

Why dont databases store calculated fields as normal fields in database tables? Do you think they should?

Q:

Create a TaxReturn class with fields that hold a taxpayers Social Security number, last name, first name, street address, city, state, zip code, annual income, marital status, and tax liability....

Q:

Why are some manufacturing costs not directly traceable to products?

Q:

Examine the Relational Schema that was created during the Phase I of the project. Based on that schema, create a set of tables for an MS Access database. Name the database and its tables...

Q:

6.45 Tech Tool: Database Software Software Videos: Database Queries, Calculated Fields Some database designers prefer to not include the calculated fields in the database tables. These fields '...

Q:

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Q:

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

i really need help with an expert on this microsoft Access please. i really need help with an expert on this microsoft Access please. Group Project 1 Instructions Step 1: Read the background...

Q:

1 - Creating Databases and Reports: You are to create an Access database. Your database must have at least eighty (80) records and at least seven (7) fields (per record). You have to create a form...

Q:

Refer to the hypothesis test described in Exercise 1. a. Identify the null hypothesis and the alternative hypothesis. b. If the P-value for the test is reported as less than 0.001, what should we...

Q:

What are some of the negative consequences of firing customers?

Q:

True or false, convertible bonds tend to pay more interest in comparable non - convertible bonds

Q:

Where can we find authoritative guidance for accounting for leases under IFRS?

Q:

Delmont Company entered into these transactions during May 2012. 1. Purchased computers for office use for $30,000 from Dell on account. 2. Paid $4,000 cash for May rent on storage space. 3. Received...

Q:

Delmont Company entered into these transactions during May 2012. 1. Purchased computers for office use for $30,000 from Dell on account. 2. Paid $4,000 cash for May rent on storage space. 3. Received...

Q:

During 2012, its first year of operations as a delivery service, Underwood Corp. entered into the following transactions. 1. Issued shares of common stock to investors in exchange for $100,000 in...

Q:

If the memory access latency is 9 clock cycles

Q:

Triton Company's copy department, which does almost all of the photocopying for the sales department and the administrative department, budgets the following costs for the year, based on the expected...

Q:

The example space posting the eight straightforward occasions that are conceivable when a couple has three youngsters is {bbb, bbg, weave, bgg, gbb, gbg, ggb, ggg}. In the wake of recognizing the...