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. The__ button on the tool box display data from a related table
  2. In a database table, the category of information is called ____________
  3. To sort records in a table
  4. A database language concerned with the definition of the whole database structure and schema is ________
  5. A __ name must be unique within a database
  6. Which of the following is a method to create a new table in MS Access?
  7. Database Management Systems are featured with:
  8. The expression builder is an access tool that controls an expression___ for entering an expression
  9. Referential integrity means
  10. Which is not a view to display a table in Access?
  11. It is a database object to view, change, and analyze data in different ways
  12. What is the difference between Open and Open Exclusively?
  13. Collection of related records in a database is known as
  14. Which of the following statement is true?
  15. The third stage in designing a database is when we analyze our tables more closely and create a ___________…
  16. A part of database that stores only one type of data is
  17. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  18. To create queries in Access
  19. Which field type will you select when creating a new table if you require to enter long text in that…
  20. Both conditions display on the same row in the design grid when ___operator is in use
  21. In table design view what are the first column of buttons used for
  22. We can remove a relationship defined between two tables by
  23. An Access database object that is used to enter, view or edit records
  24. To duplicate a controls formatting you can use___
  25. Every table in relational database contain a field or combination of fields that can uniquely identify…
  26. When entering field name, how many characters you can type in maximum?
  27. Which of the following statement is true
  28. Which of the following database object hold data?
  29. The database language that allows you to access or maintain data in a database
  30. Which of the following is NOT a type of Microsoft Access database object?