Select trm and press add close the show table box

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: o tables are joined. Select number 2 from the box, whereby all the records from Bundl_SM table will be included and only those records from the MJH_M table where the joined field i.e. MJH_CD are the same. • Next, place the required fields from the table to the query. For this, hold down the required fields from the Bundl_SM table, drag and drop them onto the fields in the Query Box. Alternatively, you can also select the required fields from within the query area by pressing on the field. • Select the required fields from the second table also and run the query. Query – 2 Similarly we can validate Treasury Codes from BUNDL_SM against TR_M (Treasury Master) • Open Access → Queries → New → Design View • In the Show Table box, select BUNDL_SM and press Add. • Select TR_M and press Add. • Close the Show Table box • Click on TR_CD in Bundl_SM table and pull it over the TR_CD in TR_M table. You will see a link / join between the two tables on the field ‘TR_CD’ • Double click the link between the two tables. Select number 2 from the box, whereby all the records from Bundl_SM table will be included and only those records from the TR_M table where the joined field i.e. TR_CD are the same. • Next, place the required fields from the table to the query by dragging and dropping them onto the fields in the Query Box. • Select the required fields from the second table also and run the query. IT Audit Manual Volume III 110 IT Audit Manual Query-3 Validate DDO (DDO Code) from TA_15_SM (contains details of all vouchers and classification) against DDO_M (DDO Master). • Open Access → Queries → New → Design View • In the Show Table box, select TA_15_SM and press Add. • Select DDO_M and press Add. • Close the Show Table box • Click on DDO in TA_15_SM table and pull it over the DDO in DDO_M table. You will see a link / join between the two tables on the field ‘DDO’ • Double click the link between the two tables. Select number 2 from the box, whereby all the records from TA_15_SM table will be included and only those records from the DDO_M table where the joined field i.e. DDO are the same. • Next, place the required fields from the table to the query by dra...
View Full Document

This note was uploaded on 10/27/2013 for the course LAW 10-100 taught by Professor Parsons during the One '10 term at Bond College.

Ask a homework question - tutors are online