Form and Report Creation in Ms-Access

Form Creation in Ms-Access
Form provides us to add, edit, or display the data stored in Ms-Access. Its purpose is to allow users to perform data entry. Data can be inserted, updated, or deleted from a table using a Form object.
Create the Form:
Form tab contains following options.

1. Form:
It allows us to create a Form that lets enter information for one record at a time.
1. Select the table in the left menu that you want to use for the form and click Create -->Form

2. The form displays all fields as label/field pairs. The label allows users to see which field is presented in an editable form element such as a text box, combo box, etc. The user can then edit the underlying data using the form elements.

Form Design:
It provides to create a new blank form in Design View. In this view you can make advanced design changes to form, such as adding custom controls.
1) Select Create option.
2) Select Form Design.
3) Now select Add Existing Fields.
4) After then field list box appears on right edge of the screen.
5) Click on plus symbol from field list to expand all field of the table or show all.

6) Now drag it and design layout.
7) Select design menu.
8) Click on logo and locate picture file.
9) To change the back ground press right mouse button on detail area.
10) Select fill back colour & select specific colour.
11) Select label to declare from heading.

12. To display form we use following steps-
Home tab -> view -> form view.

Add command button on form
1) Create form.
2) Design layout.
3) Select design view.
4) click on button.
5) Drag on form.
6) After then command button wizard box will appear.

7) Select record operations under categories.
8) Now select add new record under actions.
9) Click on next button, click on text review button.
10)Now click on next button .
11)Then click on finish button.
* Using above procedure we can add more button regarding from navigation.
� When we insert command button then command button wizard box appears which contains following categories.
1. Record Navigation: This category allows us to navigate(movement) records of table. It provides us to go next, previous, first, last record etc.
2. Record Operation: It allows us to operate record such as add, delete, save etc.
3. Form Operation: This category provides us to manipulate forma operation such as close, open, print form etc.
4. Application: It provides us to quit from the application.
5. Report Operation: It provides us to manipulate report such as display, print etc.
6. Miscellaneous: It allows us to assign user created macro or query in command button.
a: At first create query then select it during button creation.
Report Creation in Ms-Access
Reports allow us to organize and present our data in a user-friendly, visually appealing format. Access lets us create reports from both tables and queries. It is used for display record or print record according to own layout design.
Steps:
1. Select the Create tab on the Ribbon. Locate the Reports group, then click the Report Design

2. After then Report Design layout box will appear. Click on Logo option to insert desire logo and write label of report.
3. Now select Add Existing Fields.
4. After then field list box appears on right edge of the screen.
5. Click on plus symbol from field list to expand all field of the table or show all.
6. Now drag it, select and cut label and paste it on Page Header area.
7. Click on Date and Time option from ribbon and place it on page header.
8. Now select Total field and click on