2. Operation. Record the commands and capture the screens of the main steps & results (refer to the report example word file for the detailed format & requirements).

(1) There is a one-dimensional array, called A with the elements of [7, 3, 6, 8, 2, 5]. Use VFP to store the values to the elements, and sort A with the result of [2, 3, 5, 6, 7, 8].

Answer：

Step 1: Command

Step 2: Capture the result

(2) How to generate a random integer number between 0 and 100? Write the expression.

Answer：

Step 1: Command

Step 2: Capture the result

(3) Supposing Monday ~ Friday are working days, and Saturday and Sunday are weekends. How to automatically judge the current day is a working day or a weekend day? Write the expression.

Answer：

Step 1： Command：

Step 2： Capture the result

(4) Pop up the following dialog box and judge what’s the button a user may click.

Answer：

Step 1： Command

Step 2： Capture the Answer：

(5) Table operation:

① Create the tables:

Table Name: Student
Field Name	Data Type	Width	Null
No	C
Name	C
Gender	C
Department	C
Hometown	C		√
Birthday	D		√

Table Name: Score
Field Name	Data Type	Width	Null
No	C
Course_No	C
Score	N(3, 1)

② Insert at least 5 records into each table

③ Field & record validation: set the range of score (0-100) in the score table. If a staff inputs a score value outside this range, the system will pop up an alert dialog box and reject the value, as follows:

Rule expression: score=> 0. AND. score< =100

Rule message: “Score must be within 0~100! ”

Result:

④ Set the display properties: Some Chinese people do not read English, so when displaying the records, show the field “No” to Chinese character “学号 ”, as follows:

Student No.: 学号 (PinYin)

l The field name is still “No”, as follows:

l But when displaying the records, the caption of “No” is changed to the Chinese characters:

⑤ Referential Integrity Setting: