Home

Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

A. Foreign key

B. Native key

C. Composite key

D. Primary key

Correct Answer : D.


Download Objective type questions of Microsoft Access PDF

Visit our PDF store

Get all objective type questions of Microsoft Access MCQ

You can do it
  1. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  2. Which of the following statement is true
  3. DCL provides commands to perform actions like
  4. In table design view, which key can be used to switch between the field names and properties panels?
  5. The command center of access file that appears when you create or open the MS Access database file.
  6. To create relationship between two tables
  7. When creating a new table which method can be used to choose fields from standard databases and tables
  8. Every table in relational database contain a field or combination of fields that can uniquely identify…
  9. A search value can be an exact value or it can be
  10. Which of the following database object hold data?
  11. A __ name must be unique within a database
  12. If you write criteria values vertically (one in a row) it will mean
  13. A __________ enables you to view data from a table based on a specific criterion
  14. This data type allows alphanumeric characters and special symbols.
  15. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  16. What is the maximum length a text field can be?
  17. Queries in Access can be used as
  18. What do you mean by one to many relationship between Student and Class table?
  19. The complete information about an entity in a database is called
  20. Which of the following is not a type of relationship that can be applied in Access database
  21. Which of the following is not a field type in Access
  22. It is a database object to view, change, and analyze data in different ways
  23. When entering field name, how many characters you can type in maximum?
  24. A small button with three dots usually displayed at the right of field properties box
  25. It is most common type of query. It retrieves records from one or more tables and then displays the
  26. Cascade update option
  27. To sort records in a table
  28. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  29. A primary key in any table has the properties
  30. After entering all fields required for a table, if you realize that the third field is not needed, how…