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

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.

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

Review of My Previous lecture

In previous my lecture we are learnt about :

• How to creat a database



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



• How to add values in Table



• How to create forms of Table Records

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

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

• 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.

Step_2

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

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

Click >students marks >Table>std

• Students marks is a database
• std is a table

Step_4

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

Then we calculate Average marks on same way

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

step_5

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

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

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 .

Regards
@salmashraf