Question

C Short answer questions (II).
1. How do you specify criteria in a query such that:
(a) All of them should work together
(b) Any one of them is sufficient
2. How can you compare numeric values in an SQL query?
3. How much storage space is taken by each of the following.
(a) Small Integer
(b) Big Integer
(c) Double
4. Give at least two examples of referential integrity from real world.
5. What are some fields that are part of the design grid when creating query in design view?
fast answer fast plz ​

Answer 1

Answer:

Q 1

ANS

To add criteria to an Access query, open the query in Design view and identify the fields (columns) you want to specify criteria for. If the field is not in the design grid, double-click the field to add it to the design grid and then enter the criterion in the Criteria row for that field.