Page 100 - Database-En-V3

5- The required data will appear in a table as follows:

Second: create a query using Query Design
You can design a query by entering specific criteria to retrieve records or a value that
you want to insert into a field. You can design a parameter query to ask for more than
one piece of information; For example, you can extract data for all students whose
grades in chemistry range between 530 and 560. In this case, the database engine
retrieves all records for students whose grades in chemistry range between 530 and
560, by following the following steps:
1- From the Create menu, choose Query Design

93 Training unit in the field of technological information - at the Supreme Council of Universities © Intellectual property rights 2024