Home

To create a new table, in which method you dont need to specify the field type and size?

A. Create table in Design View

B. Create Table using wizard

C. Create Table by Entering data

D. All of above

Correct Answer : C.


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. Queries in Access can be used as
  2. What is a form in MS Access
  3. Each record is constituted by a number of individual data items which are called
  4. What do you mean by one to many relationship between Student and Class table?
  5. To create queries in Access
  6. What do you mean by one to many relationship between Student and Class table?
  7. Which of the following can be an example of a database?
  8. The two form layout types will display multiple records at one time are tabular and___
  9. It is an association established between common fields of two tables.
  10. How can you link a table with another so that a field in current table will display values in drop down…
  11. The__ button on the tool box display data from a related table
  12. Which field type can store photos?
  13. Cascade update option
  14. A database language concerned with the definition of the whole database structure and schema is ________
  15. When entering field name, how many characters you can type in maximum?
  16. To achieve AND effect when you are entering criteria in a query design window
  17. An Access database object that is used to enter, view or edit records
  18. To create a new table, in which method you dont need to specify the field type and size?
  19. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  20. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  21. The database language that allows you to access or maintain data in a database
  22. To duplicate a controls formatting you can use___
  23. A __ name must be unique within a database
  24. Which of the following is not a type of relationship that can be applied in Access database
  25. A primary key in any table has the properties
  26. It is most common type of query. It retrieves records from one or more tables and then displays the
  27. It is a sign or symbol that specifies, operator, and values that produce a result
  28. We can remove a relationship defined between two tables by
  29. The size of Yes No field is always
  30. A part of database that stores only one type of data is