Class 8 Chapter 5 More About Access 2013

 Class VIII

Chapter 5

More About Access 2013

A. Tick the correct answer and fill in the blank. 

1. two. 

2. Query. 

3. Tables. 

4. Create.

B. Name these icons. 

 

C. Match the following.

 

D. Answer in short. 

Que 1. Name the database objects of Access.

Ans - Table, query, form and reports.

Que 2. Define the term –Table. 

Ans – Tables is the fundamental data building blocks of a data base.

E. Answer in detail. 

Que 1. How do you create a form in Access 2013?

Ans - To create a form– 

Step 1: Select the Table/Query whose form is to be created. 

Step 2: Click on Form in the Forms group of the Create tab. This will create and open a form in the Layout view. 

Step 3: Click on View in the Design tab and choose Form View. The form view opens. The form view can be used to feed new records or edit existing ones. 

Step 4: Save the form.

Que 2. Define query, form and report?

Ans – Queries are the database objects which help to display selective records or fields from the single or multiple tables related with each other. 

Forms are the database objects which help not only to enter the data in the tables but also to search or modify the data values stored in the tables. 

Reports are used to show information from the tables or queries in a printable form. 

Que 3 Explain the design grid of the Query window.

Ans - The Query window is divided into two panes. The top pane displays the tables selected for the query. The bottom pane displays options to add fields and specify the criteria. It has following options: 

Field: to display the fields from the selected table. 

Table: to display the name of the table. 

Sort: to arrange the data in ascending or descending order. 

Show: displays a check mark which means the field will be visible when the query is run. 

Criteria: to specify the condition on the basis of which the records will be filtered.

Que 4. What is the difference between AND condition and OR condition ?

Ans - When we type two criteria on the same line, only records where both criteria are met will be displayed when we run the query. This is called AND condition. When we type one criteria on the Criteria row and the second criteria on the Or row, the records where either criteria are met will be displayed as output. This is called OR condition.

Que 5. Is it  possible to extract information based on more than one condition in a single query? If yes, how?

Ans – Yes it is possible to extract information based on more than one condition in a single query. To set multiple criteria 

Step 1: Start a new query in design view and add the table in Query window from which the data to be extracted. 

Step 2: Add the required fields to the query grid. 

Step 3: Click in the Criteria section of the field and enter the required condition (AND or OR). 

Step 4: Now, Run the query to see the resultant query which shows only selective records.