The new application of Access in officeXP to the Office of Academic Affairs of our school to manage the curriculum is very simple, using a big wooden sign hanging on the wall for management, I think it has many shortcomings, first, it is inconvenient for managers to use it. Second, it is more difficult to adjust or change the curriculum for substitute teachers. To Promote Colleges and Universities
The new application of Access in office XP the academic affairs office of our school manages the curriculum of the whole school in a very simple way, using a big wooden sign hanging on the wall for management, I think it has many shortcomings, first of all, it is inconvenient for administrators to use it. Second, it is more difficult to adjust or change the curriculum for substitute teachers. To Promote Colleges and Universities
New Application of Access in office XP
ManagementSchool
Course scheduleThe method is very simple. Use a big wooden sign hanging on the wall.
Management, I think it has many disadvantages. First
ManagementIt is inconvenient to use. Secondly, if you want to adjust or change the course for the substitute teacher
Course scheduleIt is more troublesome. To improve school affairs
ManagementLevel, the powerful functions provided by the author using Access database software,
ImplementationNow
Schools
Course scheduleValid
Management.
Create a database1. Select the "new" command in the File menu, select "Empty Database" on the "common" tab in the "new" dialog box, and click the [OK] button. 2. In the following dialog box, enter the database name"
Schools
ManagementClick [OK] to enter the Database Object window.
Create Table Structure1. "Total
Course schedule(1) Click [new] in the "table" object to bring up the "new table" dialog box and select "design view ", click [OK] to enter the table structure design View window. (2) In the field name column, enter the field name: Class, section, week, course, and instructor. The corresponding data types are text, numbers, text, text, and text, (The "primary keyword" can not be used ). Implementation
Schools
Course scheduleOf
Science
Management() Src = "http://cdn.verydemo.com/upload/2013_06_08/13706259254170.jpg" border = 0> (3) Close and save the table design. The table name is "Total ".
Course schedule"(1 ). 2. Add record (1) Open "Total
Course schedule", Input data to the table. Implementation
Schools
Course scheduleOf
Science
Management() Src = "http://cdn.verydemo.com/upload/2013_06_08/13706259254331.jpg" border = 0> (2) Save the data file, as shown in figure 2.
Create a cross tabulation QueryNow we need to view
Course scheduleAnd the substitute instructor of the corresponding course. This problem can be queried using a cross tabulation. 1. Open the new query window, select the cross tabulation wizard, and click [OK]. 2. In the pop-up "cross tabulation query wizard" dialog box, select the "form" button and select the "Total"
Course scheduleClick [next. 3. In the following dialog box, select the "class" and "section" fields in the "available fields" list and add them to the "selected fields" as the row title of the crosstab chart. 4. Click [next]. In the column title selection dialog box, select the "Week" field as the column title, and click [next. 5. After the row title and column title are established, the data at the intersection of the two should naturally be the corresponding course of the day. Therefore, in the following dialog box, select the "Course" field, select "first item" in the "function" list as the crossover value between the row title and column title. 6. Click [next] and enter the query name "class" in the displayed dialog box.
Course scheduleClick [finish] (3 ). 7. Similarly, the "instructor assignment form" is repeated in 1 ~ In step 4, change the "Course" field to the "instructor" field.
Create a form1. Open the "New Form" dialog box and select "data perspective wizard" and "Total
Course schedule", Click [OK] to enter the" data perspective wizard window ". 2. Click [next, in the "available fields" list, add the "class", "section", "Week", "course", and "instructor" fields to the list on the right, and click [next]. 3. In the "PivotTable wizard" dialog box that appears, drag the "class" and "section" fields on the right to the row area of the table layout chart, drag the "Week" field to the column area of the table layout chart, and drag the "Course" and "instructor" fields to the data area of the table layout chart. Implementation
Schools
Course scheduleOf
Science
Management() Src = "http://cdn.verydemo.com/upload/2013_06_08/13706259254482.jpg" border = 0> 4. Click [next], click [finish], and save the form named"
Course scheduleForm (4 ). Finally, let's talk about"
Course scheduleFirst, we can use this form to conveniently view the "Class
Course schedule"," Instructor Substitute table "," one-week substitute table for a teacher ", or" one-week distribution table for a course in a class ". Here are only a few typical examples, you can also view the information as needed. Next, let's take a look at how to use the form. There is a drop-down button on the right side of each field in the form to list all the values of this field. We can select the desired value, to generate different table volumes. In addition, the addition and subtraction numbers next to each record in the row or column area show or hide the content of the next-level record. You can also use this to view different table volumes. Author:
