Microsoft Access training note.

What is Access?
Relational data base management system (RDBMS). It use for recording data, searching data or storing any kinds of data basically. It is in banking sector.

What is field: hive AvÛv‡i data Gw›U Kiv nq Zv‡K field ejv nq

Data : GkwU Information Gi G‡KKUv Ask‡K WvUv e‡j

Information : GKvwaK Relation WvUv nj Information


How to open Microsoft Access:
Click Start, Select Program, Click Microsoft Access, (Open Microsoft Access), Click Blank Access Database , Type file name (Combo box),

Create New Table Structure:
Let Create Cursor table structure now
Click Table, Click New, Select Design View, Click ok

Field Name – Data Type
C_Id---------- Text
C_Name------ Text
Duration ------ Text
Fee------ Currency

Put Cursor at the C_id Field:
Click Edit, Click Primary key, Click General, Click Required, Select Yes

Put Cursor at the fee field:
Click General, Click format, Select Standard, Click file
Click Save, Type table, Click ok, Click File, Click Close


Create Another Table :
Let Ceate S_ table
Click table, Click New, Click Design View, Click Ok,

Let type of S Field
Field Name – Data Type
S_Id----- Text
S_Name Text
Ad_Date Date/ time
Batch NO Number
C_Id text

Put Cursor at the C_id Field:
Click Edit, Click Primary key, Click General , Click Required ,Select Yes

Put cursor at the ad date:
Click General, Click Format ,Select Short Date,

Put cursor at the C_Id
Click General, Click Required, Select Yes
Click----file---- Save ----Type Stable-----Click Ok----Close.

Setting Relationship between two table
Click Tools, Click Relationships, Select C Table, Click Add, Select S table, Click Add
Close the show table windows
Drag Mouse from C table C-Id to S table C_Id., Double Click C_id Combo box, Click Create New, Click Left table name combo box, Select C table, Click Right table name combo box, Select S table
Click left column name combo box, Select C_id, Click Right column name combo box, Select C_id
Click Ok
Click on Enforce Referential Integrity, Click on Cascade Update Related field, Click on Cascade Delete Related Record, Click Create
Click File ---Save----close.

Data Entry Between the table:
Select C_table , Click Open,Write it in the Ctable format ,C-table

Select S_table
Click Open, Write it in the S table format
Stable, Sid, S name, ad date, batch no, c id,Si001 (create table use this title)
Click----Save----Close.

Design forms:
Click Forms, Click New, Select Form Wizard, Select C table from the combo box
Click ok, Click >> Button, Click Next , Select Tabular , Click Next , Select Any Style , Click Next
Type form Name Ctblform, Click finish , Write Data In the Ctblform

Ctable
Click Save ----Close.

Design Stable form
Same As C_table form Just Select S_table form the combobox another things same.
Click File--- Save---Close

Design Query :
The main purpose of the query is to find out a particular piece of information from the database, query is also helpful for making reports form the above data base we can use query function to find out.
Information about course
Information about student
Information about a batch etc.

How to create query:
Click Query, Click New ,Click Design View, Click Ok, Select C_table , Click add, Select S_table
Click add, Close the show table windows, Then Double click on two table every field.
Click file click Save, Type query table , Click OK, Click file , Click Close

How to open Query:
Select Query table, Click Open.

Finding out Particular information:
Select Query table, Click Design, Write at the criteria row below S_id field [Enter S_id]
Click file
Click Save-close

New open Query table:
Select Query table
Click Open
Write Si001 or Si002 or Si003 or others

How to Design A Report:
All database should generate one or more report without having report generation facilities data based may be seen as resold less system the database. We have create can produce many report.
Click Report
Click New
Click Report Wizard
Select Query table form combo box
Click ok
Click >> Button
Click Next (5 times)Select any Style
Click Next
Type Report table
Click finish.
******** Microsoft Access ********