MS Access| Set-1

MS-Access

You can practice in this section  operating system MCQ which is important for exam point of view.

1
Created on By GyanBazar

MS-Access

MS Access Set-1

You can practice in this section  operating system MCQ which is important for exam point of view.

1 / 50

Category: MS-Access

1. Which of the following term is least related to database?

2 / 50

Category: MS-Access

2. Which of the following database object hold data?

3 / 50

Category: MS-Access

3. Which operator is used to filter and display rows when all (two or more) conditions are satisficed ?

4 / 50

Category: MS-Access

4. The size of yes/no field is always ________

5 / 50

Category: MS-Access

5. In MS Access, how can we create relationship between two tables ?

6 / 50

Category: MS-Access

6. In the context of Microsoft Access, which of the following statement is true?

7 / 50

Category: MS-Access

7. How many characters you can type in maximum while writing the field name?

8 / 50

Category: MS-Access

8. What is a form that we can create in MS Access ?

9 / 50

Category: MS-Access

9. Which of the following is not a type of MS Access database object?

10 / 50

Category: MS-Access

10. Which kind of query that displays its own dialog box prompting you for entering information before executing ?

11 / 50

Category: MS-Access

11. Which field type will you select if you need to enter long text in that field?

12 / 50

Category: MS-Access

12. The expression builder is an access tool that controls an expression___ for entering an expression

13 / 50

Category: MS-Access

13. Which of the following data types automatically generates a consecutive number?

14 / 50

Category: MS-Access

14. Which of the following is not a type of relationship that can be applied in Access database?

15 / 50

Category: MS-Access

15. You define a field so that when entering data ##### is displayed?

16 / 50

Category: MS-Access

16. The  filter by selection allows you to filter those records

17 / 50

Category: MS-Access

17. What is the role of Cascade Update option ?

18 / 50

Category: MS-Access

18. Which feature is used to duplicate a control's formatting ?

19 / 50

Category: MS-Access

19. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?

20 / 50

Category: MS-Access

20. Ho can you edit a relationship already established between two tables?

21 / 50

Category: MS-Access

21. The columns in a micro-soft access table are also called _______

22 / 50

Category: MS-Access

22. A database object in MS Access that stores a question about the data in database?

23 / 50

Category: MS-Access

23. Which of the following database object can be used if you need to mail the invoice to customers?

24 / 50

Category: MS-Access

24. While creating relationship using mouse, how the the mousepointer looks like?

25 / 50

Category: MS-Access

25. Which of the following is a method to create a new table in MS Access?

26 / 50

Category: MS-Access

26. Which of the following option creates a Drop Down List of values ?

27 / 50

Category: MS-Access

27. The Input Mask wizard does NOT include the ability to do which of the following?

28 / 50

Category: MS-Access

28. What does the show check box in query design window indicate ?

29 / 50

Category: MS-Access

29. 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?

30 / 50

Category: MS-Access

30.

Which of the following expresses correct order?

31 / 50

Category: MS-Access

31. Which of the following is not a field type in Microsoft Access ?

32 / 50

Category: MS-Access

32. 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 ?

33 / 50

Category: MS-Access

33. Which option allows us to build a new table by entering data directly into a tabular grid ?

34 / 50

Category: MS-Access

34. In which method we don't need to specify the field type and size while creating a new Table?

35 / 50

Category: MS-Access

35. How can we remove a relationship defined between two tables ?

36 / 50

Category: MS-Access

36. A search value in SQL query can be a specific value or it can be _______

37 / 50

Category: MS-Access

37. When creating a new table which method can be used to choose fields from standard databases and tables

38 / 50

Category: MS-Access

38. The small button with three dots displayed at the right of field properties box is called...

39 / 50

Category: MS-Access

39. Which field type can store photos?

40 / 50

Category: MS-Access

40. The_____________ button on the tool box display data from a related table

41 / 50

Category: MS-Access

41. The most popular commercial DBMS.

42 / 50

Category: MS-Access

42. What Cascade Delete option is used for ?

43 / 50

Category: MS-Access

43. What is the shortcut key to switch between the field names and properties panels in table design view?

44 / 50

Category: MS-Access

44. what is the maximum length of a text field ?

45 / 50

Category: MS-Access

45. The size of a field with number data type can not be _____

46 / 50

Category: MS-Access

46. Microsoft Access is a ______application ?

47 / 50

Category: MS-Access

47. Which of the following shows the final result ?

48 / 50

Category: MS-Access

48. How can we create a query in Microsoft Access ?

49 / 50

Category: MS-Access

49. Both conditions display on the same row in the design grid when ________operator is in use

50 / 50

Category: MS-Access

50. What is the default and maximum size of text field in MS Access?

Your score is

The average score is 2%

0%

Leave a Reply

Your email address will not be published. Required fields are marked *