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, this is 2th set of this series. All the questions in this set
are related to the Data Types of Microsoft Access.
1. In an application created using the database wizard, the main menu is presented as a:
A. form, called a switchboard
B. report, called a menu
C. table, called a switchboard
D. query, called a menu
2. Which leads you through the process of creating a table?
A. wizard
B. assistant
C. relation
D. coach
3. Which data type is better to use for storing the price of an item?
A. Text
B. AutoNumber
C. Number
D. Currency
4. Which do you click to display the table’s primary key and indexes in a separate window?
A. indexes button
B. primary key button
C. view datasheet button
D. view design button
5. After right click the field selector button, which do you choose to delete a field in design view?
A. Delete field
B. delete rows
C. remove field
D. remove rows
6. Which tool is used to generate printout of a table’s structure?
A. Analyzer
B. Designer
C. Documenter
D. Generator
7. Which of the following is not a legitimate section for form objects?
A. Form detail
B. Group header
C. Form header
D. Page footer
8. The basic elements of a form or a report are called:
A. Controls
B. Objects
C. Windows
D. Properties
9. Which control types is most often associated with a bound control?
A. command button
B. label
C. text box
D. list box
10. Which control type do you use to create a calculated control?
A. command button
B. combo box
C. text box
D. list box
11. Which is not a view for displaying a report object?
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
12. The report footer section is most useful for displaying:
A. grand totals
B. Column headings
C. subtotals
D. page numbers
13. Which function can not be used for calculated controls in a report?
A. SUM
B. AVG
C. MPT
D. COUNT
14. Which setting you must modify to print a report using letterhead?
A. Group
B. Margin
C. Section
D. Orientation
15. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
A. datasheet border
B. datasheet underline
C. Column Header underline
D. vertical gridline
16. Which is not an option for customizing a datasheet window?
A. change one row’s height
B. hide one column
C. change one column’s width
D. freeze one column
17. Which is not a command that is selectable from right click menu of a field column?
A. Hide columns
B. Unhide columns
C. freeze columns
D. sort descending
18. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
A. filtering
B. restricting
C. sorting
D. sifting
19. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
A. Referential integrity is enforced
B. Referential integrity isn’t enforced
C. An inner join is set
D. An outer join is set
20. Which of the following is not an action query?
A. add
B. delete
C. make-table
D. update
21 In MS Access, Text Data type may contain maximum character of
A. 255 Character
B. 256 Character
C. 1064 Character
D. No Limit
22 Which of the following is not a valid Data Type in MS Access?
A. Memo
B. Picture
C. Currency
D. AutoNumber
23 In MS Access “Hyperlink” Data Type can store
A. Web Address
B. email Address
C. Path of a File
D. All of Above
24 Which of the following data type is used to store logical value in MS Access?
A. True/False
B. On/Off
C. Yes/No
D. All of Above
25 The appropriate Data Type to store Time in MS Access?
A. Date/Time
B. Time Only
C. Time
D. Time cannot be stored
26 In MS Access “Lookup Wizard” is used to
A. to select from previous values
B. to select values from Excel Sheet
C. to select value from another table
D. Not a valid Data Type
27 Which of the following Data Type is used to store picture in MS Access
A. Picture
B. OLE Object
C. Memo
D. Picture cannot be stored
28 in MS Access, which data type is appropriate to store large text and numbers?
A. Text
B. Memo
C. OLE
D. Large Text
29 in MS Access, OLE Object Data type can store
A. Microsoft Word documents
B. Microsoft Excel spreadsheets
C. Sounds
D. All of the Above
30 in MS Access, AutoNumber Data Type
A. Can be Sequential
B. Can be Random
C. Can be Edited
D. Only A & B
Answers
1 – A / 2 – A / 3 – D / 4 – A / 5 – B / 6 – C / 7 – B / 8 – A / 9 – C / 10 – C
11 – A / 12 – A / 13 – C / 14 – B / 15 – C / 16 – A / 17 – B / 18 – A / 19 – A / 20 – A
21 – A / 22 – B / 23 – D / 24 – C / 25 – A / 26 – C / 27 – B / 28 – B / 29 – D / 30 – D
1. In an application created using the database wizard, the main menu is presented as a:
A. form, called a switchboard
B. report, called a menu
C. table, called a switchboard
D. query, called a menu
2. Which leads you through the process of creating a table?
A. wizard
B. assistant
C. relation
D. coach
3. Which data type is better to use for storing the price of an item?
A. Text
B. AutoNumber
C. Number
D. Currency
4. Which do you click to display the table’s primary key and indexes in a separate window?
A. indexes button
B. primary key button
C. view datasheet button
D. view design button
5. After right click the field selector button, which do you choose to delete a field in design view?
A. Delete field
B. delete rows
C. remove field
D. remove rows
6. Which tool is used to generate printout of a table’s structure?
A. Analyzer
B. Designer
C. Documenter
D. Generator
7. Which of the following is not a legitimate section for form objects?
A. Form detail
B. Group header
C. Form header
D. Page footer
8. The basic elements of a form or a report are called:
A. Controls
B. Objects
C. Windows
D. Properties
9. Which control types is most often associated with a bound control?
A. command button
B. label
C. text box
D. list box
10. Which control type do you use to create a calculated control?
A. command button
B. combo box
C. text box
D. list box
11. Which is not a view for displaying a report object?
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
12. The report footer section is most useful for displaying:
A. grand totals
B. Column headings
C. subtotals
D. page numbers
13. Which function can not be used for calculated controls in a report?
A. SUM
B. AVG
C. MPT
D. COUNT
14. Which setting you must modify to print a report using letterhead?
A. Group
B. Margin
C. Section
D. Orientation
15. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
A. datasheet border
B. datasheet underline
C. Column Header underline
D. vertical gridline
16. Which is not an option for customizing a datasheet window?
A. change one row’s height
B. hide one column
C. change one column’s width
D. freeze one column
17. Which is not a command that is selectable from right click menu of a field column?
A. Hide columns
B. Unhide columns
C. freeze columns
D. sort descending
18. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
A. filtering
B. restricting
C. sorting
D. sifting
19. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
A. Referential integrity is enforced
B. Referential integrity isn’t enforced
C. An inner join is set
D. An outer join is set
20. Which of the following is not an action query?
A. add
B. delete
C. make-table
D. update
21 In MS Access, Text Data type may contain maximum character of
A. 255 Character
B. 256 Character
C. 1064 Character
D. No Limit
22 Which of the following is not a valid Data Type in MS Access?
A. Memo
B. Picture
C. Currency
D. AutoNumber
23 In MS Access “Hyperlink” Data Type can store
A. Web Address
B. email Address
C. Path of a File
D. All of Above
24 Which of the following data type is used to store logical value in MS Access?
A. True/False
B. On/Off
C. Yes/No
D. All of Above
25 The appropriate Data Type to store Time in MS Access?
A. Date/Time
B. Time Only
C. Time
D. Time cannot be stored
26 In MS Access “Lookup Wizard” is used to
A. to select from previous values
B. to select values from Excel Sheet
C. to select value from another table
D. Not a valid Data Type
27 Which of the following Data Type is used to store picture in MS Access
A. Picture
B. OLE Object
C. Memo
D. Picture cannot be stored
28 in MS Access, which data type is appropriate to store large text and numbers?
A. Text
B. Memo
C. OLE
D. Large Text
29 in MS Access, OLE Object Data type can store
A. Microsoft Word documents
B. Microsoft Excel spreadsheets
C. Sounds
D. All of the Above
30 in MS Access, AutoNumber Data Type
A. Can be Sequential
B. Can be Random
C. Can be Edited
D. Only A & B
Answers
1 – A / 2 – A / 3 – D / 4 – A / 5 – B / 6 – C / 7 – B / 8 – A / 9 – C / 10 – C
11 – A / 12 – A / 13 – C / 14 – B / 15 – C / 16 – A / 17 – B / 18 – A / 19 – A / 20 – A
21 – A / 22 – B / 23 – D / 24 – C / 25 – A / 26 – C / 27 – B / 28 – B / 29 – D / 30 – D
Tags
Fundamental