Quiz Questions - ITI Quiz - 04-Feb-2026 10:03 AM

Question 1 1 Marks

Which key stoke is used to move the active cell towards right, in access table?

A

Ctrl + Tab

B

Alt + Tab

C

Tab

D

Shift + Tab

Question 2 1 Marks

Which validation rule accepts only a - z letters for fields in Access?

A

Is null or NOT like ?*[! a - z]*?

B

Is null or NOT like ?*[a - z ]*?

C

Is null or NOT like ?*![a - z]*?

D

Is null or NOT like ?[! a - z]?

Question 3 1 Marks

Which key stroke moves the active cell towards left in Access table?

A

F2

B

F5

C

Tab

D

Shift + Tab

Question 4 1 Marks

Which validation rule allows exactly digits for number fields in Access?

A

Is Null or Between 100000 and 99999

B

Is Null or Like ??????

C

Is Null or >= 0 AND< = 99999

D

Is Null or < = 99999

Question 5 1 Marks

Which command quickly locates the data is Access table?

A

Find

B

Locate

C

Search

D

Edit

Question 6 1 Marks

What is the output when the data 'FOREIGN key' is set to the text format > in Access?

A

foreign key

B

FOREIGN KEY

C

Foreign Key

D

Foreign key

Question 7 1 Marks

Which validation rule allows only 0 - 9 for fields in Access?

A

Is Null or Not Like ?*[ ! 0 - 9 ]*?

B

Is Null or Not Like ?[! 0 - 9]?

C

Is Null or Not Like ?*[0 - 9]*?

D

Is Null or Not Like ?*[!0-9]*?

Question 8 1 Marks

Which of the following is a valid time format is Access?

A

hh:mm:ss AM/PM

B

hh.mm.ss AM/PM

C

hh-mm-ss AM/PM

D

hh/mm/ss AM/PM

Question 9 1 Marks

Which combination of key zooms the content of active cell in Access table?

A

Ctrl + F2

B

Ctrl + F5

C

Shift + F2

D

Shift + F5

Question 10 1 Marks

Write the output when the data 'Primary Key' is set to the text < in Access?

A

Primary key

B

primary key

C

PRIMARY KEY

D

Primary Key

Question 11 1 Marks

Which view allows to modify table's structure in Access?

A

Design view

B

Datasheet view

C

Pivot table view

D

Pivot shart view

Question 12 1 Marks

What is the reason for not accepting zero in the fields of Access tables?

A

Fields is set with is Null or > 0

B

Fields is set with is Null or < = 0

C

Fields is set with is Null or! [0]

D

Fields is set with is Null or like ???

Question 13 1 Marks

Which view is used to arrange table data in different graphical layouts to summarize data?

A

Table view

B

Design view

C

Data sheet view

D

Pivot chart view

Question 14 1 Marks

What is allowed the input mark symbol # in Access?

A

Letter or digit

B

Letter A through Z

C

A digit 0 - 9 with +/- sign

D

A digit 0 - 9 without +/- sign

Question 15 1 Marks

Which validation rule allows only positive numbers for fields in?

A

Is Null or > = 0

B

Is Null or Positive

C

Is Null or < 0

D

Is Null or = ?+?

Question 16 1 Marks

What is the expansion of OLE in Access?

A

object linking and embedding

B

object linking and encrypting

C

object linking and editing

D

objet linking

Question 17 1 Marks

Which technique prevents invalid data being saved in Access table?

A

Index

B

Filter

C

Validation rule

D

Input mark

Question 18 1 Marks

What is the maximum number of characters allowed in text field is access?

A

255

B

256

C

64000

D

65000

Question 19 1 Marks

What is the maximum length of the field name in Access?

A

16 characters

B

32 characters

C

64 characters

D

128 characters

Question 20 1 Marks

What is the output when the data '1678.95' is set to the number format '###0.00' in

A

1670

B

1670.95

C

1678

D

1678.95

Question 21 1 Marks

Which combination of key allows user to move to the first field in the first record in Access table?

A

Ctrl + Tab

B

Shift +Tab

C

Shift + Home

D

Ctrl + Home

Question 22 1 Marks

Which object stores information about related data?

A

Document

B

Table

C

Page

D

Screen