Chapter :- 3 More About MS Access 2010

January 28, 2023 chinu

More About MS Access 2010

Buzz Words

1. Relationship:- It is a logical connection between two tables that specifies fields that the tables have common.

2.Query:- It helps to retrieve data from the database.

3.Criteria:- This is the condition on the basis of which the records will be filtered.

4.Form: It helps to enter and display data in a user-friendly format.

5.Report:- It displays data in an easy-to-read format which can be used for printing.

Fill in the Blanks

1. Query window is also known as Query Design Grid

2. A single table Query is actually just an advanced filter applied to a table.

3. In the Query window OR is used to specify multiple criteria.

4. We click on Run to view the restilty of a Query.

5. Forms is a user-friendly way to enter, edit and view data.

6. Reports are used to present data in a specific layout for printing purposes.

State Whether True or False

1. Data can be added in the Design View :- False

2. Tables related to different entities cannot be in the same database. :- False

3. A Query cannot display all fields of a table. :- False

4. We can form Kelationships between fields with different data types. :- False

5.We use the EQUAL operatir in the CRITERIA to filter the exactly same value. :- True

Multiple Choice Question.

1. The three tabs that appear during the creation of a form are

(i)Design, Arrange, Format

(ii)Design, Form Page

(iii)Design Arrange, Create

(iv)Design, Query, Report

2.The benefits of using Relationships are

(i) Consistency

(ii) Efficiency

(iii) Comprehensibility

(iv) All of the Above

3. Edit Relationship belongs to the group

(i) Forms

(ii) Macros

(iii) Tools

(iv) Tables

4. Database Objects that are displayed in the Navigation Pane are

(i)Table

(ii) Query

(iii) Form and Report

(iv) All of the Above

5. We can insert the following in a Report

(i)Images, Charts

(ii)Title Date & Time. Page numbers

(iii) All of the above

(iv) None of the above

6. Which of the following database object holds data?

(i)Forms

(ii) Reports

(iii) Queries

(iv) Tables

Match the Following

Answer briefly

1. Which new tabs appear on the ribbon when a report is created?

Ans :- Design, Arrange, Format, Page Setup.

2. Which are the two types of Queries? What is the difference between them?

Ans :- The Query Design and the Query Wizard. We will create a query from the Query Design as it gives you more control over a select query.

3. What is the significance of the link in a Relationship?

Ans :- Link establishes relationship between multiple tables

4. How does the OR criteria work?

Ans :- We use the OR criteria for such Queries, where any one of the criteria should hold true

5. How does the Edit Relationships dialog box help us!

Ans :- We can select the fi rst table name under Table/Query and the table to be related under
Related Table/Query. Select the fi elds to be related under the table names. Then click on Create.

6. Which new tabs appear on the ribbon when a Form is created?

Ans :- Design, Arrange and Format.

Answer the following Question

1. How is a Form different from a Report!

Ans :- REPORTS are used to present data in a specifi c layout for printing purposes. A FORM is
a database object that you can use to create a user interface for a database application. It
provides an easy and user-friendly way to enter, edit and view data.

2. Whatare the benefits of a Relationship?

Ans :- Consistency, effi ciency, comprehensibility.

3. Explain the procedure of analysing a database to form a Relationship.
Ans :- Let us create Relationships and connect the tables.

On the tab Database Tools on the Ribbon, in the Relationships group, click on the Relationships icon.

The Show Table window appears

The dialog box that appears shows the list of the tables
in the database. Select the table that you want to add
in the Relationship and click on the Add button. In this example, select both the tables one by one and click on Add.
When both tables are added, the Relationships tab displays both the tables with their fields

The Edit Relationships dialog box will appear. We
can select the fi rst table name under Table/Query and
the table to be related under Related Table/Query.
Select the fi elds to be related under the table names.
Then click on Create.

In this example, the table names are STUDENT and
MARKS, respectively, and the fi eld is ROLLNUMBER
in each of them.

The Relationships Tab shows the relation between the two tables by joining
STUDENT.ROLLNUMBER to MARKS.ROLLNUMBER.

On the Design Tab of the Ribbon, under the Tools group, click on Edit Relationships.

4. Mention the components of the Query Design Window
Ans :-

5.Describe the different types of criteria to form a Query.
Ans :- Specifying Simple Criteria Specifying Multiple Criteria like Criteria from more than one Field Criteria from any one Field among Multiple Fields
Multiple Criteria from a Single Field