What id data?
Data consists or raw facts and figures,
Data consists of letter, sound, image or video within the computer.
What is information?
Processed data is known as information.
Using a data base program or software, they are converted into the meaningful
result called information.
What is database?
A database is a collection of
interrelated data. It refers to an organized collection of data stored on a
computer in such a way that its content can easily be accessed, updated and
queried upon with the help of a software program.
Example = Banks must have systems for
keeping track of customers and their accounts.
What is rdbms (Relational Database Management System)?
Relational Database Management System
(RDBMS) is method of viewing information from several, separate database that
relate to one another through the keyword or values. The main advantage of
RDBMS is that we can simultaneously use more than one database to see
information stored in them.
List importance of database
Database stores the data.
Computerized database saves data from
being lost.
Computerized database protects from
unauthorized access and use of the data.
Data can be stored in a small area or
space in computerized database.
What is dbms? Write its types.
A database management system is a
collection of programs that enables you to store, modify, and extract
information from database.
Any four database management systems are as follows:
- Relational Database Management System
- Hierarchical Database Management System
- Network Database Management System
- Object Oriented Database Management System
Write advantage of database.
- The advantages of database are as follows:
- Database saves the data.
- Data can be stored in a small area or space in computerized database.
- Database protects from unauthorized access and use of data.
- It saves data from being lost.
List feature of dbms
- Easy to access data
- Ease to modify data
- Delete existing data.
- Organize the data in proper sequence.
- Sorting and indexing of data.
- Easy queries in data.
- Retrieve the data easily.
- Print the formatted reports, labels etc.
- Linking between two or more databases.
- It can be used as SQl (Structured Query Language)
What is ms-access?
Microsoft Access is a Relational
Database Management System which comes as an integral part of the MS Office
Suite of applications.
What is data shorting?
The process of arranging the data
smallest to largest and largest to smallest in table or in ascending or
descending order is known as data sorting.
What is query?
Query is a way of extracting information
from a database, usually by using certain criteria or requesting certain data.
It is request for database records that fit specified criteria.
What is the use of query?
The uses of query are as follows:
i. A query can count the amount of
records that meet the certain criteria.
ii. It can also be used to extract data
to a separate table or delete data, change data and many other things.
What is select query?
Select query is a query in which the
relevant data from a table is selected and displayed. It allows the user to
retrieve data from one or more tables and displays the results in a datasheet where
the user can update the record.
What is parameter query?
Parameter query is a query that when run
displays its own dialog box prompting the user for information, such as
criteria for retrieving records or value the user want to insert in a field. For
example: the following criterion selects records for which the records for
which the value for the Obtain_mark field is greater than 70: Obtain_mark>70
What is a dynast?
A dynast is a set of data that is
dynamically linked back to the database. Instead of having the query result
stored in a temporary table, where the data cannot be updated directly by the
user, the dynast allows the user to view and update the data contained in the dynast
What is attributes?
Attributes refer to a single data item
related to a database object. The database schema associates one or more
attributes with each database entity.
Explain different type of query
The different types of queries are as follows:
a. Select query = It is a query in which
the relevant data from a table is selected and displayed. It allows the user to
retrieve data from one or more tables and displays the results in a datasheet
where the user can update the record.
b. Parameter queries = It is a query that
when run displays its own dialog box prompting the user for information, such
as criteria for retrieving records or value the user want to insert in a field.
c. Crosstab queries = A query that
calculates a sum, average, count, or other type of total for data that is
grouped by the two types of information is known as crosstab queries.
d. Action queries = A query which
performs an action with the records /fields selected by the query. Action
queries includes delete, Append, update and make table queries.
Explain different object of MS-access.
a. Table = Table are the core database
object, used to store information. The tables are the containers for all the
data in a database. In a table, data are arranged in a columns and rows.
b. Queries = Queries means to ask
question about the data presented in the table. BY using queries, we can view
records or data, modify the content of table and a lot more. It is a way of
retrieving and editing information according to the condition asked. It is a
strong tool using in searching of desired data from database.
c. Forms = A form is a database object
used to enter and edit data in a table. Form can be used to edit the records of
underlying tables or to enter new records.
d. Reports = A report is especially
formatted collections of data organized according to our specification for
summarizing and printing. They are the means to present the information as a
printed document.
e. Macros = When macro is executed, it
executes one or more database commands automatically. They are meant for
automating the task that is done over and over again.
f. Modules = Modules are pieces of code
used to impose particular behaviours to your application programmatically. They
are more flexible and extensive than macros, although they are usually written
for various and particular circumstances.
Explain different data types of Ms Access
The different data types are as
follows
Text = A text field contains up to 255 characters or
it can set the length in the field size, text data type can include numbers
letters and symbols.
Memo = This type of field holds an unlimited amount
of text. It can accommodate 65, 535 characters.
Number = This type of field allows only the
numbers to be entered.
Date/Time = This field type only allows date and
time to be entered. It occupies 8 bytes.
Currency = This field allows to enter currency.
AutoNumber = This type automatically generates and
insert the unique number in the new row.
Yes/No = It allows the user to select Yes or No
when completing the field.
OLE object = It allows to link to binary data or
files.
Hyperlink = It allows to create a hyperlink. It
stores up to 64,000 characters.
Lookup Wizard = The lookup wizard creates a field that
allows the user to choose a value from a list of values by using a list box or
combo box.
Write difference between filter & query.
Filter
- A filter cannot be saved as separate object.
- A filter cannot be used for displaying the records of more than related table at once.
- A filter cannot be used for performing calculation on values of numeric fields.
Query
- A query can be saved as separate object.
- A query can be used for displaying the records of more than related table at once.
- A query can be used for performing calculation on values of numeric fields.
Write differences between primary key and foreign key
Primary Key
- It is a column or a set of column that can be used to uniquely identify a row in a table.
- A table can have a single primary key that can reference different tables.
Foreign Key
- It is a column or a set of column that refer to a primary key or a candidate key of another table.
- A table can have multiple foreign key that can reference different tables.