1. Question:What is the advantage of Report Wizard over an Auto Report? 

    Answer
    It takes a little more work to create a report with the report wizard than with the Auto Report but you have a lot more control over what the final result looks like. This is an advantage of Report Wizard over an Auto Report.

    1. Report
  2. Question:Why Report Design View is important? 

    Answer
    Report Design View is where reports can be designed from scratch. It is where you can give your personal touches to the Form or Report Design.

    1. Report
  3. Question:What is the use of Label Wizard? 

    Answer
    The label wizard creates report designs that can be used to print custom or built-in labels.

    1. Report
  4. Question:What are the different auto reports available in Access? 

    Answer
    - Columnar AutoReport: creates a report
    where each row is presented vertically.
    - Tabular AutoReport: creates a report
    where data is presented in table form.
    - Label Report: creates a mailing list.
    - Chart Report: creates a chart report.
    - Design View: helps us to create a report
    based on user requirement.

    1. Report
  5. Question:What are the different sections of a report? 

    Answer
    A report is divided into many sections:
    
    The Report header: In this section you
    place a control which must appear only
    at the beginning of the report.
    - The Page header: In this section you
    place a control which should appear at
    the beginning of every page.
    - The detail band: It is the heart of the
    report. Here you place controls that must
    appear once for every record.
    - The Page footer: In this section you place
    a control, which must appear at the foot
    of every page.
    - The report footer: In this section you
    place a control which must appear at the
    bottom of the report.

    1. Report
  6. Question:What are some of the database object operations that a user must know? 

    Answer
    Some of the database objects operation that a user must know is How to delete objects, copy objects, and rename objects if necessary.

    1. Report
  7. Question:What is a macro? 

    Answer
    A macro is a set of instructions, which can be executed repeatedly. it is useful for automating certain routine tasks like printing reports etc. The macro once created can be executed from buttons or any other controls.

    1. Report
  8. Question:What is the difference between Print Preview and Layout Preview? 

    Answer
    A report may be seen in two ways: Print Preview and Layout Preview. When a report is viewed in Print preview, it appears almost exactly as it would as when printed. MS-Access does the entire necessary math for calculated and summary fields. In contrast if you view the report in layout view, Access does not do all the calculations. Hence this is a quick way to check your work as you design the repot.

    1. Report
  9. Question:What are command buttons? How to use command buttons? 

    Answer
    Command buttons are referred to as controls. The control is capable of executing a set of instruction when the user clicks on it. In order to create and use command buttons select View > Toolbox. In the ToolBox select the command button and place it on the form by clicking and dragging. The command button wizard is started which allows you to specify the event.

    1. Report
Copyright © 2024. Powered by Intellect Software Ltd