three ways in which these queries may be created in Access: Wizard, Design View and SQL View method. . Designing Reports in Access : A report in Access may be designed in three ways: Auto Report, Wizard and Design View method. A SQL statement (or query) is capable of displaying records containing fields from across a number of data tables.
A typical report in Access has the structure that consists of Report header, Page header, Group header, Details, Group footer, Page footer and Report footer. Questions for Practice Short Answers . State what do you understand by accounting reports. .
What do you mean by programmed or casual reports? . With the help of an example, briefly state the meaning of parameter queries. .
Briefly state the purpose of functions in SQL environment. . Briefly explain in steps the method of creating a query, using wizard. .
List the structure of a good report created in Access. . List the ways to refine the design of a report. .
Briefly explain the purpose of grouping and sorting of the data as a means to refine a report. . What do you understand by saving a report as snapshot? .
State the procedure for creating ledger in MS Access. Long Answers . Describe and discuss the procedure of creating the receipts side of a cash book. .
Discuss the concept of accounting reports? Explain the three steps involved in creating such reports. . Discuss with a set of inter-related data tables, the basics of creating queries in MS Access?
. Briefly explain the set of SQL statements to produce the receipts side of a cash book for Model-I. . Describe in steps the design view method to create a query in MS Access?
. Discuss the SQL view method of creating a query? . Describe the ways to refine the design of a report.
. Explain the data base design for Model-I for producing the receipts the series of SQL statements for producing the payment side of cash book for Model-II. . Describe the series of SQL statements to produce