Class-8th
Subject – Computer
L-5 Log on to Access
A. Fill in the blanks:-
1. Ms Access is a Relational
database Management System
2. A database stores vast amount of data .
3. Reports collect the summarised data from one
or table / queries
4. All the columns in a table are called field .
5. It has a field name 'ID', which is considered
the primary key .
B. Write short notes on :-
1. Forms
Ans: Forms are the user friendly interfaces that facilitate the
process of entering data in tables and queries. A form has an attractive
interface that accepts data from the user and forwards it to the corresponding
table query.
2. Report
Ans: Reports are used to display selected data in a printable format.
Reports collect the summarized data from one or more table/ queries and
organize it in a printable form.
3. Queries
:
A database stores vast amount of data, but queries help
us to retrieve the filtered data based upon some conditions. Queries are also
used to perform actions, such as delete, update, on the data , based upon some
criteria (conditions).
C. Short Answer question
1. What is Database Management System.
Ans:
A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage
data in a database. A DBMS generally manipulates the data itself,
the data format, field names, record structure and file structure. It also
defines rules to validate and manipulate this data
2. Difference between the relationship and design
view
Ans:
|
Relationship |
Design View |
|
A relationship in Access helps you
combine data from two different tables. Each relationship consists of fields in two
tables with corresponding data. ... When you use related tables in a query,
the relationship lets Access determine which records from each table to
combine in the result set. |
In this view, the records are not
visible. You can see all the field names along with their data types. Here,
you can add or delete a field name (if you want). The changes in the field
name will be incorporated in your table where you can enter records. |
3. Can you create more than one table in the same database? Explain
Ans:
No comments:
Post a Comment