(A) Number
(B) AutoNumber
(C) Currency
(D) Text
Tag: MS Access Mcq Questions and Answers
Which leads you through the process of creating a table?
(A) Relation
(B) Coach
(C) Assistant
(D) Wizard
Which query do you use to answer the question ‘’What is the average salary of the employees’’?
(A) Cross Tab Query
(B) Search Query
(C) Select Query
(D) Update Query
What do you call a collection of records matching parameters of a query?
(A) Dynaset
(B) Query
(C) Field
(D) Record
Which data type is better to use for storing phone number in the following format ‘’977-1-1234567’’?
(A) Number
(B) AutoNumber
(C) Currency
(D) Text
SQL stands for?
(A) Structured Question List
(B) Structured Query Language
(C) Small Query Length
(D) None of the above
How many relations may exist in a table of a database?
(A) 1
(B) 2
(C) 3
(D) 4
What is the purpose of indexing?
(A) To speed up data search
(B) To reduce table size
(C) Both of the above
(D) None of the above