MS-ACCESS MCQ For HPSSC JOA IT Exam
TEST SERIES:- HPSSC JOA IT Daily Test 2021 (TOTAL TEST 5 WITH ANSWER KEY)
1. Microsoft Access provides visual environment for design of _______.
(a) tables
(b) reports
(c) forms
(d) all of them
2. By default, new table is displayed in ______view.
(a) Datasheet View
(b) Design View
(c) Report View
(d) Form View
3. _______ is an alternate to datasheet view for design of table in MS Access.
(a) Datasheet View
(b) Design View
(c) Report View
(d) Form View
4. An ordinary form for data entry in MS Access tables may be created using______ menu.
(a) Create >Form
(b) Create >Split Form
(c) Create >Multiple Items
d) Create >Blank Form
5. In MS Access, a form with data records at one half and entry format at the other half may be
created using______ menu.
(a) Create >Form
(b) Create >Split Form
(c) Create >Multiple Items
(d) Create >Blank Form
6. In MS Access, multiple rows of data may be created using______ menu.
(a) Create >Form
(b) Create >Split Form
(c) Create >Multiple Items
(d) Create >Blank Form
7. In MS Access, blank form may be created using______ menu.
(a) Create >Form
(b) Create >Split Form
(c) Create >Multiple Items
(d) Create >Blank Form
8. In MS Access, form may created through a wizard using______ menu.
(a) Create >More Forms >Form Wizard
(b) Create >Split Form
(c) Create >Multiple Items
(d) Create >Blank Form
9. In MS Access, data sheet may be created using _______ menu.
(a) Create >More Forms >Form Wizard
(b) Create >More Forms >Data Sheet
(c) Create >More Forms >Modal Dialog
(d) Create >Blank Form
10. In MS Access, form dialog may be created using_______ menu.
(a) Create >More Forms >Form Wizard
(b) Create >More Forms >Data Sheet
(c) Create >More Forms >Modal Dialog
(d) Create >Blank Form
11. In MS Access, form may be manually designed through available components (like textfield, datapicker, combo-box, etc.) using ______menu.
(a) Create >More Forms >Form Wizard
(b) Create >More Forms >Data Sheet
(c) Create >More Forms >Modal Dialog
(d) Create >Form Design
12. In MS Access, default report may be created using ______ menu.
(a) Create >Report
(b) Create >Blank Report
(c) Create >Report Wizard
(d) Create >Report Design
13. In MS Access, blank report may be created using_______ menu.
(a) Create >Report
(b) Create >Blank Report
(c) Create >Report Wizard
(d) Create >Report Design
14. In MS Access, report may be created through wizard using_______ menu.
(a) Create >Report
(b) Create >Blank Report
(c) Create >Report Wizard
(d) Create >Report Design
15. In MS Access, report may be designed using components like combobox, text field, text area, list, etc. using _______menu.
(a) Create >Report
(b) Create >Blank Report
(c) Create >Report Wizard
(d) Create >Report Design
16. In MS Access, macro may be recorded to carry out different actions using______ menu.
(a) Create >Report
(b) Create >Blank Report
(c) Create >Report Wizard
(d) Create >Macro
17. In MS Access, a macro can be activated by pressing,_______ button.
(a) Form
(b) Report
(c) Run
(d) Table
18. In MS Access, macros can automate__________ .
(a) program flow/ data entry
(b) data import/ data export
(c) filter/ query/ search
(d) all of them
19. What is the maximum length of the field name in Access?
A 16 characters
B 32 characters
C 64 characters
D 128 characters
20. Which view is used to arrange table data in different graphical layouts to summarize data?
A Table view
B Design view
C Data sheet view
D Pivot chart view
21. Which view allows to modify table‘s structure in Access?
A Design view
B Datasheet view
C Pivot table view
D Pivot shart view
22. Which object stores information about related data?
A Document
B Table
C Page
D Screen
23. Which key stoke moves the active cell towards left in Access table?
A F2
B F5
C Tab
D Shift + Tab
24. Which combination of key zooms the content of active cell in Access table?
A Ctrl + F2
B Ctrl + F5
C Shift + F2
D Shift + F5
25. Which technique prevents invalid data being saved in Access table?
A Index
B Filter
C Validation rule
D Input mark
26. Which validation rule accepts only a – z letters for fields in Access?
A Is null or NOT like ―*[! a – z]*‖
B Is null or NOT like ―*[a – z ]*‖
C Is null or NOT like ―*![a – z]*‖
D Is null or NOT like ―[! a – z]‖
27. Which validation rule allows only 0 – 9 for fields in Access?
A Is Null or Not Like ―*[ ! 0 – 9 ]*‖
B Is Null or Not Like ―[! 0 – 9]‖
C Is Null or Not Like ―*[0 – 9]*‖
D Is Null or Not Like ―*[!0-9]*‖
28. Which validation rule allows only positive numbers for fields in?
A Is Null or > = 0
B Is Null or Positive
C Is Null or < 0
D Is Null or = ―+‖
29. What is allowed the input mark symbol # in Access?
A Letter or digit
B Letter A through Z
C A digit 0 – 9 with +/- sign
D A digit 0 – 9 without +/- sign
30. Which validation rule allows exactly digits for number fields in Access?
A Is Null or Between 100000 and 99999
B Is Null or Like ―????‖
C Is Null or >= 0 AND< = 99999
D Is Null or < = 99999
31. What is the output when the data ‗1678.95‘ is set to the number format ‗###0.00‘ in Access?
A 1670.00
B 1670.95
C 1678.00
D 1678.95
32. Which of the following is a valid time format is Access?
A hh:mm:ss AM/PM
B hh.mm.ss AM/PM
C hh-mm-ss AM/PM
D hh/mm/ss AM/PM
33. Write the output when the data ‗Primary Key‘ is set to the text < in Access?
A Primary key
B primary key
C PRIMARY KEY
D Primary Key
34. What is the output when the data ―FOREIGN key‘ is set to the text format > in Access?
A foreign key
B FOREIGN KEY
C Foreign Key
D Foreign key
35. What is the reason for not accepting zero in the fields of Access tables?
A Fields is set with is Null or > 0
B Fields is set with is Null or < = 0
C Fields is set with is Null or! [0]
D Fields is set with is Null or like ―?‖
36. Which field type will you select when you need to enter long text in the field?
a) Text
b) memo
c) currency
d) hyperlink
37. The expression builder is access tool that controls expression ____ for entering expression
a) Table
b) Box
c) Cell
d) Palette
38. Which of the following is not type of MS Access database object?
a) Table
b) Form
c) Worksheets
d) Modules
39. In which method we don‘t need to specify the field type and size while creating a new table?
a) Design view
b) While using Wizard
c) Create Table by entering Data
d) All of these
40.Th size of yes/no field is always ______ .
a) 1 Bit
b) 1 byte
c) 1 character
d) 1 kb
41. The size of a field with number data type can not be ____
a) 2
b) 4
c) 8
d) 16
42. What does the show check box in query design window indicate?
a) It indicates whether the field is to be used or not.
b) It indicates whether the field is to be displayed in query result or not
c) It indicates whether the field names to be displayed in query result or not.
d) It indicates whether the field is to be used for grouping result or not.
43. Which of the following option creates a Drop Down list of values ?
a) Ole Object
b) Hyperlink
c) Memo
d) Lookup wizard
44. What is a form that we can create in MS Access ?
a) it is used to take printout of a form from Access Tables.
b) It is an input screen for viewing and entering data.
c) It is used for storing special data other than text.
d) It is optional. We can use report instead of Form
45. What cascade delete option is used for?
a) It is used to delete all the records of all tables in a database.
b) It repeats the recent delete operation to all the records of current table.
c) It ensure that all the related records will be deleted automatically when the record from parent table is deleted.
d) It is used to delete all the records of related tables in a database.
46. The ______ button on the tool box display data from a related table.
a) Sub form sub report
b) Relationships
c) select objects
d) More controls
47. The command center of MS access file that appears when we create or open the MS Access database file
a) Database window
b) Query window
c) Design view window
d) switchboard
48. While creating relationship using mouse, how the mouse pointer looks like?
a) A thick plus sign
b) A thin plus sign
c) An outlined rectangle
d) Arrow with plus sign
49. The columns is a Microsoft access table are also called ______.
a) Rows
b) Records
c) Field
d) Columns
50. how can you define a field so that when entering data #### is displayed?
a) Input mask
b) Validation rule
c) Indexed
d) Ime mode
51. In the context of Microsoft access, which of the following statement is true?
a) Reports are used to retrieve and calculate data from tables.
b) Queries can be printed and presented as the information
c) Queries can include calculated fields that do not exist in table
d) Reports and forms are similar but forms are use to print but reports to display on screen only
52. The upper part of the query design window in MS Access has two parts shows ______.
a) Fields name with field size
b) Field name with relationships
c) Fields and Criteria
d) Sorting Options
53. To define AND condition while entering criteria in a query design window we write ____
a) Criteria values vertically one in a row
b) Criteria values horizontally
c) Write criteria values separated by AND
d) Write criteria values using & (anchor and) sign
54. Which feature is used to duplicate a control‘s formatting ?
a) Manager
b) Wizard
c) Painter
d) Control
55. Which of the following is not a type of relationship that can be applied in Access database?
a) One to one
b) One to many
c) Many to many
d) All of these
56. While creating relationship, what happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
a) A relationship is created
b) Edit relationship dialog box appears
c) A connector symbol is created
d) A connecting line is visible
57. What is the role of Cascade update option ?
a) It says do not change the value in the primary key field if that record has related records in another table
b) It means change all the related records in child tables if the record in parent table is changed
c) Both A and B
d) None of these
58. How many ways to open a table in MS Access ?
a) 3
b) 2
c) 1
d) 4
59. Which of the following is a method to create a new table in MS Access?
a) Using Design View
b) Create Table Wizard
c) Directly Entering Data
d) All of these
60. If you write criteria values one in a row in query design window, that means you are specifying
a) Or Conditions
b) AND Conditions
c) NOT Conditions
d) ALL conditions
61. How can we create a query in Microsoft Access?
a) Drag and drop fields
b) Type the SQL
c) Use Query wizard
d) All of these
62. Which option allows us to build a new table by entering data directly into a tabular grid?
a) Datasheet view
b) Design view
c) Linked Table
d) Grid view
63. What is the shortcut key to switch between the field names and properties panels in table design view?
a) F3 key
b) F4 key
c) F5 key
d) F6 key
64. Which field type can store photos ?
a) Hyperlink
b) OLE object
c) Both can be used
d) it is not possible
PAID TEST SERIES:- HPSSSB JOA IT EXAM TEST SERIES(10 TEST WITH ANSWER KEY)
Read More:- Himachal Pradesh General Knowledge
