Class VIII

  CHAPTER 3: ACCESS – TABLES AND FORMS   D. 1. Define the following a) Sorting Sorting means arranging the records in a particular order, ascending or descending. b) Filtering Filter is used to review and analyze information in the database table   E. Answer in 1-2 sentences 1.   What is the use of toggle filter option? Toggle filter is used to cancel the applied filter and display all records.   2. What do you mean by relationship window? Relationship window is a special database view in which we can create relationships between tables.   3. Why do you mean by form? A form is a view of one or more tables which is used to enter, edit and display data.   4. What is the use of split form? Split form is used to show the form in two parts when the upper part shows the form and the lower part shows the datasheet for the table.   F. Answer briefly. 1. What is the use of Find and Replace feature in MS-Access? Find allows...

  CHAPTER 4: ACCESS – QUERIES AND REPORTS   D. 1. Differentiate between Major Key and Minor Key When we sort on more than one field the most important field is known as Major Key or Primary Sort Key while the less important field is known as minor key or secondary sort key   E. Answer in 1-2 sentences 1.   What do you understand by query? Query is a request for specific data from the database. The capability of querying a database is one of the most powerful database features   2. What do you mean by compound criteria? Compound criteria means applying more than one criterion to find the data we are searching.   3. Why do we need sorting? We need Sorting to arrange alphabetical/numeric data in ascending/descending order so that we can locate the required data quickly.   4. What do you mean by report? A report is a database object used to display data from a query or table in an appealing way.   F. Answer briefly. 1. Explai...