Ms access
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state

Ms access questions with answers

448 multiple-choice questions. Open any question for its answer and explanation.

  1. the way a particular application views the data from the database that the applicaton uses is a
  2. In Access press . . . . . . . . to Cut the selected control and copy it to the Clipboard
  3. Which of the following is not a database object?
  4. In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)
  5. a computer language for informing the dbms regarding the data structure used is
  6. a subset of characters within a data field is known as
  7. Macros can recover from _______ in a controlled manner.
  8. A composite key is
  9. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
  10. Which setting you must modify to print a report using letterhead?
  11. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.
  12. Which of the following components has a property sheet that includes settings for the frame and the option group?
  13. In Access press UP ARROW or CTRL+UP ARROW
  14. In the Relationship window, related fields from each table are connected by a(n) _______________.
  15. Which of the following queries prompts users for input data by displaying dialog boxes?
  16. Which of the following is not a valid Data Type in MS Access?
  17. Which of the following is use to view or print the data in organized manner?
  18. What type of controls are text boxes when data from the recordset is visible?
  19. If I create 'Student' field in 'Fees' table to store 'student_id' of 'Students' table, then this 'Student' field in 'Fees' table is called
  20. Which of the following is use to get data from user?
  21. Which of the following statements about a tab control in a form is incorrect?
  22. In a query, using the keyword _______________ will return records in which the field value is between two numbers.
  23. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
  24. What is the purpose of the description column in Table Design View?
  25. Which field type can store photos?