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.