II. Query to retrieve selected columns of data records from a table, subject

II. Query to retrieve selected columns of data records from a table, subject to a condition. ( ) To Retrieve vouchers with Vno, Vdate, AuthBy columns wherein the vouchers are dated “ /Apr/ ” ( Model-I and Model-II ) Vno , Vdate , AuthBy vouchers Vdate = # #; ( ) To retrieve vouchers with Vno, Vdate, columns, which are dated “ /Apr/ ”. The columns of records retrieved by the query are to be renamed as Voucher, Date and Employee ( Model-I and Model-II ) Vno As Voucher , Vdate As Date , As Employee vouchers Vdate = # #;