Relational Database: - As we know very well MS-Access is a “RDBMS” which use to maintain database for specific organization for maintain a database user needs to create multiple related table and make relation between them based on key field.
 
Components of relational database:- 
Ø Master table
Ø Transaction table
Ø Key field
Ø Primary key
Ø Foreign key
 
Master table:-Those table where user enter unique records of organization. It is a collection of main records.
 
Transaction table:-Those tables which use to maintain records of master table. Transaction table are depend on master table.
 
Key field:-Those fields which are common in every multiple table of database is called key field.
          Like: - st_id, Roll, Bank account no etc.
 
Key type:-There are two types of key in MS-Access
 
             Primary key:-It is a rule which apply on that key field where you are confirmed. You have not to enter duplicates records. Generally this key is applied on master table.
            
Foreign key:-This key is applied automatically apply on transaction table key field after created relation between master and transaction.
 
How to make relation between master and transaction table?
Process:-
Ø Create two tables in table object (student & fee)
Ø Click on database tools tab
Ø Click on relationship
Ø Then a dialog box open
Ø Select student table and click on add button
Ø Select fee table and click on add button
Ø Click on master table roll and drag into transaction table
Ø Click on create button
Ø Click on close button
Ø Click on yes
Ø Click on create tab
Ø Click on form wizard
Ø Select your transaction table
Ø Click on add to all button
Ø Select your master table
Ø Click on add to all button
Ø Click on next
Ø Click on next
Ø Select any layout
Ø Click on next
Ø Select any background design
Ø Click on next
Ø Enter any name

Ø Click on finish

Process for pending-fee_amt:-

Ø Open your table in design view

Ø Mouse right click on fee_Amt

Ø Click on properties

Ø Click on event tab

Ø Click on “on lost focus”

Ø Click on three ellipsis (…)

Ø Click on code builder

Ø Click on ok

Ø Write code as you need

Ø Pending=pending-fee_amt

Ø Click on save button

Ø Click on datasheet view

Ø Again click on datasheet view