MS-ACCESS MCQ For HPSSC JOA IT Exam

Facebook
WhatsApp
Telegram

 

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) 







                                    Join Our Telegram Group

1000 HP GK MCQ QUESTION
Sorry this site disable right click
Sorry this site disable selection
Sorry this site is not allow cut.
Sorry this site is not allow copy.
Sorry this site is not allow paste.
Sorry this site is not allow to inspect element.
Sorry this site is not allow to view source.
error: Content is protected !!