MS Access:

Introduction:

    Microsoft Access is a powerful program to create and manage the user data base. It is a relational Database Management System because it enables the user to create, organize, manage, and report from the data includes information consisting of student names, the class they belong to, the teachers teaching the particular subject etc. Access is used by small businesses, within department of large corporations, and hobby programmers to create adobe customized desktop systems for handling the creation and manipulation of data. Access is not designed for building full web or browser based systems. In the next section we will look at forms, reports and queries commonly used in MS Access.

Data base Objects: Forms

      Forms a graphical representation of a table for users, form are typically windows objects used to view and enter data in the data base. A form can combine data form multiple tables or queries. Forms are window interfaces that the users access to enter data in the data base. You can add, update, and delete records in your table by using form. Although a form can be named different form a table, they both still manipulate the same information and the same exact data. Hence, if you change a record in a form, it will be changed in the table also. A form is used when you have numerous fields in a table. This way you can see all the fields in one screen, whereas it you were in the table view (data sheet) you would have to keep scrolling to get the field you desire.

Creating a form Using Wizard

To create a form with the help of a wizard, follow these steps:

[1]In the data base widow click create form by using wizard option.

 Form the Tables/Queries drop-down menu, select the table or query whose data sheet the form need to modify. Select the field to be included on the form by highlighting each one in the available fields window and clicking the [>] button to move the fields to the selected fields window. To move all the fields click [> >] button. After selecting the field, click the Next > button to move to the next screen.

[2]On the second screen, select the layout of the form.

[3]Columnar- A single records is displayed at one time and labels and form fields are listed and form fields are listed across the screen.

[4]Tabular- Multiple records are listed on the page at a time with fields in columns and records in rows.

[5]Datasheet- Multiple records are displayed in datasheet view.

Click the Next [>] button to continue.

[6]Select a visual style for the form from the next set of options and click Next >.

[7]On the final screen, name the form in the space provided. Select “Open the form to view or enter information” to open the form in form view or “Modify the forms design” to open it in Design View. Click Finish to create the form.