Home

To create relationship between two tables

A. drag the primary key of a table into foreign key of another table

B. drag the foreign key of a table into the primary key of another table

C. drag any field from parent table and drop on child table

D. Any of above can be done to create relationship

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. A __________ enables you to view data from a table based on a specific criterion
  2. Queries in Access can be used as
  3. What do you mean by one to many relationship between Student and Class table?
  4. DCL provides commands to perform actions like
  5. The task of arranging data in order is called
  6. Which of the following is not a database object?
  7. A primary key in any table has the properties
  8. Which of the following creates a drop down list of values to choose from a list?
  9. When entering field name, how many characters you can type in maximum?
  10. To achieve AND effect when you are entering criteria in a query design window
  11. It is a database object to view, change, and analyze data in different ways
  12. It is an association established between common fields of two tables.
  13. A database can be best described as
  14. A database object in MS Access that stores a question about the data in database?
  15. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  16. What do you mean by one to many relationship between Student and Class table?
  17. The two form layout types will display multiple records at one time are tabular and___
  18. If you need to edit a relationship
  19. The command center of access file that appears when you create or open the MS Access database file.
  20. Database Management Systems are featured with:
  21. This is the stage in database design where one gathers and lists all the necessary fields for the database…
  22. We can remove a relationship defined between two tables by
  23. In table design view what are the first column of buttons used for
  24. If you write criteria values vertically (one in a row) it will mean
  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. An Access database object that is used to enter, view or edit records
  28. Which of the following is a method to create a new table in MS Access?
  29. Which of the following expresses correct order?
  30. What is the maximum length a text field can be?