SIZ Approved Course Lecture 03|How To Create Query In Database | | 20% Payout To @siz-official

in Steem Infinity Zonelast month (edited)

Hello EveryOne!


I hope you all are well and safe and hope so you all have understood my previous lectures with keen interest..I want to start my lecture with a nice words of Mother Teresa.
"Yesterday is gone.
Tomorrow has not yet come.
We have only today.
Lets begin."

-Mother Teresa

Let's Begin


Slide1.JPG

One of the most powerful way to analyzing data access is Creating a Query. Running a query is like asking a Question to a database .We can create query on single table OR on multiple tables.A query is a request for data information from a database table are combination of database tables this is a question that we ask to a table.

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

we can perform different queries To

  • Answer to a question ❓
  • Perform different types of calculations on data
  • To combine data from different types of tables
  • And to add different fields of tables and different types of data
  • It is used to change data or to update data
  • It is used to delete a record from a database or table
  • We use query to perform different types of calculations as average ,obtained marks ,percentage, grades of students
  • Use to export results
  • Use to retrieve large amount of data very quickly and very efficiently

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Review of My Previous lecture


In previous my lecture we are learnt about :

  • How to creat a database
  • Capture.PNG

  • How to create table
  • How to add fields with their related data types
  • fields.PNG

  • How to add values in Table
  • addingvaluesin table.PNG

  • How to create forms of Table Records

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Let's Starts My Today's Lecture


Today I will tell you about Query and complete procedure to creating a query.A query can 🥫 be a request for data information from our database management system or for Action on the data Or for both data and database.

How to create a Query In MS Access


Step_1

  • First of all you should to choose a table in which you want to apply query
  • To create a query go to Creat Tab by simply Click on CREATE>Query Design button on menu bar

creataquery.PNG

  • Here we select the table in which we want to create a query Click > Add then Click>Close
  • close.PNG

    • The Student table is appear in a small window as object relationship form and the list of all table fields are listed in this table .
    • We resize all the fileds.

    JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    Step_2

    • Double click on Fields obtain Marks, Average and Grade
    • we will include all the fields in which we want to apply operation

    changefiels.PNG

    JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    Step_3

    • Then Right click on below text box of Obtain Marks where we want to apply formula of obtain Marks
    • From Pop up menu Click>Build

    3.PNG

  • Click >students marks >Table>std
  • indatabaseenterrtable.PNG

    • Students marks is a database
    • std is a table

    JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    Step_4

    • Then we select the subjects fields and + Operator to calculate Obtain Marks values.

    obtain.PNG

  • Then we calculate Average marks on same way
  • avrgcal.PNG

    • click on close query and then you will save your query with a suitable name related your data that you are store on database.

    savavg.PNG

    JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    step_5

    • Then we run the query by simply on Query name Click>Calculationthen Click>Yes

    runavg.PNG

    • The Query is running the obtain marks and average values are generated automatically

    ss.PNG

    final.PNG

    JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

    I would like to Special thanks to

    Sir @cryptokraze

    @siz-officail

    @vvarishayy

    and other staff of Steemit infinity zone who provide us such an amazing and interesting platform where we show our skills and our experience .

    sa.png

    Regards
    @salmashraf

    Sort:  
     last month 

    Amazing dear friend you make a very good post thanks for sharing information about how to create query in data base.
    Your post is very informative and well detailed.
    Keep it up dear my best wishes for you.
    Remember me in your prayers.
    Regards, Faran

     last month 

    Thanks u so much faran-nabeel

     last month 

    You know We can make attractive games on ms Excel too 🤩

     last month 

    Definitely dear 🥰 we can.

     last month 

    Very informative post about queries creations in ms access. . Thank you.

    wao amazing you make a very good post thanks for sharing information.keep it up dear my best wishes for you.

    Thank you dear ...your post is very good and informative