Reports

MS Access provides a means of organizing and summarizing data with one of its tools, called reports. A report is a formal, presentable, printed document that lists data in a formatted manner. A report can be created in two ways - Creating Report with Report Wizard and Creating Report in Design View.

To format a report, go to format and click on Autoformat. The various report design accessories are the field list, the toolbox and the property sheet. The field list displays a list of items that are subject to the report we are building. The toolbox presents a list of some of the most common window controls. The property sheet displays properties associated with the object or the control that is selected on the report. While designing a report, one of the most usual actions that are performed is to insert items from Field List to the Report. To add a field, drag it from the Field List to the report to an appropriate section. To drag many fields at the same time, we need to first select them. To select all items at the same time, double click the title bar of the field list. Once a report is designed, the fields can be grouped and sorted. Sorting refers to the process of arranging records in ascending and descending order. Reports can also be used to print mailing labels.

To Access the full content, Please Purchase

  • Q1

    How do we print Mailing Labels?

    Marks:1
    Answer:

    Mailing Labels can be printed through reports.

    View Answer
  • Q2

    Why Group-On property is used in report?

    Marks:1
    Answer:

    We use Group-On property in report to specify how to group data in a field or expression by data type.

    View Answer
  • Q3

    How do we format report?

    Marks:1
    Answer:

    We format report by using Autoformat command.

    View Answer
  • Q4

    State the different ways of creating reports.

    Marks:1
    Answer:

    There are two different ways of creating reports –
    (1) Create report in Design view.
    (2) Create report by using wizard.

    View Answer
  • Q5

    What do you mean by report?

    Marks:1
    Answer:

    Report is the final presentation of the existing database in DBMS.

    View Answer