Briefly explain in steps the method of creating a query, using wi…

Question

Briefly explain in steps the method of creating a query, using wizard.

✓

Answer

The following are the steps involved in creating a query using the wizard method.

In the Database window, select ‘Queries’ from Object list given on the Left Hand Side (LHS) of the Database window.
Double click at ‘Create Query’ by using wizard given on the Right Hand Side (RHS) of the window. With this ‘Simple Query Wizard’ will be shown on the screen. Now, the user is required to select a field name from a table or from an existing query which should be included in the query being created.
Click ‘Next’ after the desired fields have been selected. In case, a number or currency field is included in the selected field, the user is asked to choose an option button to specify whether the query to be created is a summary or detail query.
Click ‘Next’ after the desired fields have been selected. In case, a number or currency field is included in the selected field, the user is asked to choose an option button to specify whether the query to be created is a summary or detail query.

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

		₹
(i)	Bank overdraft as per Pass Book.	33,000
(ii)	Cheques issued but not presented for payment.	17,500
(iii)	Cheques deposited but not collected.	21,000
(iv)	Cheques recorded in the Cash Book but not sent to the bank for collection.	4,000
(v)	Payment received from customers directly by the bank.	7,000
(vi)	Bank charges debited in the Pass Book.	40
(vii)	Premium of Life Insurance Policy of Mr. D.H. paid by the bank on standing instructions.	360
(viii)	A bill for ₹ 6,000 dishonoured on 30th March, 2019 and bank paid Noting charges ₹ 20. This bill was discounted on 30th January, 2019.

Depreciate Land and Building at 2.5% and Motor Vehicles at 20%.
Interest on Loan at 15% p.a. is unpaid for six months.
Ghanshyam Das withdrew ₹ 2,000 for his private use. This amount was included in general expenses.
Interest on Investments is receivable for full year @ 10%.
Provide for Manager's Commission at 10% on Net Profit after charging such commission.
Stock in hand on 31st March, 2017 was valued at ₹ 25,000 (Realisable value ₹ 22,000).

To provision for doubtful debts is to be maintained at 5 per cent on sundry debtors.
Wages amounting to ₹ 500 and salary amounting to ₹ 350 are outstanding.
Factory rent prepaid ₹ 100.
Depreciation charged on Plant and Machinery @ 5% and Building @ 10%.
Outstanding insurance ₹100.