National Computer Level 2 ACCESS sprint questions (3)

Source: Internet
Author: User
After NextJNextI executes the preceding statement, the value of K is ______. A.8B. 10C. 14D. 21 (33) VBA data type symbol "%" indicates the Data Type ______. A. Integer B. long integer C. single precision type D. Double Precision type (34) function Mid (123456789,3, 4) returns the value ______. A.123B. 1234C. 3456D. 456

After executing the preceding statement, the value of K is ______. A.8 B .10 C.14 D.21 (33) the VBA data type symbol "%" indicates the Data Type ______. A. Integer B. long integer C. single precision type D. Double Precision type (34) function Mid ("123456789",) returns the value ______. A.123 B .1234 C.3456 D.456

Next J

Next I

After the preceding statement is executed, the value of K is ______.

A.8

B .10

C.14

D.21

(33) "%" indicates the Data Type ______.

A. Integer

B. Long Integer type

C. single precision type

D. Double Precision type

(34) The value returned by the Mid ("123456789",) function is ______.

A.123

B .1234

C.3456

D.456

(35) after running the following program code, the value of variable J is ______.

Private Sub Fun ()

Dim J as Integer

J = 10

DO

J = J + 3

Loop While J <19

End Sub

A.10

B .13

C.19

D.21

2. Fill in blank questions (2 points for each blank question, 30 points in total)

Write the correct answer for each blank answer in the answer sheet [1 ]~ [15] The question is not scored on the exam.

(1) the number of storage units required to implement the algorithm and the workload of the algorithm are called [1] of the algorithm ].

(2) the data structure includes the logical structure of the data, [2] of the data, and Operation operations on the data.

(3) A class can inherit all attributes and methods from the direct or indirect ancestor. This method improves software [3 ].

(4) In an object-oriented model, the most basic concepts are objects and [4 ].

(5) software maintenance activities include corrective maintenance, adaptive maintenance, [5] maintenance and preventive maintenance.

(6) SQL (Structured Query Language) is a widely used database query language in the database system, it includes four functions: Data Definition, data query, [6], and [7.

(7) the maximum size of a text field is [8] characters.

(8) The data source that uses the query wizard to create a cross tabulation query must come from [9] tables or queries.

(9) computing controls use [10] as the data source.

(10) [11] A report is also called a form report.

(11) [12] The function returns the current system date and time.

(12) run the following program. The output result (value of str2) is [13 ].

Dim str1, str2 As String

Dim I As Integer

Str1 = "abcdef"

For I = 1 To Len (str1) Step 2

Str2 = UCase (Mid (str1, I, 1) + str2

Next

MsgBox str2

(13) run the following program. The value of k in the running result is [14], and the number of executions in the innermost layer of the loop body is

[15 ].

Dim I, j, k As Integer

I = 1

Do

For j = 1 To I Step 2

K = k + j

Next

I = I + 2

Loop Until I> 8

Answers to the second-level Access simulated exam for the National Computer Rank Examination

I. multiple choice questions

(1) C

Knowledge Point: basic concepts of Algorithms

Evaluation: A computer algorithm is an accurate and complete description of a solution. It has the following basic features: feasibility, certainty, poverty, and sufficient intelligence.

(2) C

Knowledge point: the concept of linear table

Comment: Both stack and queue are special linear tables with limited operations. They can be inserted and deleted only at the endpoint. The difference between the two is that the stack only allows insert or delete operations at one end of the table, which is a linear table with "post-import, first-out", while the queue only allows insert operations at one end of the table, the deletion operation on the other end is a linear table named "first-in-first-out.

(3)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.