How to use Access for class management

Teachers ' responsibilities and obligations have never been weakened by the change of the Times, and the particularity of education itself makes teachers become the communicators of knowledge and the shapers of human soul. As a teacher in charge of primary and secondary schools, the responsibility is much more practical and much more complicated. The complex student basic information needs to manage and report, the class daily affairs should be included in the class management log, the student's thought question needs to face individual solution, all these, often makes the class teacher to the other. How to effectively organize class management and make all the information orderly is a matter of great concern to the class teacher.

According to our understanding, the main problems faced by the class teacher in the daily work have the following points:

1. Students have a large amount of basic information, manual recording time-consuming and more difficult to update, information reuse when the volume of transcription;

2. The daily management of the class information statistics (such as: peacetime attendance, exercise, participation in collective activities, etc.) and the reuse of such information have difficulties;

3. Summary of students ' achievements, especially for their analysis and statistics more difficult, manual operation not only time-consuming, but also very error-prone;

4. The end of the semester for each student to write conduct comments.

Below, we will detail how to use the information technology to help the class teacher to release from the heavy class management work with two pages of content.

When the class teacher is very hard, each semester to sum up a large number of students information, work a busy, but also easy to make mistakes. If you turn to access 2008, you can not only reduce your burden, but also greatly improve your productivity. The following is the author of a little practical experience, I hope to help you teachers.

First, create a basic information form

Enter Access 2008, create a new empty database called Class management, and then use the Table Designer in the Table object, creating the following form in the database to accommodate students ' various information:

1. Basic Student Information sheet, table structure as follows:

Field Name: School Number name sex Birth date Photo parent name Home Address ZIP code

Field Properties: Text-type text-type short-Date OLE object text-type text type

Field Length: 6 10 2 No No 10 50 6

2. Course Code table, table structure as follows:

Field Name: Course Code Course Name

Field Properties: Text-type text

Field Length: 4 50

3. The Student performance table is structured as follows:

Field Name: School Number course ID score

Field Properties: Text-type numeric type

Field Length: 6 4 single precision, 1 decimal digits

Validation Rule none: none between 0~100

After the table structure design is complete, use the Relationships command to establish relationships between the tables for use when creating related queries.

Second, create a form

To return to the Database window, use the Form Design Wizard in the form object to create the following forms to establish a good user interface for entering various form data.

1. Student Basic information Input form

2. Course Code Information Input form

3. Student Score Input Form

The following is an example of the Student Profile information Entry form, which describes how the form is created.

Step one: In the Database window, in the Form object, double-click the Create Form with Wizard command, open the Form Wizard dialog box, and in the table/Query Drop-down list box, select the Student profile table (shown in Figure 1).

Step Two: Click the [〉〉] button, select all the fields as selected fields for the form (as shown in Figure 2), and then click Next.

Step three: In the "Make sure to use the style", select the form style you like. Continue clicking Next.

Fourth step: In the Specify caption for form text box, enter a name for the form. Finally, click Finish. This ends the creation process for this form.

Create additional forms using the above methods.

Third, create a query

Return to the Database window, and in its Objects column, click Query to switch to the query object to create the query. The goal is to get all the information you need from a data form.

To create a student information query for example, describe the query creation process:

First step: In the Database Query Object window, double-click Create query in Design view, open the Query Design view window, in the Show Table dialog box, select the related table you want, and then click the Add button.

The second step: as required by the query, drag the relevant field into the designer grid with the mouse, and enter the query parameter "Enter the number" in the criteria bar of the "Learn Number" field (see Figure 3).

Step three: Click the Save command to name the query in the Save dialog box that pops up, and end the query creation operation.

In this way, you can create queries that meet a variety of needs.

The class management database is basically created, and users can add forms, queries, or reports to suit their needs. In addition, you can add some calculated controls to the report to calculate the total score, ranking, and so on. How about, not bad! Teacher in charge may as well try.