Using access to realize the scientific management of school timetable

The Teaching department manages the whole school curriculum Schedule The method is very simple, uses a big wooden sign which hangs on the wall to carry on the management, I thought that it has many shortcomings, first of all, to the management, uses is very inconvenient; second, it is even more troublesome to have a class teacher or a replacement schedule. In order to improve the management level of school affairs, the author uses Access database software to provide the powerful function and realizes the effective management of the curriculum.

Building a Database

1, select the File menu "new" command, in the pop-up "new" dialog box, select the "Common" tab in the "Empty Database", click the [OK] button.

2, in the next dialog box to enter the database name "school Management", press [OK], that is, enter the Database object window.

Create a table structure

1, "The general timetable" of the establishment

(1) Click the New button in the Table object, bring up the New Table dialog box, select Design view, and click OK to enter the table structure Design view window.

(2) In the Field Name column, enter the field name: Class, section, week, course, teacher, the corresponding data type is: text, numbers, text, text, text, ("PRIMARY keyword" can not).

(3) Close and save the table design, the table name is "Total Schedule" (Figure 1).

2, add the record

(1) Open the "master schedule" and enter data into the table.

(2) Save the data file as shown in Figure 2.

Create a crosstab query

Now we need to look at the class curriculum and the substitute teacher for the corresponding course, which can be used for the crosstab query.

1, open the New Query window, select the Crosstab Wizard, and click OK.

2. In the Pop-up Crosstab Query Wizard dialog box, select the Form button, select the "Total Schedule" you just created in the list, and click the Next button.

3. In the next dialog box, select the Class, section field in the Available Fields list, and add to selected field as the row heading for the crosstab table.

4. Click Next, and in the column Heading selection dialog box, select the Week field as the column heading, and then click the Next button.

5. After the row headings and column headings are established, the data at the intersection should naturally be the corresponding section of the day, so in the next dialog box, select the Course field and select first item in the functions list as the cross value of the row heading and the column heading.

6, click the Next button, enter the query name "class Schedule" in the dialog box that appears, and click [Finish] (Figure 3).

7, the same, "teacher substitute table" Repeat 1~4 step, the 5th step of the "course" field into the "Teacher" field can be.

Create a form

1, open the New Form dialog box, select the Pivot Wizard and the total schedule, and click OK to enter the PivotChart wizard window.

2, click the Next button and in the Available fields list, add the class, section, week, course, teacher field to the list on the right, and click Next.

3, and then, in the PivotTable Wizard dialog box that continues to pop up, drag the class, section field bar on the right side to the row area of the table layout diagram, drag the week field bar to the column area of the table layout diagram, and drag the course, teacher Field bar to the data area of the table layout diagram.

4, click Next, then click Finish, and finally, save the form, called the timetable form (Figure 4).

Finally, talk about the function and usage of the timetable form, first of all, we can easily view the "class schedule", "Teacher's list" and "a teacher's weekly substitute table", or "a class of one week distribution table" and so on, here just a few examples, Readers can also view them according to their own needs. Second, we look at how the form is used, and there is a Drop-down button on the right side of each field in the form. Lists all the values of the field, we can select the value we want to generate a different lists, plus a minus sign next to each record in the row or column area to show or hide the contents of the next level of records. You can also view different lists using it.