Home

It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,

A. Parameter

B. Select

C. crosstab

D. Append

You can do it
  1. Following is not a database model
  2. A small button with three dots usually displayed at the right of field properties box
  3. A __________ enables you to view data from a table based on a specific criterion
  4. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
  5. Which of the following is not a type of relationship that can be applied in Access database
  6. Cascade update option
  7. An Access database object that is used to enter, view or edit records
  8. The size of a field with Number data type can not be
  9. If you need to edit a relationship
  10. A database can be best described as
  11. This option allows you to build a new table by entering data directly into the datasheet.
  12. Unlike text data type, this can store up to maximum of 65, 535 characters.
  13. Which of the following is NOT a type of Microsoft Access database object?
  14. You can set a controls border type to make the border invisible.
  15. When a picture or other graphic image is placed in the report header section it will appear____
  16. To create primary key for a table when in design view
  17. Which of the following creates a drop down list of values to choose from a list?
  18. We can remove a relationship defined between two tables by
  19. Which of the following is a method to create a new table in MS Access?
  20. The default and maximum size of text field in Access
  21. Collection of related records in a database is known as
  22. It is most common type of query. It retrieves records from one or more tables and then displays the
  23. Which field type will you select when creating a new table if you require to enter long text in that…
  24. Which of the following term is least related to database?
  25. It is a database object to view, change, and analyze data in different ways
  26. A database language concerned with the definition of the whole database structure and schema is ________
  27. If you write criteria values vertically (one in a row) it will mean
  28. The expression builder is an access tool that controls an expression___ for entering an expression
  29. We can remove a relationship defined between two tables by
  30. Query design window has two parts. The upper part shows