Open access queries new design view in the show table

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: gging and dropping them onto the fields in the Query Box. • Select the required fields from the second table also and run the query. Query-4 Profile of List of Payments (LOP) and Cash Accounts (CAC) treasury-wise • • • • • • • • • • Open Access → Queries → New → Design View In the Show Table box, select BUNDL_SM and press Add. Close the Show Table box Click the Query Type icon and select Crosstab Query Drag and drop TR_CD, LOP_CAC, G_PAYMT on to the Query panel Press the Summing Function icon (∑) Select Group By under TR_CD and LOP_CAC Select Sum under G_PAYMT In the Query Panel, in TR_CD field select Row Heading under Crosstab In the Query Panel, in LOP_CAC field select Column Heading under Crosstab • In G_PAYMT, select Value under Crosstab • Run the Query Query-5 Profile of List of Payments (LOP) and Cash Accounts (CAC) for the whole year. • Open Access → Queries → New → Design View • In the Show Table box, select BUNDL_SM and press Add →Close. • Drag and drop LOP_CAC, G_PAYMT from BUNDL_SM on to the Query panel • Press the Summing Function icon (∑) IT Audit Manual Volume III 111 IT Audit Manual • Select Group By under LOP_CAC • Select Sum under G_PAYMT • Run the Query These were only a few samples of the basic type of queries that can be run using MS Access. Numerous queries can be run to view, change and analyse data using different parameters as well as use them for forms, reports and data access pages. The results of these queries can also be exported to MS Excel to produce graphs and charts to be included in audit reports. IT Audit Manual Volume III 112 IT Audit Manual Bibliography ________________________________________________ • Information Systems Audit and Control Association Standards and Guidelines • INTOSAI IT Audit Courseware, 2001 • National Audit Office,...
View Full Document

Ask a homework question - tutors are online