Follow these steps:
i) First open your database
ii) Click on 'Queries' tab from left panel
iii) Click on 'Create query in Design view'
iv) Add tables on which you are going to execute query
v) Now you can see on the second-top left corner(below menu bar), there is a option where you find out 'SQL View' after clicking downward arrow. Click on SQL View.
vi) Query1 Panel opens. Here you can write Select Query, Update Query, Delete Query etc And then execute the query by clicking on exclamatory sign (!) from the second-top bar.
vii) Result will show in same window (Query1 Panel). If you want to write another query then click on 'SQL View' as mention above and repeat the procedures.
i) First open your database
ii) Click on 'Queries' tab from left panel
iii) Click on 'Create query in Design view'
iv) Add tables on which you are going to execute query
v) Now you can see on the second-top left corner(below menu bar), there is a option where you find out 'SQL View' after clicking downward arrow. Click on SQL View.
vi) Query1 Panel opens. Here you can write Select Query, Update Query, Delete Query etc And then execute the query by clicking on exclamatory sign (!) from the second-top bar.
vii) Result will show in same window (Query1 Panel). If you want to write another query then click on 'SQL View' as mention above and repeat the procedures.
No comments:
Post a Comment