In Microsoft Access, Data type is a set of qualities that applies to all
the values contained in the field and that determines what kind of data those
values can be. In this series of Multiple Choice Question set
you will get MCQ Questions from Microsoft
Access,
1. An organized collection of logically related data is known
as
A. Data
B. Meta data
C. Database
D. Information
2. In databases, Locking level is also called as
A. Granularity
B. S lock
C. X lock
D. Dead lock
3. Which of the following is not a database application?
A. dBase
B. Flash
C. FoxPro
D. Access
4. HSAM stands for ________
A. Hierarchic Sequential Access Method
B. Hierarchic Standard Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
5. Which of the following is not a logical database structure?
A. Chain
B. Network
C. Tree
D. Relational
6. In a datasheet, what does each column represent?
A. Record
B. Field
C. Database
D. Table
7. In a datasheet, what does each row represent?
A. Record
B. Field
C. Database
D. Table
8. A ________ is a unit of information in a ________
A. record, field
B. field, record
C. data source, field
D. record, data source
9. What do you call a primary key field included in another table?
A. Foreign key
B. Parent key
C. Child key
D. Index
10. Which type of field is incremented automatically?
A. Auto Elevate
B. AutoNumber
C. Auto Increment
D. Auto Value
11. Which object is used to create a form?
A. Tables and Queries
B. Tables only
C. Tables and reports
D. Queries and reports
12. What determines a table’s sort order?
A. AutoNumber field
B. Index field
C. Field order
D. Primary key
13. What is an intersection of a row and a column?
A. Form
B. Cursor
C. Cell
D. Record
14. 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
15. 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
16. 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
17. Which is the valid data type in Access?
A. Number
B. Text
C. Currency
D. All of the above
18. How many relations may exist between tables in databases?
A. 4
B. 3
C. 2
D. 1
19. What is the full form of SQL?
A. Sophisticated Question List
B. Structured Question List
C. Structured Query Language
D. Small Query Length
20. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
A. Text
B. AutoNumber
C. Number
D. Currency
21. What do you call a collection of records matching parameters of a query?
A. Field
B. Record
C. Query
D. Dynaset
22. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
A. Search query
B. Cross tab query
C. Select query
D. Update query
23. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
A. zipcode, firstname, lastname
B. firstname, lastname, zipcode
C. zipcode, lastname, firstname
D. can’t sort by multiple fields
24. What does the expression [detail] ! [product] * 1.30 do?
A. multiplies the contents of detail and product fields by 1.3
B. First divides detail by product and then multiplies by 1.3
C. multiplies the contents of detail in the product table by 1.3
D. multiplies the contents of product in the detail table by 1.3
25. Which criteria return only those addresses beginning with the letter “K”?
A. address = “K”
B. address = “K*”
C. address = “K?”
D. address = “K#”
26. Which criteria do not return the position “Officer” as a match?
A. position = “*ff*”
B. position = “O??icer”
C. position = “ ?ff*”
D. position = “O#r”
27. Which query do you use to answer the question “What is the average salary of the employees”?
A. Search query
B. Cross tab query
C. Select query
D. Update query
28. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
A. display all customers with CustID from 10 to 100
B. display all customers with CustID above 10
C. display all customers with CustID below 100
D. display all customers with CustID from 11 to 99
29. How to make a date field DOB store the dates like “2002/10/17” ?
A. By setting the input mask property to “yyyy/mm/dd”
B. By setting the format property to “yyyy/mm/dd”
C. By entering dates in yyyy, mm, dd order
D. none of the above
30. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
A. By setting required to ‘Yes’
B. By using default value
C. By defining validation rule
D. By using format
Answers
1 – C / 2 – A / 3 – B / 4 – A / 5 – A / 6 – B / 7 – A / 8 – B / 9 – A / 10 – B
11 – A / 12 – B / 13 – C / 14 – C / 15 – D / 16 – B / 17 – D / 18 – B / 19 – C / 20 – A
21 – D / 22 – C / 23 – C / 24 – D / 25 – B / 26 – D / 27 – C / 28 – D / 29 – B / 30 – C
A. Data
B. Meta data
C. Database
D. Information
2. In databases, Locking level is also called as
A. Granularity
B. S lock
C. X lock
D. Dead lock
3. Which of the following is not a database application?
A. dBase
B. Flash
C. FoxPro
D. Access
4. HSAM stands for ________
A. Hierarchic Sequential Access Method
B. Hierarchic Standard Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
5. Which of the following is not a logical database structure?
A. Chain
B. Network
C. Tree
D. Relational
6. In a datasheet, what does each column represent?
A. Record
B. Field
C. Database
D. Table
7. In a datasheet, what does each row represent?
A. Record
B. Field
C. Database
D. Table
8. A ________ is a unit of information in a ________
A. record, field
B. field, record
C. data source, field
D. record, data source
9. What do you call a primary key field included in another table?
A. Foreign key
B. Parent key
C. Child key
D. Index
10. Which type of field is incremented automatically?
A. Auto Elevate
B. AutoNumber
C. Auto Increment
D. Auto Value
11. Which object is used to create a form?
A. Tables and Queries
B. Tables only
C. Tables and reports
D. Queries and reports
12. What determines a table’s sort order?
A. AutoNumber field
B. Index field
C. Field order
D. Primary key
13. What is an intersection of a row and a column?
A. Form
B. Cursor
C. Cell
D. Record
14. 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
15. 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
16. 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
17. Which is the valid data type in Access?
A. Number
B. Text
C. Currency
D. All of the above
18. How many relations may exist between tables in databases?
A. 4
B. 3
C. 2
D. 1
19. What is the full form of SQL?
A. Sophisticated Question List
B. Structured Question List
C. Structured Query Language
D. Small Query Length
20. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
A. Text
B. AutoNumber
C. Number
D. Currency
21. What do you call a collection of records matching parameters of a query?
A. Field
B. Record
C. Query
D. Dynaset
22. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
A. Search query
B. Cross tab query
C. Select query
D. Update query
23. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
A. zipcode, firstname, lastname
B. firstname, lastname, zipcode
C. zipcode, lastname, firstname
D. can’t sort by multiple fields
24. What does the expression [detail] ! [product] * 1.30 do?
A. multiplies the contents of detail and product fields by 1.3
B. First divides detail by product and then multiplies by 1.3
C. multiplies the contents of detail in the product table by 1.3
D. multiplies the contents of product in the detail table by 1.3
25. Which criteria return only those addresses beginning with the letter “K”?
A. address = “K”
B. address = “K*”
C. address = “K?”
D. address = “K#”
26. Which criteria do not return the position “Officer” as a match?
A. position = “*ff*”
B. position = “O??icer”
C. position = “ ?ff*”
D. position = “O#r”
27. Which query do you use to answer the question “What is the average salary of the employees”?
A. Search query
B. Cross tab query
C. Select query
D. Update query
28. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
A. display all customers with CustID from 10 to 100
B. display all customers with CustID above 10
C. display all customers with CustID below 100
D. display all customers with CustID from 11 to 99
29. How to make a date field DOB store the dates like “2002/10/17” ?
A. By setting the input mask property to “yyyy/mm/dd”
B. By setting the format property to “yyyy/mm/dd”
C. By entering dates in yyyy, mm, dd order
D. none of the above
30. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
A. By setting required to ‘Yes’
B. By using default value
C. By defining validation rule
D. By using format
Answers
1 – C / 2 – A / 3 – B / 4 – A / 5 – A / 6 – B / 7 – A / 8 – B / 9 – A / 10 – B
11 – A / 12 – B / 13 – C / 14 – C / 15 – D / 16 – B / 17 – D / 18 – B / 19 – C / 20 – A
21 – D / 22 – C / 23 – C / 24 – D / 25 – B / 26 – D / 27 – C / 28 – D / 29 – B / 30 – C
Tags
Fundamental