Tips

To define what information should appear in the report, and in what format it should be, the same controls can be used as in a form although some controls for example the command buttons are more appropriate for a form.

It is the design view that allows us to define the report, here we indicate to Access how it should present the source data of the report, and here the controls serve us in much the same way as when we design a form.

See tip link for description.

Reports are generally used to present the data of a table or query in order to print them. The basic difference with reports is that the data can only be visualized or printed (it can not be edited) and the information can be grouped and totals extracted by group more easily.

To select a control just click on it. When a control is selected it appears enclosed in some boxes, we call these boxes movement controllers (the bigger) and size controllers (the smaller) as we can see in the image below.

To define how the information within a form will appear, and in what format it will be, we use controls. A control is nothing more than an object that shows data, performs actions, and/or is used as decoration. E.g, we can use a text box to show data, a command button to open a form or report, or a line or a rectangle to separate or group controls in order to make them more legible.

To edit the data of a table using a form, we need to open the form by positioning ourselves in the Database window with the Forms object selected and click....

Forms generally serve to define screens with which to edit the records of a table or query.

Delete queries are queries that remove records from a table.

Append queries are those queries that add whole rows to a table.