SIZ Approved Course|Lecture 02|How To Creat Table and adding data in Table | | 10% Payout To @siz-official

in Steem Infinity Zone2 months ago (edited)

Hello Everyone!


I hope all of you are happy and well.I'm want to start my lecture with a nice words.When we are faced a difficult time and difficult situation as we are now with the effects of a worldwide pandemic in the form of COVD 19.
COVID has made a lot of people work even more difficult.It is very easy to get discourage and give up.Hope Is an very essential element of human life and it is very necessary to find hope , peace and happiness 😊in the time of dispair.

Slide1.JPG

Today I'm going to post My second Lecture That is about:

  • How to creat Table In MS Access
  • How to Adding data in tables
  • How to Generate Report from Table

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Lets Starts


Simple database similar to a contact list in yourphone can only use one table .Mostly a lot of details use multiple tables. when you create a new database you create a new file on your computer that acts as a container in your computer for everything in your information including your tables .

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Create a Table in database

  • First of all Open MS Access software by simply clicking on its Icon.
  • For Creating table we created a database by simlpy click on Blank Desktop Database

1.PNG

  • In the field of database Name box we assign a unique Name according to data that we want to store in database
  • databasename.PNG

  • We successfully created a database then MS Access automatically open Table ,you will see the table is automatically created
  • Then we go on fields tab in Table.
  • The ID field is already created ,we can change its name according to our data.ID is a unique identifier that is a primary key that is identify a record in database.
  • We are adding Fields name and their related data type
  • you will save your table by simply right click on table name Table>>Saveform pop-up Manu
  • Capture13.PNG

  • After adding Fields names and its data type we are created a Student table.
  • you should to use a descriptive Name of your fields so that the field will be uniquely identify in your table
  • JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    Add Records In Table

  • For adding values or Records in a table Click the "New Record"button at the right ⏯️ ▶️ end of the record Navigation button group.
  • Then we enter the all the Information into the fields.
  • when you entered one Record you can move down to enter the next a new record by same way as we enter first record.
  • close the table if you entered all the records that you want to store in a database management system.

    Capture12.PNG

  • We are adding all the data in table that you can see
  • Screenshot (20).png

    tabledtaa.PNG

    JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    Create A Form

    • In The navigation pane ,Click on Table
    • On Create Tab click on Form icon.

    Captureform.PNG

  • The Form is created successfully of One student

  • next.PNG

  • You can create all the form of all students in this method
  • JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    Thanks You so Much everyone

    sa.png

    Regards


    @salmashraf

Sort:  

Amazing Lecture and very Nice Information !!!
Your are done a great job and plz keep it up .It's very informative post and contain a very intrestin info.Thanks you so much @salmashraf for posting such a nice Lecture. I'm like your presentation Style.Well done

 2 months ago 

Wow amazing dear friend you make a very good post thanks for sharing information about table making process in ms it is very informative post.
Keep it up i really like your lectures.

Regards, @faran-nabeel


@vvarishayy
#sizcomments

https://steemit.com/hive-181430/@siz-official/siz-commenting-contest-2-let-s-encourage-others-by-apreciating-their-work

 2 months ago 

Thanks u so much faran.

 2 months ago (edited)

Another amazing class. Thanks for sharing.
@vvarishayy
#sizcomments

 2 months ago 

Welcome 🤗 [email protected]

 2 months ago 

Welcome 🤗 [email protected]

Thanks dear v.good post this is very helpful for us.Keep it up i realy like your lectures.

 2 months ago 

You made a very good post @salmashraf.
Thanks for sharing this information post about table making.

Its very Nice and very informative Post.I'm reading all of Your lectures.All are very informative and very amazing.I"m Really like your lectures.
Keep it Up dear @salmashraf
@vvarishayy
@siz-official

Excellent post dear it's very helpful for those who never knew about how to making table at Ms I learn from your lecture ☺️☺️
@vvarishayy
#sizcomments

https://steemit.com/hive-181430/@siz-official/siz-commenting-contest-2-let-s-encourage-others-by-apreciating-their-work

 2 months ago 

Thanks u so much dear #sualeha

Wao!amazing Lecture and very Informative Post .Keep It up with Great work

Great Information that you share with us

Wao!amazing Post.Plz Keep it up

 2 months ago 

This is very greater value coumminty.it support all members in this coumminty.I try my hard to become a good student.
@vvarishayy
#sizcomments
https://steemit.com/hive-181430/@siz-official/siz-commenting-contest-2-let-s-encourage-others-by-apreciating-their-work

Perfect couse ... Keep it up