Class-8 Chapter-3 computer

 

Computer Chapter-3

Advcnce features of ms access 2013

A.Answer the following questions:-

Que1. what do you mean by a report?
Ans1.  A formatted and organized presentation of data. Most database management systems include a report writer that enables you to design and generate reports.

Que-2 What is a form? What is it used for?

Ans-2  A form in Access is a database object that you can use to create a user interface for a database application.

Que-3 how many types of views are there in a report? Explain in detail.

Ans-3. There are four types of  views in a report

1.Forms are used for entering, modifying, and viewing records.

2. Queries are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database.

3. Reports offer you the ability to present your data in print.

4. Table is a database object which is used to store information in a organised manner.

Que-4 what is query design grid ?  

Ans-4 The query design is a visual representation of the families, fields, and criteria that the query is configured to return. When designing a query, you can customize it to return specific records using specific formatting and criteria. 

Que-5 What is a form?  

Ans-5 A form in Access is a database object that you can use to create a user interface for a database application. A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source.