(A) Number
(B) AutoNumber
(C) Currency
(D) Text
Category: MS Access Mcqs
MS Access Mcqs for NTS, PPSC, FPSC, SPSC, KPPSC, AJKPSC, PMS, PTS, Data Entry Operator, Computer Operator and all computer related exams.
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