The tblBooks table in the Books database contains a numeric field named Quantity. Which of the following
Question:
The tblBooks table in the Books database contains a numeric field named Quantity. Which of the following determines the total number of books in the BooksDataSet?
a. Dim intNumBooks As Integer =
Aggregate book In BooksDataSet.tblBooks
Into Count
b. Dim intNumBooks As Integer =
Aggregate book In BooksDataSet.tblBooks
Select book.Quantity
Into Sum
c. Dim intNumBooks As Integer =
Aggregate book In BooksDataSet.tblBooks
Into Sum
d. Dim intNumBooks As Integer =
Aggregate book In BooksDataSet.tblBooks
Into Total
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 58% (12 reviews)
b Dim intNumBooks A...View the full answer
Answered By
Madhvendra Pandey
Hi! I am Madhvendra, and I am your new friend ready to help you in the field of business, accounting, and finance. I am a College graduate in B.Com, and currently pursuing a Chartered Accountancy course (i.e equivalent to CPA in the USA). I have around 3 years of experience in the field of Financial Accounts, finance and, business studies, thereby looking forward to sharing those experiences in such a way that finds suitable solutions to your query.
Thus, please feel free to contact me regarding the same.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
The tblInventory table contains a numeric field named InStock. Which of the following statements selects all records having at least 500 of the item in stock? a. Dim records = From item In...
-
The tblInventory table contains a numeric field named InStock. Which of the following statements calculates the total of the items in inventory? a. Dim intTotal As Integer = Aggregate item In...
-
The strItem variable contains uppercase letters only. Which of the following determines whether the variable contains either the word SHIRT or the word SKIRT? a. If strItem Like "S[H-K]IRT" Then b....
-
In Exercises simplify the ratio of factorials. (n + 1)! n!
-
Belly-flop Bernie dives from atop a tall flagpole into a swimming pool below. His potential energy at the top is 10,000 J (relative to the surface of the pool). What is his kinetic energy when his...
-
A large corporation issued both fixed and floating-rate notes 5 years ago, with terms given in the following table: a. Why is the price range greater for the 9% coupon bond than the floating-rate...
-
LOC Container Corporation is preparing financial statements for the fiscal year ended April 30, 1999. Because all of LOC Container's shares are traded within state, the company does not file reports...
-
Peabody & Peabody has 2012 sales of $10 million. It wishes to analyze expected performance and financing needs for 20142 years ahead. Given the following information, respond to parts a and b. (1)...
-
Use the Gauss-Jordan reduction to solve the following linear system: x1 3x1 -2x1 - x2 + 2x3 = - 27 4x2 + 8x3 = + 0x3 = -2
-
LMN Corporation, a real estate company, is planning to pay a dividend of $0.50 per share. Most of the investors in LMN are other corporations that pay 40% of their ordinary income and 28% of their...
-
Open the Magazine Solution (Magazine Solution.sln) file contained in the VB2015\Chap13\Magazine Solution-Introductory folder. The application is connected to the Magazines database, which is stored...
-
Open the Playhouse Solution (Playhouse Solution.sln) file contained in the VB2015\Chap13\Playhouse Solution folder. Connect the application to a Microsoft Access database named Play. The database is...
-
If necessary, create a new project named Advanced28 Project and save it in the Cpp8\Chap11 folder. Also create a new source file named Advanced28.cpp. The program should declare a 20-element,...
-
List the problems inherent in the use, by others, of spreadsheet models developed by users who are not trained in the procedural controls of system design and development.
-
What is the present value of $1,000 to be received five years from now if the interest rate is 12% compounded a. annually? b. semiannually? c. quarterly? d. monthly?
-
How can data be centralized in a distributed data processing system?
-
What is the future value of $1,000 to be invested now for five years if the interest rate is 12% compounded a. annually? b. semiannually? c. quarterly? d. monthly?
-
What are the three types of yield curve changes? How are these changes related with one another?
-
Jones, a chartered accountant, has completed the audit of Sarack Timber Supply Company Ltd and has issued a standard unqualified report. In addition to a report on the overall financial statements,...
-
Why is homeostasis defined as the "relative constancy of the internal environments? Does negative feedback or positive feedback tend to promote homeostasis?
-
An AP in a wireless network plays the same role as a link-layer switch in a wired network. However, a link-layer switch has no MAC address, but an AP normally needs a MAC address. Explain the reason.
-
In Figure 15.25 (previous problem), assume that the host with IP address 24.12.10.3 needs to send an IP datagram to the host with IP address 128.41.23.12 somewhere in the world (not shown in the...
-
What is the reason that Bluetooth is normally called a wireless personal area network (WPAN) instead of a wireless local area network (WLAN)?
-
The risk free rate is 2% and the market rate of return is 6%. The stock has a beta value of 1.5. What is the expected return on the stock. Is the stock overpriced?
-
It is year end, and RSG Investment Bank's stock is currently selling at $41.00 per share, just after paying out its annual dividend. The risk-free rate is 1.7% and the expected market return is 7%....
-
Sweet Muffins sells its muffins to restaurants and coffee houses for an average selling price of $33 per case. The following information relates to the budget for Sweet Muffins for this year (all...
Study smarter with the SolutionInn App