Queries Helpsheet-EN
Оценка 4.6

Queries Helpsheet-EN

Оценка 4.6
docx
09.05.2020
Queries Helpsheet-EN
Queries Helpsheet-EN.docx

Скругленный прямоугольник: Queries Helpsheetlogoplanttrans.giflogoplanttrans.gif

 


Follow the steps that will help you to create a query and a report.

 

Queries

 

1.     To create a query, go to the Create tab and then click on Query Design.

 


 

2.     Select the table or tables that you want to search by selecting them and clicking Add and then Close the window

 

3.     Select all the field names in the table by clicking on the top word FanID (not the *), holding shift on the keyboard and then clicking the bottom field, in this case Email. This will highlight them all orange. (you will need to repeat this step and step 4)

4.     Click where it is orange and drag it down into the first box at the bottom. This will put all the fields in the query design at the bottom.

 

5.     To search for something type it under the field you are searching under on the criteria row. Here you can tick the information you'd like to see and untick the irrelevant information.

6.     To add some sorting click in the sort row under the field you want to order it under and select Ascending (A-Z) or descending (Z-A)

7.      

8.     To find your results click on the red exclamation mark called Run and it will show you your results.

 

The results will look like something similar to this:

Save your query by clicking the save disc in the top left hand corner and give your query a name.


 

Follow the steps that will help you to create a query and a report

Follow the steps that will help you to create a query and a report

Select all the field names in the table by clicking on the top word

Select all the field names in the table by clicking on the top word

To search for something type it under the field you are searching under on the criteria row

To search for something type it under the field you are searching under on the criteria row

The results will look like something similar to this:

The results will look like something similar to this:
Скачать файл