MS-ACCESS MCQ For HPSSC JOA IT Exam

 

MS-ACCESS MCQ For HPSSC JOA IT Exam


TEST SERIES:- HPSSC JOA IT Daily Test 2021 (TOTAL TEST 5 WITH ANSWER KEY


MS-ACCESS MCQ For HPSSC JOA IT Exam


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) 







                                    Join Our Telegram Group


Tags

Post a Comment

0 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.

Top Post Ad

Below Post Ad