Working with forms, Working with reports - Informatics...

Working with forms

Forms allow users to enter data into a table without directly accessing the tables themselves, and also provide the ability to display query results in the form of beautifully designed forms. There are two types of form structure formation: on the basis of the table and on the basis of the query, a combined approach is also possible.

Select the required table and click the Forms tab on the Create tab. A form will be created with fields for entering records (reading entries) in one column. There are several kinds of forms: in column & quot ;, tape, tabular, diagram. Autoform in the It displays all the fields of one record and is convenient for entering and editing data. The tape form displays a group of records at the same time - it is convenient to use it for processing the output of data. Table autoform does not differ in appearance from the table on which it is based.

AutoForm is based on only one object. To create forms from several tables or from queries, use other means. If a form is based only on one object, it is called a simple form. If the form is based on fields from several linked tables, then it is called complex and is a composition of several forms.

On the Create, tab in the Forms objects, click the Forms Wizard. Creating a form using the Form Wizard is implemented in several stages in the dialog mode with the developer. First, you select the fields of the tables that will appear in the form. Secondly, choose the appearance and style of design. Then the form is saved with a name.

The form has three main sections: the header area, the data area and the note area. The lines that separate the sections are dragged vertically with the mouse, which allows you to resize the partitions as needed.

Header sections and notes have a purely design purpose - their contents are not directly related to the table or query on which the form is based.

Working with reports

Reports are used to output data to printers and must conform to standard paper sizes. There are various design tools for creating reports.

The report is created using a query, displays on the screen and allows you to type:

• the data is in a convenient form;

• grouped records from different tables with condition selection;

• Calculated fields;

• graphical objects, graphs included in the report besides the text.

The automatic design tools are represented by the auto-reports that are launched on the Create tab with the Report command

The Report Designer is used to generate reports automatically. In its work, the base tables or queries are selected, then - the fields displayed in the report are selected, the grouping fields, fields and sorting methods are selected, and style.

The structure of the report differs from the structure of the form by the increased number of sections. In addition to header, note, and data sections, the report can contain header and footer sections for printing service information such as page numbers. If grouping is applied for some report fields, the number of sections of the report is increased, since the design of group headings is performed in separate sections.

Editing the report structure is done in the Designer mode. The editing methods used here are the same as for the forms. Control elements in the report perform purely design functions. An important feature of reports is the availability of a tool for inserting the current page number and the total number of pages into the header or footer area (using the Page Number Dialog Box).

thematic pictures

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)