Blog Tutorial 2 - Query

 Queries

Create Query In using Design View

To Create Query

v  Click on Queries > Click on Create Query In design View > you will see a Table dialog Box.

v  Choose the information you want > click the add button > selected query will display > after you finish select > click close button

To Delete The Table

v  Select the Query that You want to delete > click the table > then press the delete key it will remove from the Query but not from the database.

To Insert The Table

v  place the cursor at the epmty place > right click > choose show table > a Show Table Dialog Box will appear > choose the Query that you want, for example Booking > than click add button > click close button

To Insert The Field

v  Click a field that you want to include in  your query > Double click the field that you choose > Below are the field that will be insert in the query

v  Press ! button to run the Query > you can see the result below:

To Save

v  Click on the save button  > you will see a save as dialog box > type the Query Name > click Ok > you will see the Query name.

 

Create Query By using Wizard



To Create Query

v  Click on Queries > Click on Create Query By using Wizard > you will see a Simple Query Wizard box.

v  Choose the table > click the field that you want to include > click > button to add one by one or click

     >> to add all the field > you will see the field that you add, at the box beside.

v   Select another Table under Customer

v  Click Next button to go to the next page of Query Wizard > you will see a Simple Query Wizard box > type the Title for your Query > Choose Open the query to view information > click finish

To Change a Query

v  Click on the Design View symbol to change to Design View .

 To Rearrange Fields

v  Click the field you want to move > drag the field to a new location > click save button to save the changes.

To Delete the Fields

v  Click the field that you want to delete > and press DELETE key > click on the save button to save the changes.

 Ø Click on the datasheet symbol to see the result