IITM

Add New Topic

Chapter Details

Select Subject

Display Order

Topic Title

Content Details

<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">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 <o:p>  </o:p>Master table:-Those table where user enter unique
records of organization. It is a collection of main records. <o:p>  </o:p>Transaction table:-Those tables which use to maintain
records of master table. Transaction table are depend on master table. <o:p>  </o:p>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<o:p></o:p>Process for pending-fee_amt:-<o:p></o:p>Ã˜ Open your table in design view<o:p></o:p>Ã˜ Mouse right click on fee_Amt<o:p></o:p>Ã˜ Click on properties<o:p></o:p>Ã˜ Click on event tab<o:p></o:p>Ã˜ Click on â€œon lost focusâ€<o:p></o:p>Ã˜ Click on three ellipsis (â€¦)<o:p></o:p>Ã˜ Click on code builder<o:p></o:p>Ã˜ Click on ok<o:p></o:p>Ã˜ Write code as you need<o:p></o:p>Ã˜ Pending=pending-fee_amt<o:p></o:p>Ã˜ Click on save button<o:p></o:p>Ã˜ Click on datasheet view<o:p></o:p>

Ã˜ Again click on datasheet view<o:p></o:p></blockquote>

Your order is placed

James Lemire

Your item is shipped

Salena Layfield

Add New Topic

Short Key List