Which Of The Following Can You Change In Datasheet View Of A Query
MS Access MCQ For HPSSC JOA IT Exam
TEST SERIES:- HPSSC JOA IT Daily Examination 2021 (T OTAL Examination v WITH ANSWER Key )
ane. Microsoft Access provides visual surround for design of _______.
(a) tables
(b) reports
(c) forms
(d) all of them
two. Past default, new table is displayed in ______view.
(a) Datasheet View
(b) Blueprint View
(c) Study View
(d) Form View
three. _______ is an alternate to datasheet view for blueprint of table in MS Admission.
(a) Datasheet View
(b) Design View
(c) Report View
(d) Form View
4. An ordinary grade for data entry in MS Access tables may be created using______ menu.
(a) Create >Grade
(b) Create >Divide Form
(c) Create >Multiple Items
(d) Create >Blank Class
five. In MS Admission, a form with data records at ane one-half and entry format at the other half may exist
created using______ menu.
(a) Create >Class
(b) Create >Split Form
(c) Create >Multiple Items
(d) Create >Blank Course
half dozen. In MS Access, multiple rows of data may exist created using______ card.
(a) Create >Grade
(b) Create >Split Form
(c) Create >Multiple Items
(d) Create >Blank Class
7. In MS Access, bare form may be created using______ carte du jour.
(a) Create >Form
(b) Create >Split Form
(c) Create >Multiple Items
(d) Create >Bare Form
8. In MS Admission, form may created through a wizard using______ menu.
(a) Create >More Forms >Grade Wizard
(b) Create >Divide Form
(c) Create >Multiple Items
(d) Create >Blank Form
9. In MS Admission, data sheet may be created using _______ menu.
(a) Create >More than Forms >Grade Magician
(b) Create >More than Forms >Data Sheet
(c) Create >More than Forms >Modal Dialog
(d) Create >Bare Grade
10. In MS Access, form dialog may exist created using_______ carte du jour.
(a) Create >More than Forms >Form Sorcerer
(b) Create >More than Forms >Data Canvass
(c) Create >More than Forms >Modal Dialog
(d) Create >Bare Form
eleven. In MS Access, grade may be manually designed through available components (similar 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 Blueprint
12. In MS Access, default report may be created using ______ menu.
(a) Create >Written report
(b) Create >Blank Report
(c) Create >Written report Magician
(d) Create >Report Design
13. In MS Access, bare report may be created using_______ menu.
(a) Create >Written report
(b) Create >Blank Report
(c) Create >Report Wizard
(d) Create >Report Design
14. In MS Access, report may be created through sorcerer using_______ card.
(a) Create >Written report
(b) Create >Blank Report
(c) Create >Report Magician
(d) Create >Report Pattern
15. In MS Access, report may exist designed using components like combobox, text field, text area,
list, etc. using _______menu.
(a) Create >Written report
(b) Create >Blank Study
(c) Create >Study Wizard
(d) Create >Written report Design
16. In MS Access, macro may be recorded to carry out different actions using______ menu.
(a) Create >Report
(b) Create >Bare Written report
(c) Create >Report Wizard
(d) Create >Macro
17. In MS Access, a macro can exist activated by pressing,_______ button.
(a) Form
(b) Study
(c) Run
(d) Table
18. In MS Access, macros can automate__________ .
(a) program menses/ data entry
(b) data import/ data consign
(c) filter/ query/ search
(d) all of them
xix. What is the maximum length of the field name in Access?
A sixteen characters
B 32 characters
C 64 characters
D 128 characters
xx. Which view is used to arrange table information in different graphical layouts to summarize data?
A Table view
B Pattern view
C Data sheet view
D Pin chart view
21. Which view allows to alter table's structure in Admission?
A Pattern view
B Datasheet view
C Pivot table view
D Pivot shart view
22. Which object stores information nearly related data?
A Certificate
B Table
C Page
D Screen
23. Which key stoke moves the active jail cell towards left in Access tabular array?
A F2
B F5
C Tab
D Shift + Tab
24. Which combination of central zooms the content of active cell in Admission tabular array?
A Ctrl + F2
B Ctrl + F5
C Shift + F2
D Shift + F5
25. Which technique prevents invalid information beingness saved in Access table?
A Alphabetize
B Filter
C Validation rule
D Input mark
26. Which validation dominion accepts merely a - z letters for fields in Access?
A Is aught or NOT similar ―*[! a - z]*‖
B Is null or Non similar ―*[a - z ]*‖
C Is null or NOT like ―*![a - z]*‖
D Is null or NOT like ―[! a - z]‖
27. Which validation rule allows but 0 - 9 for fields in Access?
A Is Null or Not Like ―*[ ! 0 - 9 ]*‖
B Is Null or Not Similar ―[! 0 - 9]‖
C Is Null or Not Like ―*[0 - nine]*‖
D Is Null or Not Like ―*[!0-ix]*‖
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 marking symbol # in Access?
A Letter of the alphabet or digit
B Letter A through Z
C A digit 0 - 9 with +/- sign
D A digit 0 - nine without +/- sign
30. Which validation rule allows exactly digits for number fields in Access?
A Is Zero or Between 100000 and 99999
B Is Nada 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 up to the number format ‗###0.00' in Admission?
A 1670.00
B 1670.95
C 1678.00
D 1678.95
32. Which of the following is a valid time format is Admission?
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 information ‗Primary Key' is prepare to the text < in Admission?
A Chief fundamental
B primary key
C Primary Central
D Primary Key
34. What is the output when the information ―Strange cardinal' is set to the text format > in Access?
A strange cardinal
B Foreign Key
C Foreign Key
D Strange key
35. What is the reason for not accepting zero in the fields of Access tables?
A Fields is fix with is Zero or > 0
B Fields is prepare with is Nix or < = 0
C Fields is set up with is Null or! [0]
D Fields is set up with is Nothing or like ―?‖
36. Which field type will y'all select when you need to enter long text in the field?
a) Text
b) memo
c) currency
d) hyperlink
37. The expression architect is access tool that controls expression ____ for entering expression
a) Table
b) Box
c) Cell
d) Palette
38. Which of the post-obit is not blazon of MS Access database object?
a) Tabular array
b) Course
c) Worksheets
d) Modules
39. In which method nosotros don't need to specify the field type and size while creating a new table?
a) Design view
b) While using Wizard
c) Create Tabular array by entering Data
d) All of these
twoscore.Th size of yes/no field is always ______ .
a) 1 Fleck
b) 1 byte
c) ane character
d) 1 kb
41. The size of a field with number data type can non be ____
a) two
b) 4
c) 8
d) 16
42. What does the evidence cheque box in query design window indicate?
a) Information technology indicates whether the field is to be used or not.
b) Information technology indicates whether the field is to be displayed in query result or non
c) It indicates whether the field names to exist displayed in query result or non.
d) It indicates whether the field is to exist 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 tin create in MS Access ?
a) information technology is used to accept 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 Class
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 tabular array.
c) Information technology ensure that all the related records volition be deleted automatically when the tape from parent table is deleted.
d) It is used to delete all the records of related tables in a database.
46. The ______ push button on the tool box display information from a related tabular array.
a) Sub form sub report
b) Relationships
c) select objects
d) More controls
47. The control centre of MS access file that appears when we create or open the MS Access database file
a) Database window
b) Query window
c) Blueprint view window
d) switchboard
48. While creating human relationship using mouse, how the mouse arrow looks similar?
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
l. how can you ascertain a field so that when entering information #### is displayed?
a) Input mask
b) Validation rule
c) Indexed
d) Ime way
51. In the context of Microsoft access, which of the following argument is truthful?
a) Reports are used to remember and summate data from tables.
b) Queries can be printed and presented as the data
c) Queries tin can include calculated fields that do not exist in table
d) Reports and forms are like but forms are utilise to impress 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 proper 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) Command
55. Which of the following is not a type of relationship that can be applied in Access database?
a) 1 to one
b) One to many
c) Many to many
d) All of these
56. While creating human relationship, what happens when you release mouse arrow subsequently yous drop the primary central of a table into foreign key of another table?
a) A human 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 function of Cascade update pick ?
a) It says do non change the value in the primary primal field if that tape has related records in another tabular array
b) Information technology means modify 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 tabular array in MS Access ?
a) 3
b) ii
c) 1
d) 4
59. Which of the post-obit is a method to create a new table in MS Access?
a) Using Design View
b) Create Tabular array Wizard
c) Directly Entering Data
d) All of these
sixty. If you write criteria values i in a row in query pattern window, that means y'all are specifying
a) Or Conditions
b) AND Weather
c) NOT Weather
d) ALL weather
61. How tin can we create a query in Microsoft Access?
a) Elevate and drop fields
b) Type the SQL
c) Employ Query wizard
d) All of these
62. Which option allows usa to build a new table by inbound information straight into a tabular filigree?
a) Datasheet view
b) Design view
c) Linked Table
d) Grid view
63. What is the shortcut fundamental to switch between the field names and properties panels in table
blueprint view?
a) F3 primal
b) F4 primal
c) F5 central
d) F6 primal
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 utilise if nosotros are planning to shop a couple of paragraph or detailed clarification in a field ?
a) Text
b) Para
c) Memo
d) Desc
66. Which of the post-obit database object hold information?
a) Forms
b) Reports
c) Queries
d) Tables
67. When creating a new table which method can exist used to cull fields from standard databases and tables
a) create table in design view
b) create table using wizard
c) Create table by inbound
d) none of these
68. Which one of these is the near common blazon of query that retrieves records from i or more tables and so displays the result in tabular course?
a) Tabular Query
b) Crosstab query
c) Select query
d) pivot query
69. Microsoft Access is a _____ kind of awarding ?
a) RDBMS
b) OODBMS
c) ORDBMS
d) Network Database Model
70. Queries in MS Access can be used _____
a) To view data
b) Every bit source for forms
c) As source for Reports
d) All of these
71. The pocket-sized button with three dots displayed at the right of field properties box is called :
a) Make button
b) Expression Button
c) Congenital Button
d) None of these
72. Which of the following shows the concluding effect in a presentable way ?
a) Forms
b) Reports
c) Queries
d) Tables
73. In MS Access, how tin 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 whatever field from parent table and driblet on child tabular array
c) Elevate the primary key of a table into foreign cardinal of another table
d) Any of these tin be done to create human relationship
74. Which of the following store control to get together information from database ?
a) Forms
b) Reports
c) Queries
d) Tables
75. A search value in SQL query tin can be a specific value or information technology can exist _____
a) Logical Operator
b) Relationship
c) Wild carte Graphic symbol
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 human relationship)
b) Select the relationship line and printing delete
c) Choose Delete option from human relationship carte du jour
d) Choose remove option from human relationship menu
78. In MS Access to open new database press
a) Ctrl + Due north
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 downwardly
d) F9
fourscore. In MS Access to open an existing database press
a) Ctrl + Due north
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 written report in an Access database, that either displays a listing of values retrieved from a tabular array or query, or stores a static set of values.) list box or combo box
a) F4 or Alt + Downwards Arrow
b) Downwards 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 + southward
d) C or Esc
84. In MS Access press Alt + F11 to
a) Display the control menu
b) Display the shortcut card
c) Close the agile 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 human relationship button on the toolbar
c) Select Edit > Relationship from the carte
d) All of these
86. How can yous brandish Pivot table study 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 past 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 characteristic allows you to filter
a) Those records that match an entity in a field
b) Records based on a benchmark you specify
c) Records that meet any of several criteria you specify
d) All of these
89. How can y'all display sales grouped past country, region, and salesperson, all at the same time?
a) Use the sort descending command
b) Use the pivot table view command
c) Employ the fine command on specified group
d) All of these
xc. What is the memo data blazon field used for?
a) To add tabular array
b) To shop 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 information is called the
a) Validation of data
b) Verification of data
c) Cross check
d) Command of information
92. What is the purpose of the description column in Table Blueprint view?
a) To define the data type practical 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 information 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 grouping 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 written report
a) Concord down the shift key as you click each object that you desire to select
b) If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler higher up or to the left of the controls
c) Hold down the Ctrl key as you click each object that you desire to select
d) All of these
97. The following database object can you import from one MS-Admission database to some other?
a) Queries
b) Tables
c) Forms
d) All of these
98. What field type is used to shop picture in a table?
a) Memo
b) OLE
c) Hyperlink
d) None
99. Queries pattern window has ii parts. The upper part shows
a) Proper noun 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 phase in database design where one gathers and lists all the necessary fields for the database project.
a) Data dictionary
b) data refinement
c) information definition
d) none of these
103. This fundamental uniquely identifies each record
a) cardinal record
b) composite primal
c) strange fundamental
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 Admission?
a) Datasheet view
b) Pattern view
c) Both A and B
d) None of these
106. A _____ enables you to view data from a tabular array based on a specific benchmark
a) Query
b) Study
c) Grade
d) All of these
107. Which of the following database object produces the final outcome to present ?
a) Table
b) Reports
c) Queries
d) None of these
108. The database language that allows you to access or maintain information in a database
a) DML
b) DCL
c) DDL
d) TCL
109. What are the columns in Microsoft Access tabular array chosen?
a) Table
b) Reports
c) Queries
d) fields
110. The ______ operator will crusade a report to be selected only if ii 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 deportment like
a) Alter 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 information is
a) Record
b) Table
c) Field
d) Report
115. A database tin be best described as
a) Useful presentation of data
b) Organized drove of information
c) Graphical representation of data
d) None of these
116. Collection of related records in a database is known as
a) Record
b) Tabular array
c) Field
d) Report
117. The complete information almost an entity in a database is chosen
a) Record
b) Table
c) Field
d) Report
118. The task of arranging data in social club is chosen
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 strange key that uniquely identifies records
c) Fabricated up of 2 or more fields to uniquely place records
d) None of these
120. An organized collection of logically related information is known as
a) Data base
b) Meta information
c) Information
d) Information
121. HSAM stands for______
a) Hierarchic standard and method
b) Hierarchic Sequential and method
c) Hierarchic standard Admission method
d) Hierarchic Sequential Admission Method
122. In a database, what does each row correspond ?
a) Field
b) Database
c) Tape
d) All of these
123. What practise you call a primary cardinal field included in another table ?
a) Child key
b) Blended central
c) Parent key
d) Foreign key
124.Which data type is better to use for storing the price of an detail?
a) Number
b) Text
c) Currency
d) Hyperlink
125. The basic elements of a form or a written report are called :
a) Windows
b) Controls
c) Objects
d) Table
126. Which of the following information blazon 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 Admission ―Lookup Wizard‖ is used to
a) To select value from another table
b) To select values from Excel canvas
c) To select from previous values
d) None of the In a higher place
128. Which of the following is use to get data from user?
a) Query
b) Class
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 get out 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) Ability point files
c) Word files
d) Excel files
132. Queries tin exist created in Admission by
a) Using Query Magician
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 bring together between two records?
a) Inner join
b) Outer bring together
c) Correct outer join
d) None of these
134. Whatsoever report, including a basic report, can exist 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 divers 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 ii numbers.
a) Like
b) Between
c) Is Null
d) Equal
137. Database is besides chosen every bit ______
a) DBMS
b) RDMS
c) DDMS
d) None of these
138.In Admission data is stored in _____
a) Rows
b) Columns
c) Both A and B
d) None of these
139. The arrangement 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 only more_____
a) Lonely structured
b) Highly Structured
c) Non structured
d) None of these
143. Each tape in a table contain _____ keys.
a) Unique
b) Primary keys
c) Both A and B
d) None of these
144. OLE information object information blazon tin can store ______
a) Video clips
b) Pictures
c) Graph
d) All of these
145. Querying a database is a method of ______
a) Retrieving specific data
b) Displaying specific information
c) Both A and B
d) None of these
146. Sorting tin can exist washed in _______ society.
a) Ascending
b) Descending
c) Both A and B
d) None of these
147. Reports are required for presenting information on _______
a) Paper
b) On screen
c) Both A and B
d) None of these
148. Tree structured are used to stored data in
a) Network model
b) Relational model
c) Hierarchical model
d) File base arrangement
149. The dominion that a value of a foreign central must announced as a value of some specific table is chosen
a) Referential constraint
b) index
c) Integrity constraint
d) Functional dependency
150. ______ view permits selection of information types, default values and constraints for each column.
(a) Datasheet
(b) Design
(c) Report
(d) Form
151. A relation is in ______ if an attribute of a blended key is dependent on an attribute of other blended key.
a) 2NF
b) 3NF
c) BCNF
d) 1NF
152. What is information integrity?
a) It is the data contained in database that is non redundant
b) It is the information contained in database that is authentic and consequent
c) it is the information contained in database that is secured.
d) It is the data contained in database that is shared.
153. Which of the post-obit is not a database awarding?
a) dBase
b) Flash
c) FoxPro
d) Access
154. Which of the following is not a logical database construction?
a) Chain
b) Network
c) Tree
d) Relational
155. A ____ is a unit of measurement of data in a ______
a) tape, field
b) field, tape
c) data source, field
d) record, data source
156. Which type of field is increment automatically?
a) Auto Elevate
b) Automobile Number
c) Motorcar Increment
d) Machine Value
157. Which will display values in drop down box from another tabular array while inbound data….
a) Query wizard
b) Await up wizard
c) Course Wizard
d) Report wizard
158. A principal key in any table has the following properties
a) Not Nada
b) No Duplicates
c) Both A and B
d) None of these
159. What is the file extension of MS Access 2003?
a) .mdb
b) .mcb
c) .acc
d) .mcd
160. Which choice allows y'all to build a new table by entering data direct into the datasheet.
a) Datasheet view
b) design view
c) link table
d) None of these
161. Which central stoke is used to move the active jail cell towards right, in admission table?
A Ctrl + Tab
B Alt + Tab
C Tab
D Shift + Tab
162. Refresh push tin exist found in….
a) Create Tab
b) External Data
c) Domicile Tab
d) Database Tool
163. How can you protect your data with password?
a) From Macro
b) From database tool
c) From SQL server
d) From Datasheet tab
164. Which volition assistance to search information from database?
a) Queries
b) Froms
c) Reports
d) Macros
165. Which combination of key allows user to motion to the first field in the first tape in Access table?
A Ctrl + Tab
B Shift +Tab
C Shift + Abode
D Ctrl + Home
166. Which command rapidly locates the data is Access tabular array?
A Find
B Locate
C Search
D Edit
167. OODBMS stands for_______.
a) object oriented database management system.
b) order information base management arrangement
c) club base of operations management system
d) office data base of operations management system
168. MS Access creates files are stored with______ extension.
(a) .docx
(b) .xlsx
(c) .accdb
(d) .pptx
169. New database created in MS Access has got a default table named________ .
(a) Table1
(b) Database1
(c) Column1
(d) Row1
170. What tin be created to assistance easy data entry in MS Access tables.
(a) Form
(b) Report
(c) database
(d) spreadsheet
171. By default, beginning column of an MS Access table is named _______ and information technology has auto increase property.
(a) NAME
(b) Date
(c) Cipher
(d) ID
172. How can you edit a relationship already established between ii tables?
a) Correct click the relationship line and cull edit relationship
b) Double click the human relationship line
c) Both the in a higher place
d) None of the above
173. Which of the following database object hold data?
a) Reports
b) Tables
c) Forms
d) All of these
174. Full form of DBMS
a) Data base management system
b) Document Base Direction System
c) Digital Base Management Organization
d) None of these
PAID TEST Series:- HPSSSB JOA IT EXAM Test SERIES(x TEST WITH Reply Primal)
Source: https://www.himexam.com/2021/02/ms-access-mcq-for-hpssc-joa-it-exam.html
Posted by: pattersonackwoure.blogspot.com
0 Response to "Which Of The Following Can You Change In Datasheet View Of A Query"
Post a Comment