MS Access Question Answer - Computer Basics, Computer Fundamentals

 

Microsoft Access2003

 

What is Microsoft Access ?

Microsoft access is RDBMS ( Relationship Database Management System ). It is used to prepare database for data or particular information.

 

Extension of Ms Access ?

Dot MDB

 

What is Database ?

Database is a collection of one or more tables or data which is used for particular information.

 

What is Table ?

Table is a collection rows and columns of fields and records such as name,class,marks etc .

 

What is Record ?

Record is a row which contains the data of different fields.

 

What is field?

Field is a column name which has data type to store the data. Such as Salary  field has Currency data type.

 

To Load Ms Access2003:- Start Menu> Programs> Microsoft Office> MS- Access2003 OR Start Menu> Run> Type (Msaccess)>Ok> Click on Create a new file> Blank Database> Give File name> Create.

To Create new table in design view: Click on Table> Create table in design view> Design

           

Field Name	Data Type
User Define Example: Employee Code,                  Basic                  Pension                  Photo                  Dept                  Sno                  Attachment                  Date of join	Text (255 char)
	Memo (65535 char)
	Number
	Currency
	Yes/ No
	OLE Object
	Lookup Wizard
	Auto Number
	Hyperlink
	Date/ Time

 

To Allow Primary key:

Select the Field type> Edit (Menu Bar)> Primary Key.

 

To Save a Table:

 File (Menu Bar)> Save> Give file name> Save.

 

To Create Relationship:

Tools (Menu Bar)> Relationship> Drag the field from one table to another table> (Yes) Enforce Referential Integrity> (Yes) Cascade update Related fields> (Yes) Cascade Deleted Related Record> Create.

 

To create Select Queries:

Click on Queries> Create queries in design View> Design> Insert the Tables> Drag the fields from the tables> Save it.

 

To Create Update Queries:

Click on Queries> Create queries in design View> Design> Insert the Tables> Select the fields> Tools (Menu Bar)> Update Queries> Give the formula> Click on Run> Save.

 

To Create Perimeter Queries

Click on Queries> Create queries in design View> Design> Insert the Tables> Give criteria in criteria fields> Save. Example [Search for ]

 

To Create Delete Queries:

Click on Queries> Create queries in design View> Design> Insert the Table> Click on Queries (Menu Bar)> Delete Queries> Give the condition.

 

To Create Append Queries:

Click on Queries> Create queries in design View> Design> Insert the table> Queries (Menu Bar)> Append Queries.

 

To Create Form:

Click on Form> Create form in Design View> New> Select the style of Form> Select the Table> Ok> Insert new data> Save.

 

To Create Report:

Click on Report> Create Report in Design View> New> Select the style of Report> Select the Table> Save.

 

To Import Excel Data:

Click on Table> New> Import table> Ok> Select the file> Import> Next> Next> Finish.

To Link Table: Click on Table> New> Link Table> Ok> Select the file> Link> Next> Next> Next> Next>Finish.