Download App

Accounting System Using Database Management System — Account STD 11 Commerce — Question

CBSE BoardEnglish MediumSTD 11 CommerceAccountAccounting System Using Database Management System4 Marks
Question
With the help of an example, briefly state the meaning of parameter queries.
✓

Answer

A Parameter Query is a query where for selecting a set of records, the user is asked to enter parameters or criteria through an input box. A Parameter Query is useful when the same query is to be repeated with different criteria. In short, it implies the execution of same set of queries with different requirements.
For example, the same set of queries is required for different accounts code, while extracting the information to prepare ledger. Let us consider the given below SQL statement.
PARAMETERS Accounts Name Text (145)
SELECT Name
FROM Accounts
WHERE Code = AccountNo
In the above query, PARAMETERS clause is used to represent the variable AccountNo. This SQL statement requires the user to provide the different values of Account No.

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "4 Marks Question" from Accounting System Using Database Management System→Accounting System Using Database Management System — all question types→Account STD 11 Commerce question papers→CBSE Board STD 11 Commerce question papers→CBSE Board question paper generator→

Similar questions

Write Short Notes on:
Applications of Computers in Accounting.
→
From the following information, prepare Trading Account for the year ended $31^{\text {st }}$ March, $2019:$
Adjusted Purchases ₹ $6,60,000$; Sales ₹ $7,44,000$; Closing Stock ₹ $50,400$; Freight and Carriage Inwards ₹ $3,600$; Wages ₹ $6,000$; Freight and Cartage Outwards ₹ $2,000.$
→
The Trial Balance of M/s. Gupta & Sons shows a difference of $₹\ 52,200$. To prepare the Final Account on $31^{st}$ March, $2019,$ this difference is placed in a Suspense Account. Afterwards the following errors were disclosed. Pass the necessary entries to rectify them and show the Suspense Account.
  1. Purchases Book total had been undercasted by $₹\ 20,000.$
  2. A cheque received from Vasudev for $₹\ 7,800$ had been debited in the Cash Book but not posted in Vasudev’s Personal Account.
  3. Returns Outward Book had been overcasted by $₹\ 10,000.$
  4. Goods returned by Yash Pal worth $₹\ 15,000$ have been entered in Returns Outward Book. However, Yash Pal’s Account is correctly posted.
→
Write short notes on the following:
  1. Customised Accounting Software;
  2. Readymade Accounting Software.
→
Rectify the following errors:
  1. The total of one page of Sales Book was carried forward as ₹ 371 instead of ₹ 317.
  2. ₹ 540 received from Yatin was posted to the debit of his Account.
  3. Purchases Returns Book was overcast by ₹ 300.
  4. An item of ₹ 1,062 entered in Sales Return Book had been posted to the debit of customer who returned the goods.
  5. ₹ 1,500 paid for furniture purchased had been charged to ordinary Purchase Account.
→
The following transactions took place during the week ended 28th May, 2019. How will you record them in the Petty Cash Book which was maintained with a weekly 'float' of ₹ 3,000?
2019   ₹
May 23 Postage 400
May 24 Casual labour 500
May 24 Taxi hire 600
May 26 Note pads and registers 800
May 27 Cartage 200
May 28 ​Bus fare​ 300
→
Debtors in the beginning of the year were ​₹ 30,000, Sales on credit during the year were ₹ 75,000, Cash received from the Debtors during the year was ₹ 35,000, Returns Inward (regarding credit sales) were ₹ 5,000 and Bills Receivable drawn during the year were ₹ 25,000. Find the balance of Debtors at th end of the year, assuming that there were Bad Debts during the year of ₹ 2,000.
→
When you proceed to reconcile the Bank Account starting with 'Debit' Cash Book balance. how is the following dealt with and why?
  1. Cheques issued but not presented for payment.
  2. Cheques deposited but not yet credited.
  3. Bank charges charged by the bank not recorded in the Cash Book.
  4. Interest allowed by the bank not recorded in the Cash Book.
→
From the following information, prepare Trading Account for the year ended $31^{st}$ March, $2019$:
Adjusted Purchases ₹ $6,60,000$; Sales ₹ $7,44,000$; Closing Stock ₹ $50,400$; Freight and Carriage Inwards ₹ $3,600$; Wages ₹ $6,000$; Freight and Cartage Outwards ₹ $2,000$.
→
Ascertain Cost of Goods Sold from the following:
 
₹
Opening Stock
8,500
Purchases
30,700
Direct Expenses
4,800
Indirect Expenses
5,200
Closing Stock
9,000
→