National Computer Level 2 ACCESS sprint question (2)

Which of the following SELECT statements are correct ______. A. SELECT * FROM student table WHERE name John B. SELECT * FROM student table WHERE name John C. SELECT * FROM student table WHERE name three D. SELECT * FROM student table WHERE name: Zhang San (17) which of the following does not belong to Operation query _____

Which of the following SELECT statements are correct ______. A. SELECT * FROM 'student table' WHERE name = 'zhang san' B. SELECT * FROM 'student table' WHERE name = John C. SELECT * FROM student table WHERE name = 'zhang san' D. SELECT * FROM student table WHERE name = Zhang San (17) which of the following does not belong to Operation query _____

D.C

(16) which of the following SELECT statements are correct ______.

A. SELECT * FROM 'student table' WHERE name = 'zhang san'

B. SELECT * FROM 'student table' WHERE name = John

C. SELECT * FROM student table WHERE name = 'zhang san'

D. SELECT * FROM student table WHERE name = John

(17) which of the following statements do not belong to Operation queries ______.

A. cross tabulation Query

B. Generate a table Query

C. Update Query

D. append Query

(18) which of the following forms does not belong to Access ______.

A. Table form

B. Data Table forms

C. graphical form

D. Chart form

(19) The display effect of a control can be set through its "special effect" attribute. Which of the following attributes does not belong to the "special effect" attribute is ______.

A. Plane

B. Raised

C. Chisel marks

D. Transparent

(20) validity rules are mainly used ______.

A. Define the Data Type

B. Define the data format

C. Set whether the data is valid

D. Define the data value range

(21) Which of the following is NOT a form control ______.

A. Table

B. Single-choice button

C. Images

D. Straight Line

(22) which of the following statements are not in the format of Access predefined reports ______.

A. "standard"

B. "bold"

C. "formal"

D. "random"

(23) which of the following statements about reports are correct ______.

A. Only data can be input in A report.

B. Reports can only output data

C. Report Data Input and Output

D. Report data cannot be input or output

(24) a report can group up to ______ fields or expressions.

A.6

B .8

C.10

D.16

(25) to set the information output at the top of each page of the report, you must set ______.

A. Report Header

B. Report footer

C. page header

D. Page footer

(26) when data in the database needs to be published in Access, which of the following objects can be used ______.

A. Data access page

B. Table

C. Form

D. Query

(27) a macro is a set of one or more.

A. Command

B. Operations

C. Object

D. Expression

(28) The macro command used to open a report is ______.

A. OpenForm

B. OpenReport

C. OpenQuery

D. RunApp

(29) When performing arithmetic operations on the logical values of VBA, the True value is treated ______.

A.0

B .1

C.-1

D. uncertain

(30) If you want to cancel the automatic operation of the macro, press and hold the ______ key when you open the database.

A. Shift

B. Ctrl

C. Alt

D. Enter

(31) defines two-dimensional array A (3 to 8, 3), the number of elements of this array is ______.

A.20

B .24

C.25

D.36

(32) read the following section:

K = 0

For I = 1 to 3

For J = 1 to I

K = K + J