Designing objective papers with access (2)

access| Design Section Tip: In the last section, we mainly introduce the methods and steps of building test database, question table, answer table and entering data into two tables in Access.

In this section, we mainly introduce methods for establishing associations and queries.

Establish an association

The question table is associated with the answer form by the title number, in order to make the same record in two tables corresponding to the exact contents of the same question and to prepare for the establishment of the query. You can create an association by clicking the Relationships option under the Tools menu, and then clicking the Show Table option under the Relationships menu to open the window shown in Figure 1. In the Figure 1 window, click Answer table, and then click Add. Click Question Table, click Add, display all two tables, and then click the Close button. In the two tables shown, drag the title in the answer table to the question number field in the question table, and in the Edit Relationship dialog box that pops up, click Create, so that the two tables are already associated.

　　

Figure 1

Create a query

The purpose of establishing the query is to prepare data for the form and to fill in the answer table with the score of each question according to the candidate's answer. There are four query objects, which are summarized as follows:

1, select the query

The role is to select the selected questions, for the selection of the window for data preparation. The build process and include fields are as follows: In the Figure 2 window, click the Query option under Objects, click the New button, and in the new query window that opens, click OK (using the default options: Design view) to open the Figure 1 Show Table dialog box with the question table and answer table added to the new query window , as shown in Figure 3. Drag the question number, topic, 1, 2, 3, 46 fields in the table below to the right of the cells in the table below, and then drag the "candidate answers" in the answer table to the rightmost cell. In the "Criteria" box below the title Number column, fill in the "<6" (because the top 5 is titled multiple-choice) in this question table example. Finally, save this query with the query name "SELECT query."

　　

Figure 2

2. Judgment Inquiry

Using the same method to establish a judgment query, the difference with the establishment of a select query is: Do not include 3, 4 fields in the question table, in the title "Criteria" Input ">5" (because this question table in the example, after 3 is entitled to judge), and finally save this query, the query name is "judgment query."

3, fill in each question score query

The establishment process is similar to the above method, but the difference is as follows: In Figure 3 window state, click the Query menu, select Update Query from, and then add the update to row in query Design view. In this update query, we only drag the score field in the answer table to the cell to the right of the field. Enter "2" in the cell to the right of "Update to" (2 points per question), and in the Criteria cell below, enter [Answer table]! [Answer]=[answer table]! [Candidate answer] "(inside the punctuation mark is the English punctuation mark), namely only examinee chooses the answer and the question answer is same, only then updates the score the value is 2 points. The detailed results shown in Figure 4, finally saved, named "Scoring query."

　　

Figure 3

4, total total score inquiries

The establishment process is similar to establishing a "scoring query" and includes only the "Score" field, however, when you create a query, you need to click Totals on the View menu, add a row of total items to query Design view, and fill in sum in the total cell below the score field (the Sum function). Finally, save as "total Score".

　　

Figure 4

Next section Notice: In the next section, we will introduce a user-friendly Man-machine interface window method, hope interested friends concerned.