MCQ of Microsoft Access – Set 2

2-1.  Which object is used to create a form?
A. Tables and Queries
B. Tables only
C. Tables and reports
D. Queries and reports

2-2.  What determines a table’s sort order?
A. AutoNumber field
B. Index field    
C. Field order
D. Primary key

2-3.  What is an intersection of a row and a column?
A. Form
B. Cursor
C. Cell
D. Record

2-4.  Which tool do you use to create a query object?
A. Database wizard
B. Simple filter wizard
C. Simple query wizard
D. Table query wizard

2-5.  Which of the following is not a view for interacting with a form object?
A. Datasheet view
B. Design view
C. Form view
D. Layout view

2-6.  What is the purpose of indexing?
A. To reduce table size
B. To speedup data search
C. both A and B
D. none of the above

2-7.  Which is the valid data type in Access?
A. Number
B. Text
C. Currency
D. All of the above

2-8.  How many relations may exist between tables in databases?
A. 4
B. 3
C. 2
D. 1

2-9.  What is the full form of SQL?
A. Sophisticated Question List
B. Structured Question List
C. Structured Query Language
D. Small Query Length

2-10.  Which data type is better to use for storing phone number in the following format “977-1-1234567

3 Responses to “MCQ of Microsoft Access – Set 2”

  1. Eukeria 14 August 2012 at 9:42 PM

    thanks for this questions

  2. soumya 11 August 2015 at 2:42 PM

    not able to view answers

  3. Pramod pal 27 February 2018 at 7:56 PM

    Thanks for the question


Leave a Reply

error: Content is protected !!