Microsoft access tutorial 6

Unit 11. Forms (I)

Forms generally serve to define screens with which to edit the records of a table or query. In this unit we will see how to create a form, and how to operate it for the editing of records and changing its design.

Introduction.

To create a form we need to position ourselves in the database window with the Form object selected, if we then click on the button a window opens with the various ways we have to create a form: Design view opens a blank form in design view, and we then need to incorporate the various object that we would like to appear in it. This method is not used much as it is easier and faster to create an autoform, or to use the wizard and afterward modify the design of the created form to adjust it to our needs. We will see ahead in this unit how to modify the form design. Form wizard uses an a wizard that guides us step by step in the creation of the form. Autoform consists of automatically creating a new form that contains all the data from the source table. According to the type of form that we select (columnar, tabular,...) the form will present the data in a distinct way, when we click on one of the options, a sample will appear on the left side with the way in which the data will be presented with this option. E.g Autoform: columnar presents one record on a screen, meanwhile Autoform: tabular presents all the records on one screen and every record in a row. In order to use this function we first need to fill out the Choose the table or query where the object's data comes from: with the name of the source. This will be the only data to introduce, and once introduced we select the kind of autoform and click on OK button, and Access does the rest. Chart Wizard uses a wizard that guides us step by step in the creation of a graphic. Pivot table wizard uses a wizard that guides us step by step in the creation of dynamic table. We will next explain how to create a form using the wizard.

The Form's wizard

To start the wizard we can do it as describe in the last point, or a faster way would be from the Database window with the Forms object selected, by double clicking on the Create form using wizard option.

The first window of the wizard appears: In this window we are asked to introduce the fields to include in the form. Firstly we select from the Table/Queries box the table or query that we are going to get the data from, this will be the form source. If we want to extract data from various tables it would be better to first create a query to obtain this data and then select this query as the form source. Next we will select the fields to include in the form by clicking on the field and then the button or simply double click on the field. If we selected the wrong field click on the button and the field will be removed from ther selected fields list. We can select all the fields at the same time by clicking on the button or deselect all the fields at once using the button . Next we click on the Next> button and the window seen in the following example will appear...

In this screen we select the data distribution within the form. By selecting a format it will appear on the left side the way it will be seen in the form.

Once we have selected the distribution of our choice click Next and the following window will appear: In this screen we select the forms style, we can select between the various defined styles that Access has. By selecting a style it will appear on the left side as it will in the form. Once we have selected a style of our choice we click on the Next button and the last screen of the forms wizard will appear.

In this window we are asked for the title of the form, this title will also be the name assigned to the form.

Before clicking on the Finish button we can choose between:

Open the form to view or enter information, in this case we will see th result of the form ready for the editing of data, e.g:

or,

Modify the form's design, if we select this option the Form design view will appear where we can modify the aspect of the form, e.g:

Unit 12. Reports (I)

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. In this unit we will learn how to create a report using the wizard, and how to change its design once created.

Introduction

To create a form we need to position ourselves in the Database window with the Reports object selected, if we click on the button a dialog box will open with the different types of reports that we can create. Design view opens a blank report in design view and we then need to incorporate the different controls that we want to appear within it. This method is not usually used as it is both easier and more comfortable to create an autoreport or to create a report using the wizard, and afterwards to edit the design of the report to suit our particular needs. Ahead in this unit we will see how to edit the reports design. The Report wizard uses a wizard to guide us step by step through the creation of the report. Autoreport consists of automatically creating a new report that contains all the data of the source table or query. The data will be presented differently depending on the type of report chosen, and when we click on one of the options a model will appear on the left. E.g Autoreport: columnar presents each record on one page while Autoreport: tabular presents various records on the same page with a record in each row. We saw these layouts with forms in unit 11. In order to be able to use this option we first need to fill in the Choose the table or query where the object's data comes from: box with the name of the report's source. This will be the only data that we need to introduce, and once it has been introduced we select the type of autoreport and click on the OK button, Access will do the rest. The Chart wizard uses an assistant that guides us step by step through the creation of a graphic. The Label wizard uses an assistant that guides us step by step through the creation of labels. Next we will explain how to create a report using the wizard.

The Report wizard

To start the wizard we can use the method explained in the previous point or a faster and easier method would be from the Database window with the Reports object selected to double click on the Create report by using wizard option.

The wizard's first window will appear: In this window we are asked to introduce the fields to be included in the report. Firstly we select the table or query from the Tables/Queries box where it should extract the data from, this will be the report source. If we want to extract data from various fields it would be best to create a query to obtain the data and then to use this query as the source of the report. Next we select the fields by clicking on the field and then on the button, or simply double clicking on the field. If we make a mistake we click on the button and the field will be removed from the list of selected fields. We can select all the fields at the same time by clicking on the button, or deselect all at the same time by clicking on the button. Click on the Next> button and the next window will appear...

In this screen we select the grouping levels within the report. We can group the reports by way of various concepts, and with each concept add a group header and a footer, and in the group footer we will normally see the group total.

To add a grouping level click on the field by which we want to goup and click on the button (or double clic directly on the field).

A diagram will appear to the right indicating the structure that our report will take on, and in the central zone the fields that are seen for every record will appear. In our example a group by city will appear at the top and a group by postal code will appear at the bottom.

To remove a grouping level click on the header corresponding the group and click on the button.

If we want to change the order of the defined groups we use the button, the upward arrow will move us up a group, and the downward arrow will move us down a group.

With the button we can refine the grouping. click on this button and the following screen will appear.

The different groups that we have defined will appear in this box, and for every group that we have the field that defines the group in Group-level fields:, and in the drop down list of the Grouping intervals: we can indicate whether it should use the complete value contained in the field to group, or use the first letter, the first two letters, etc... After clicking on the OK button we return to the previous screen.