Query In Access

 1. Select Query

When you want to select specific data from one or more sources, you can use a select query. A select query helps you retrieve only the data that you want, and also helps you combine data from several data sources.

From Above Table Show Record with District Bogura only.

Steps

a. Click on Table-->Create Tab-->Query Design-->select table and click add and close-->Add those filed which we want to show

b. add criteria and click Run then save query

2. APPEND QUERY

Append b_batch record into a_batch record.

at first set a_batch and b_batch id field is not auto number and primary key

  a. create tab-->query design-->select b_batch and add field

   b. click append-->select a_batch--> click run

    c. save query

3. Using select Query to Calculate TOTAL, AVERAGE and GRADE

a. create tab-->query design-->select table and add fields

b.  TOTAL: [DOS]+[Windows]+[D_Base]+[Network]

c. AVERAGE: [TOTAL]/4 

d. GRADE: IIf([DOS]<10 Or [Windows]<10 Or [D_Base]<10 Or [Network]<10,"FAIL",IIf([TOTAL]>90,"EXCELLENT",IIf([TOTAL]>=60,"GOOD",IIf([TOTAL]>=45,"POOR","FAIL"))))

4. Update Query   Update/Replace ME with CSE in Department Field from A_Batch table.

5. Update with SQL 

click sql view and type 

UPDATE B_BATCH

SET Total = Total + 100

WHERE Total < 150;

//but total field should not calculated or depend on other field