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
65. Which data type should we use if we are planning to store a couple of paragraph or detailed description in a field ?
a) Text
b) Para
c) Memo
d) Desc
66. Which of the following database object hold data?
a) Forms
b) Reports
c) Queries
d) Tables
67. When creating a new table which method can be used to choose fields from standard databases and tables
a) create table in design view
b) create table using wizard
c) Create table by entering
d) none of these
68. Which one of these is the most common type of query that retrieves records from one or more tables and then displays the result in tabular form?
a) Tabular Query
b) Crosstab query
c) Select query
d) pivot query
69. Microsoft Access is a _____ kind of application ?
a) RDBMS
b) OODBMS
c) ORDBMS
d) Network Database Model
70. Queries in MS Access can be used _____
a) To view data
b) As source for forms
c) As source for Reports
d) All of these
71. The small button with three dots displayed at the right of field properties box is called :
a) Make button
b) Expression Button
c) Built Button
d) None of these
72. Which of the following shows the final result in a presentable way ?
a) Forms
b) Reports
c) Queries
d) Tables
73. In MS Access, how can we create relationship between two tables in the GUI?
a) Drag the foreign key of a table into the primary key of another table
b) Drag any field from parent table and drop on child table
c) Drag the primary key of a table into foreign key of another table
d) Any of these can be done to create relationship
74. Which of the following store command to gather data from database ?
a) Forms
b) Reports
c) Queries
d) Tables
75. A search value in SQL query can be a specific value or it can be _____
a) Logical Operator
b) Relationship
c) Wild card Character
d) Comparison operation
76. What is the default and maximum size of text field in MS Access ?
a) 50 and 255 characters
b) 8 and 1 Gb
c) 266 and 64000 characters
d) 8KB and 1.5 MB
77. How can we remove a relationship defined between two tables?
a) From edit menu ( by choosing delete relationship)
b) Select the relationship line and press delete
c) Choose Delete option from relationship menu
d) Choose remove option from relationship menu
78. In MS Access to open new database press
a) Ctrl + N
b) Ctrl + o
c) Alt + F4
d) None of these
79. In MS Access to open a combo box
a) F4 or Alt + Down Arrow
b) Down Arrow
c) Page down
d) F9
80. In MS Access to open an existing database press
a) Ctrl + N
b) Ctrl + o
c) Alt + F4
d) None of these
81. In MS Access to refresh the contents of a lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
a) F4 or Alt + Down Arrow
b) Down Arrow
c) Page down
d) F9
82. Press the following keys in MS Access to cancel print preview or layout preview
a) Ctrl + p
b) P or ctrl + P
c) ctrl + s
d) C or Esc
83. Press the following keys in MS Access to Print the current or selected object
a) Ctrl + P
b) P or Ctrl + P
c) ctrl + s
d) C or Esc
84. In MS Access press Alt + F11 to
a) Display the control menu
b) Display the shortcut menu
c) Close the active window
d) None of these
85. How can you display the relationship in a database?
a) Select view > Relationship from the menu
b) Click the relationship button on the toolbar
c) Select Edit > Relationship from the menu
d) All of these
86. How can you display Pivot table report summary data in a currency format ?
a) Use custom calculation
b) Type in the currency symbol
c) Modify the field settings
d) None of these
87. A query summarizes information in a grid, organized by regions and months. Which type of query is this?
a) A cross tab query
b) An update query
c) A parameter query
d) An active query
88. The filters by selection feature allows you to filter
a) Those records that match an entity in a field
b) Records based on a criterion you specify
c) Records that meet any of several criteria you specify
d) All of these
89. How can you display sales grouped by country, region, and salesperson, all at the same time?
a) Use the sort descending command
b) Use the pivot table view command
c) Use the fine command on specified group
d) All of these
90. What is the memo data type field used for?
a) To add table
b) To store objects created in other programs
c) For long text entries
d) For shout text entries of no more than 255 characters
91. The checking operation performed on input data is called the
a) Validation of data
b) Verification of data
c) Cross check
d) Control of data
92. What is the purpose of the description column in Table Design view?
a) To define the data type applied to each field within the table
b) To describe the data that should be entered in each field
c) To enter lookup data that the field should refer to
d) None of these
93. What is the purpose to a sub datasheet?
a) To provide a hierarchical view of related tables or queries in a single window
b) To display grouped data in a report
c) To display summarized data.
d) All of these
94. You can keep the sum ([sales]) to calculate the totals for each month in
a) The report footer section
b) the page footer section
c) the month group footer section
d) the summary section
95. The type of query extract the data and put them into separate table
a) A parameter query
b) A make-table query
c) An update query
d) A crosstab query
96. The procedure for selecting multiple controls on a report
a) Hold down the shift key as you click each object that you want to select
b) If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls
c) Hold down the Ctrl key as you click each object that you want to select
d) All of these
97. The following database object can you import from one MS-Access database to another?
a) Queries
b) Tables
c) Forms
d) All of these
98. What field type is used to store picture in a table?
a) Memo
b) OLE
c) Hyperlink
d) None
99. Queries design window has two parts. The upper part shows
a) Name of fields, field type and size
b) Sorting check boxes
c) Tables with fields and relationships between tables
d) None of these
100. In a database table, the category of information is called _____
a) record
b) Tuple
c) field
d) None of these
101. Which of the following is not a database object?
a) Form
b) Tables
c) Reports
d) Relationships
102. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
a) Data dictionary
b) data refinement
c) data definition
d) none of these
103. This key uniquely identifies each record
a) key record
b) composite key
c) foreign key
d) primary key
104. Which of the field has width 8 bytes?
a) Currency
b) memo
c) hyperlink
d) date/time
105. Which of the following are view to display a table in Access?
a) Datasheet view
b) Design view
c) Both A and B
d) None of these
106. A _____ enables you to view data from a table based on a specific criterion
a) Query
b) Report
c) Form
d) All of these
107. Which of the following database object produces the final result to present ?
a) Table
b) Reports
c) Queries
d) None of these
108. The database language that allows you to access or maintain data in a database
a) DML
b) DCL
c) DDL
d) TCL
109. What are the columns in Microsoft Access table called?
a) Table
b) Reports
c) Queries
d) fields
110. The ______ operator will cause a report to be selected only if two or more conditions are satisfied
a) NOT
b) XOR
c) OR
d) AND
111. What is the maximum length a text field can be?
a) 255
b) 256
c) 257
d) 355
112. DCL provide commands to perform actions like
a) Change the structure of tables
b) Authorizing access and other control over database
c) Insert, update or delete records and data values
d) All of these
113. Which of the following store command to retrieve data from database?
a) Queries
b) Forms
c) Records
d) Reports
114. A part of database that stores only one type of data is
a) Record
b) Table
c) Field
d) Report
115. A database can be best described as
a) Useful presentation of data
b) Organized collection of data
c) Graphical representation of data
d) None of these
116. Collection of related records in a database is known as
a) Record
b) Table
c) Field
d) Report
117. The complete information about an entity in a database is called
a) Record
b) Table
c) Field
d) Report
118. The task of arranging data in order is called
a) Ordering
b) Searching
c) Sorting
d) Ascending
119. A composite key is
a) The primary key with Auto Number as the field type
b) Is a foreign key that uniquely identifies records
c) Made up of two or more fields to uniquely identify records
d) None of these
120. An organized collection of logically related data is known as
a) Data base
b) Meta data
c) Information
d) Information
121. HSAM stands for______
a) Hierarchic standard and method
b) Hierarchic Sequential and method
c) Hierarchic standard Access method
d) Hierarchic Sequential Access Method
122. In a database, what does each row represent ?
a) Field
b) Database
c) Record
d) All of these
123. What do you call a primary key field included in another table ?
a) Child key
b) Composite key
c) Parent key
d) Foreign key
124.Which data type is better to use for storing the price of an item?
a) Number
b) Text
c) Currency
d) Hyperlink
125. The basic elements of a form or a report are called :
a) Windows
b) Controls
c) Objects
d) Table
126. Which of the following data type is used to store logical value in MS Access?
a) Yes/No
b) On/ Off
c) True/False
d) All of these
127. In MS Access ―Lookup Wizard‖ is used to
a) To select value from another table
b) To select values from Excel sheet
c) To select from previous values
d) None of the Above
128. Which of the following is use to get data from user?
a) Query
b) Form
c) Report
d) Table
129. Validation Rule in a field will
a) Defines the appearance for the text
b) Displays the value in specified format when user leave the field
c) Checks the value entered when user leaves the field
d) None of the above
130. Query can be used to select data from
a) single table
b) multiple table
c) Both single & Multiple tables
d) None of these
131. Data can be import into Access Database from
a) Notepad Files
b) Power point files
c) Word files
d) Excel files
132. Queries can be created in Access by
a) Using Query Wizard
b) Typing Queries in SQL View
c) Drag and Drop fields on Query Builder
d) All of these
133. Which of the following is the default join between two records?
a) Inner join
b) Outer join
c) Right outer join
d) None of these
134. Any report, including a basic report, can be modified in ______ .
a) Print Preview
b) Report view
c) Layout view
d) All of these
135. Using he keyword _____ will return records is which the field value equals a defined text.
a) Like
b) Between
c) Is Null
d) Equal
136. In a query, using the keyword ______ will return records in which the field value is between two numbers.
a) Like
b) Between
c) Is Null
d) Equal
137. Database is also called as ______
a) DBMS
b) RDMS
c) DDMS
d) None of these
138.In Access data is stored in _____
a) Rows
b) Columns
c) Both A and B
d) None of these
139. The organization of a table is _______.
a) Logical
b) Physical
c) Both A and B
d) None of these
140. Access contains objects like _____
a) Tables
b) Forms
c) Queries
d) All of these
141. Popular Databases are _____
a) Access
b) FoxPro
c) Clipper
d) All of these
142. In RDMS, a table is comparable to a database file but more_____
a) Lonely structured
b) Highly Structured
c) Non structured
d) None of these
143. Each record in a table contain _____ keys.
a) Unique
b) Primary keys
c) Both A and B
d) None of these