Data are the any raw facts and figures collected fromdifferent sourceslikestaticalreports,queries, etc. whichmay not be significanceby itself.
Information is the processed data or organizeddata which give a complete sense.

A database is a collection of data related to a particularsubject or purpose which are organizedin easilyaccessible manner.
Any three database are:
-The telephone directory.
-Mask ledger.
-Encyclopedia dictionary.

A database is the collection of data related to a particularsubject or purpose. Database is the variable content ofdifferentdata in which data of different field are stored.The data storedin a database has to be changed time andagain one after another. The old one need to be replacedby new or latest one. As a result, to change the data ofthe database as our requirement, we need to update thedatabase regularly.

The system or mechanism that allows us to create, organize ormodify a database and retrieve information is calledDBM.
Any four DBMS software are:
-ORACLE
-MS- Access
-DBASE.
-FOXPRO, SYBASE, clipper, etc.

The difference between the Database and DBMS are:

Database	DBMS
It is the collection of data related to a particular subject or purpose.	It is the system that organize the information of the database.
It is the content of DBMS.	It is the handler of database.
It is the bunch of information.	It is the software.

The advantages of computerized database over manualdatabase are:
-Large amount of data can be stored and handledproperty & easily in computerized database.
-It is easier to retrievethe required data.
-Updating data is easier and faster.
-It allows and avoid the data duplicationas required.
-Data are highly secure in computerized database.
-Database can be handled onlyby authorized users.
-It is easier to send, transfer the database.
-It is theportable database.

RDBMS is the database management software thatallows us to distribute, manage and retrievedata fromthe linked multiple tables.
Any two RDBMS software are:
-MS-Access.
-Oracle,SQL Server, etc.

MS-Access is the RDBMS that allows us to manage thedata distributed in multiple tables and link these multipletables on the basis of key field and formation can beretrieved from the multiple tables.
Any four objectsof MS-Access are:
-Tables
-Query
-Foam
-Report

The file that stare all the setsof components or objectsof MS-Access in order to manage the database iscalled database file.
Its extension is .ACCDB.

Table in MS-Access is the primary building blockof a database which is used to store collection ofrelated data of a specific topic, purpose or subject.It is also called the container of database because allthe data are stored in tables.
We know, table is considered as the container ofdatabase as it store all the data of the data base.The datato be stored in the database are diverse andshould be stored under various field topic for whichdifferent tables are required. Hence, to meet the...

All the data to be stored in database are stored in tables.It is also called the container of the database.

The term field can be defined as the column of thetable of database which stores a particular category ofdata. Each field gives particulartype of data of an entity.
The term record can be defined as the row of a tableof database which consists of the related data of a person orthing. Each record gives complete information of aperson or thing.

The unique name that identifies data stored in the fieldis called field name.
The rules of naming fields are:
-Field name can be up to 64 characters long.
-Field name can contain letters, numbers, spaces orpunctuation marks.
-Field name cannot contain a period (.), accent grave (~),square bracket [ ] and exclamation mark ( ! ).
-Field name cannot begin with space.
-Field name must be unique in the table.

The characteristics of the field that determines what kind of data it can store is known as field data type.
The list of datatype that can be used is M-Accessare:
- Text
- Memo
- Number
- Date/Time
- Currency
- Auto Number
- Yes/No
- Attachment
- OLE Object
- Hyperlink
- Lookup Wizard

The difference between Text and Memo field data typeare:

Text	Memo
It stores alphanumeric characters.	It stores long alphanumeric characters.
It can hold up to 255 characters.	It can hold up to 65535 characters.
It is used to input name, address, etc.	It is used to input short description.

The primary key is a field or group of field that has aunique value in each records. The primary keyensures that unique data is entered for a field andthe field is not left blank (null).

The importance of the primary key in the tableare:
-It helps to ensure that fields not remained null.
-It helps to identity unique data entered.
-Ithelps to set relationship between tables.
-It helps stop duplication of therecord in a table.

A foreign key is a field in the child table that refers the primary key of a master table that allows us tostore duplicate data but does not allows us to leavethe field blank (null).
Foreign key is used for:
-Avoiding the field to be let null.

The table design view that is used to create and organizethe structure of database objects like tables, queries, formsand reports.
Its panes are:
-Field grid pane.
-Field properties pane.

Field property is the pane where it displays a listof properties associated with each field data type.
Captain is associated worth all the data types.

The captain field property is the field property thatallows us to assigna descriptivename for a field name.
The maximum number of character that canbe used in a caption is 2048 characters long.

The field size propertyis the field property thatallows us to set the maximum size for data storedin a field.
The default field size of a text field is 50characters.

Different subtypes of number fields are:
-Byte
- Integer
- Long Integer
- Single precision
- Double precision
The default size of a number field data typeis -2 billion to + billion.

The difference between Format and Input mask field are:

Format field	Input mask field
It specifies layout of a field.	It specifies a pattern for all data to be entered.
It changes the appearance of data.	It control the manner in which data is entered.

The process of checking whether entered data meetscertain conditions or limitation or not is datavalidation.
Its importanceare:
-It helps us to be confirmed about the data.
-It helps us to limit theinput ranges.

Indexing is the process of setting up theindexedproperty that speed up searching and sorting in atable based on key values:
The different indexing options available in MS-Access table are:
-No -----> No indexing.
-Yes (No duplicates) -----> Indexing with no duplicates.
-Yes(DuplicatesOK) ------> Indexing with duplicates.

Default value is the property that specifies thevalue which is automatically entered in a particularfield when the new record is added.

Theprocess of arranging the records in increasingor decreasing order is meant by sorting records.

The process of viewing required records of the tablethat satisfiesthe specified criteriais meant byfiltering records.

Query in MS-Access is the important object or dataprocessing tool of MS-Access that retrievesand displaysrecords based on specific conditions.
Its use in database are:
-To view specific fields.
-To analyze data of table.
-To perform mathematicalcalculation on data.
-To perform mass update, delete or append newrecords to a table.
-To create new table with records ofone or moretables.

The differences between Filter and Query are:

Filter	Query
It helps to select and view the record that satisfies certain criteria.	It helps to add, delete or append the records based on specific conditions.
It only display the records.	It retrieves an display the records.

The queries used on MS-Access are: - Select Query: retrieve and display the selected records. - Parameter Query: Allows to enter criteria to retrieve records. - Crosstab Query: Restructure & Calculate for easy analyses. - Action Query: Delete Query: Delete records. Update Query: Updates data of records. Append Query: Add more data to records. Make - Table: Make or Create New table.

Form object is an important object of MS-Access thathelps to create an interface for entering data in a tableor more linked table.

Report is an MS-Access object that is used todesign a ready-to-print document according tothe user specifications.
The importance of report are:
-It helps to design the print view.
-The desired layout cab be added.

We know, form allows us to enter the datafrom the user but the users entered data shouldlive in some location that is table. Also, reportprepares the ready document to be printed but itfirst need the source of document. As a result,both form and report need either table or querybefore its creation.