Queries, Form and Report in Access ch-3 class 8th

A. Tick the correct answers.

1. Which of the following is not a database object?

Ans-Essay

2. Which of the following is not used while setting a relationship between the table?

Ans- answer ki

3. What is the general meaning of query?

Ans- question

4. Query,form and report Wizard option are available on which type?

Ans- create tab

5. Which view allow the user to change the appearance of a form?

Ans- form view

B. Fill in the blanks.

1. Parameter is a type of query.

2. The foreign key defines a relationship between the table.

3. Criteria row in a query design grid is used to set the condition.

4. The layout view button is present in the design view.

5. Report database object present data in the format required by the user.

C. Write true and false statement.

1. Columnar is the different layout for a form -false

2. Once a form is created it cannot be edited - false

3. Query design window is divided into two section -false

4. Access does not save reports form and queries -false.

5. Parameter is a type of query. True

D. Answer the following questions.

1. What is the utility of  relationship feature of MS Access?

Ans- When you use related tables in a query, the relationship lets Access determine which records from each table to combine in the result set. A relationship can also help prevent missing data, by keeping deleted data from getting out of synch, and this is called referential integrity.

2. What is query in Access question mark describe the use of option available in the query design grid.

Ans-  query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.

3. What do you understand by a form? List of formatting that can be applied to a form.

Ans- You can apply formatting to just about every element of your document, from a single character to entire paragraphs. Body text needs to be readable and easy on the eyes. Headings should be big and bold, and they should also be consistent throughout your document.

4. Explain the term report. State any two method to create a report in access.

Ans- The Report tool may not create the final, polished product that you ultimately want, but it is quite useful as a means to quickly look at the underlying data. ... On the Create tab, in the Reports group, click Report. Access builds the report and displays it in Layout view.

5. How are objects like query report and form beneficial in creating and organising a database? Explain

Ans- It helps to remember that they all work with the same data. Every piece of data a query, form, or report uses is stored in one of your database tables. Forms allow you to both add data to tables and view data that already exists.