1. What is Ms Access?
Ans.
Microsoft Access is a database management system which is used to collect,
store and manage information as well as run reports. In multi-user environment,
it uses file sharing mechanism. They are in different versions like Ms Access
98, Ms Access 2000, Ms Access 2003 etc.
2. What is a database? or Define
database
Ans. A database is an organized
collection of data or related information, which are shared and used for
multiple purposes. Example: Phone diary, data of S.L.C. examinations etc. Or
A database is a collection of data that
is organized so that its content can easily be accessed, managed and updated.
3. What is database management system
(DBMS)? Name some DBMS software.
Ans. A database management system is a
software package that manages data stored in the database. It allows the data
to be organized so that it can be easily accessed by application programs.
Some DBMS software are: DBASE, Oracle,
FoxPro, Ms Access, IMS, IDS, IDMS, ADBASE, SYBASE, FOXBASE, CDS/ISIS, OMNIS,
etc.
4. Write its advantages/features.
Ans. a) Easy to add new data
b) Easy to modify and delete the
database
c) Organizes the data in proper
sequence
d) Easy queries of data in database
e) Allow multiple users to be active at
a time
f) Protecting data against unauthorized
access
5.
Define the terms: Entity, Attribute, relationship and File.
Ans. Entity: An entity is a thing of
interest to an organization about which data is to be held.
Eg.
Customer, supplier, employee etc.
Attribute: An
attribute is the property or characteristics of an entity. Eg. ID, Name,
Address, etc.
Relationship: It is
a link or association between several entities within tables. There are three
types of relationship like one to one, one to many and many to many
relationships between several entities.
File: A
file is collection of related records that are treated a single unit. For
example, a student information system contains an information of students like
Regd.no., Name, Address, etc. A database of Hospital contains an information
about the patients, doctors, staffs, etc.
6.
Define the term Table.
Ans. A
table is a part of database. It consists of rows and columns, which is the
storage of database. Columns of a table
are Fields and rows of a table are Records.
7.
Define Tuple.
Ans. A
record row in the database is called tuple.
8.
Define Field and Record.
Ans.
Field: A field is a piece of information about an element; element may be a
person, student or employee.
Record:
A collection of related field is called record. That contains in a row.
9.
What is data type? Name various data types.
Ans.
Data type is the type which is used to declare variable names, variable types
& its size for further operation. They are:
a.
Text
b.
Memo
c.
Number
d.
Date/Time
e.
Currency
|
f.
Yes/No
g.
Auto Number
h.
Lookup Wizard
i.
OLE object
j.
Auto Number
|
10.
List various field properties.
Ans.
Various field properties are:
a.
Field Size
b.
Format
c.
Caption
d.
Default value
|
e.
Validation Rule
f.
Validation Text
g.
Input Mask
|
11.
Differentiate between Text and Memo.
Ans.
Differentiations between Text and Memo are:
Text: It is
a data type which can include characters, numbers and symbols. A text field
contains up to 255 character.
Memo: It is
also a data type which can include numbers, characters or alphanumeric. Memo
field can store up to 64,536 characters.
12. What
are the functions of the following data types?
Ans.
See your text book. Page.
13.
What is Field size? Why is it used?
Ans.
Field size is a part of the properties box for the particular data type. It is
used to fix the number of characters for text field. For number field, users
can choose one mode from predefined mode like byte, single, double, etc.
14.
What is the use of Format property?
Ans.
Format property is used to set the formats of Text, Date/Time, Number,
Currency, etc.
15.
What is primary key?
Ans. A
primary key is one or more columns in a table used to uniquely identify row in
the table. It doesn't accept null and repeated value.
A
multicolumn primary key is called Composite Primary key.
16. Why is a primary key used?
Ans. A primary key is used to deny (refuse) the
repetition of data (or duplicate data). Primary key is declared for unique
field. Eg. Student_code, Staff_ID, etc.
17.
Define Sorting and Filtering in Access.
Ans. Sorting: Sorting means arranging the database
in ascending or descending order so that the information could be easily
found.
Filtering: Filtering database means showing only
particular database according to the requirements.
18.
What do you mean by formatting table?
Ans.
Formatting table means changing Column
width,
Row height, hiding column of table and changing stored data's font, size &
style, etc.
19.
What are the ways or methods of creating table?
Ans. There are three ways of creating table. They are:
a.
Data Sheet View b. Design View c. Table Wizard
20.
Define a Query. Mention the methods or ways to create Query.
Ans.
Query is one of the most important objects of Ms-Access for processing raw data
to get meaningful information. We use queries to view, change and analyze data
in different ways. Ways or Methods of creating queries are: (a) Design View (b) Simple Query Wizard (c) Crosstab Query Wizard.
21.
What are the types of Queries?
Ans.
The types of queries are:
a)
Select Query
b)
Crosstab Query
c)
Make-table Query
d)
Update
e)
Append
f)
Delete
22. What is Form? Mention the methods of creating it.
Ans.
Form is an object of the Access used for entering data. We enter data through
the form and store into table, which is used for making form. Methods for
creating forms are:
a.
Auto Form b. Design View c. Form Wizard
23.
Define Report. Write any two methods for creating report.
Ans.
Report is an object of Access, which is used to print stored data of table or
query results as a user's requirements. Any
two methods for creating reports are:
a.
Report Wizard b. Design View c. Auto Report
24.
What is a search?
Ans.
Search is a feature in Access, which allows to find the particular records from
database.
25.
Name the objects of Access database.
Ans.
Objects of Access database are:
a.
Table
b. Query c. Form d. Report
26.
What is cell?
Ans. A
cell is an intersection of rows and columns. It is the place where an actual
information contains.
27.
What are the components of application windows of Access?
Ans.
The components are as follow:
a)
Title bar b) Menu bar
c)
Standard bar d) Status bar
28. Differentiate between database and DBMS.
Ans. Differentiation between database and DBMS are:
Database
|
DBMS
|
a)
It is collection of data or related information.
b)
It consists of data.
c)
It is a part of DBMS.
d)
Examples: Phone book, data of S.L.C. exam, data of hospitals, etc.
|
a)
It is a software package to manage database.
b)
It manages data stored in database.
c)
It is a software system which contains database.
d)
Examples: FoxPro, dBase, Access, etc.
|
Ans.
The operators used in Access are:
a)
Arithmetic operator
b)
Conditional operator
c)
Logical operator
30.
Define the following terms:
a)
Data Redundancy b) Data
Processing
Ans.
a) Data Redundancy: Data redundancy means the repetition of data in database.
b)
Data processing: Data processing is the term given to the process of collecting
data together and converting them into information.
31.
Define the following terms:
a)
Caption b) Validation
rule
c)
Validation text d) Default value
Ans.
a)
Caption: It displays alternative name for the field in the data sheet, form,
report.
b)
Validation rule: Limits the field value to specific values or range of values.
c)
Validation text: The text displays when the field violates the validation rule.
d)
Default value: Automatically inserts the specified value in the field. Default
value for a Text field
is an empty string; for number or currency, 0.
is an empty string; for number or currency, 0.
32.
Define the term Data and Information.
Ans. Data: Data can be defined as raw
facts collected from various sources.
Information:
Information is data which has been converted into a more useful or
understandable form. Or information is processed data.
33.
What is the importance of computerized database in comparison to
non-computerized database?
Ans.
the importance of computerized database than non-computerized database are:
a) Possibility
of data redundancy (repetition) is not in computerized database than
non-computerized database.
b)
Searching, editing, deleting or printing etc. functions are easily and
instantly done in computerized database in comparison of non-computerized
database.
34.
Why table is needed for creating form?
Ans.
Table is needed for creating form because table is the place where all the data
are stored.
35.
Differentiate between data and database.
Ans. Data:
Data can be defined as the facts related to people, places, events or objects.
It can be denoted by letters, digits, etc . Examples: Name = Ram, Age = 15,
English = 45, etc.
Database:
A database is an organized
collection of data or related information, which are shared and used for
multiple purpose. Examples: Phone diary, data of S.L.C. exam, data of hospital,
etc.
who is the owner of this site?
ReplyDelete