Page 91 - Play v1.0 gujarati class 8
P. 91

«kusuõx fkÞo











                 yu{yu‚ yuõ‚u‚                                                                Subject Enrichment
                 «kusuõx 1

                 ™e[u «{kýu MS Access {kt ºký fkuüfku ƒ™kðku:

                                                          Table: Purchases

                         Item_ID            Quantity Purchased           Rate per unit               Amount


                                                            Table: Sales

                         Item_ID               Quantity Sold             Rate per unit               Amount


                                                       Table: Stock in Hand

                           Item_ID                     Item Name               Quantity in Hand at the beginning

                 •    Ëhuf fkuüf{kt 5 yuLxÙeyku ƒ™kðku.

                 •    ƒÄe ðMŒwyku {kxu ytŒu nkÚk{kt sÚÚkk™e „ýŒhe fhðk {kxu õðuhe ƒ™kðku.

                 «kusuõx 2
                 ABC nkuÂM…x÷ ‚uðkyku îkhk ËËeo™k hufkuzo ò¤ððk {kxu zuxk yuLxÙe Vku{o ƒ™kðku. fkuüf™ku ¼k„ ƒ™ðk™e sYh Au Œu ûkuºkku Au:

                 •     Þwr™f …uþLx ykEze
                 •     ËËeo™wt ™k{
                 •     ËËeo™wt ‚h™k{wt

                 •     ÷ûkýku
                 •     zkuõxh™wt ™k{
                 •     r™Ëk™
                 •     ykhkuøÞ ðe{k fðhus (nk/™k)

                 «kusuõx 3
                 yu{yuMk yuõ‚u‚{kt ™e[u™k fkuüfku ƒ™kðku:


                                                            Table: Parts

                   Part No       Part Name      Par tUnit     Supplier ID       Stock      Cost Price    Sale Price






                                                                                                    «kusuõx fkÞo  89
   86   87   88   89   90   91   92   93   94   95   96