Create a Table named Employee and an Update Query (This project is same as Project-13).

Table name: EMPLOYEE

B. Create a Form by using the Design view option and add the header, footer, command buttons (e.g. Add, Save, Delete, Run Query).
Steps: To create the Form, the following steps are required:
... Go to the New option of the Form (under objects) and open the Design view option
... Select the particular Table and click the Ok button
... Drag the fields on the Form
... Right click on the blank portion of the Form and select the ‘Form Header/Footer’ option
... Go to Toolbox and click the label (Aa) option
... Insert the label in both header and footer option on the Form and write the text
... To add command buttons, go to the Toolbox
... Click on command button (at first make the ‘Control Wizard’ active)
... Drag the command buttons on the Form
... Select the categories (Record navigation or Record operations)
... Select the actions (e.g. Save, Delete, Run query, Add etc)
... Next
... Select the button character (e.g. Text or Picture)
... Next
... Finish
... Go to the File menu
... Select the Save option to save the Form with a particular name
Form name: EMPLOYEE

Project-20: A. Create a Table named Student (This project is same as Project-15).

Table name: STUDENT

B. Create a Report by using the AutoReport: Tabular option.
Steps: The following steps are required to create an AutoReport-Tabular:
... Go to the New option of the Report (under objects)
... Open the AutoReport-Tabular option and select the particular Table
... Ok
... Go to the File menu and select the Save option to save the Report with a particular name
... Ok

Report name: STUDENT

C. Create a Report by using the AutoReport: Columnar option.
Steps: To create an AutoReport: Columnar by using the Student Table, we require some steps as follows:
... Go to the Report (under objects) and open the AutoReport: Columnar option from the New option
... Select the particular Table and click the Ok button
... Go to the File menu, select the Save option to save the Report with a particular name
... Click the Ok button

Report name: STUDENT