Question

$\huge\mathcal{\fcolorbox{cyan}{black}{\pink{QUESTION}}}$


✒️How can you specify multiple condition while desingning a query?

✒️What is the use of print preview and Design View of a report ?














No spam
​

Answer 1

$\huge\mathcal{\fcolorbox{lime}{black}{\red{Answer}}}$

1. ️How can you specify multiple condition while desingning a query?

Open your query in Design view.

In the query design grid, click the Criteria row of the field where you want to add the criterion.

Add the criteria and press ENTER. You can use several types of criteria like text, dates (read about applying criteria to text and using dates as criteria) and functions.

2. ️What is the use of print preview and Design View of a report ?

This option is used to view the page or make adjustments before any document gets printed.

By using print preview, you can discover any errors that may exist in the document or fix the layout before printing, which can save ink/toner and paper.

Answer 2

1. Answer :- Open your query in Design view.

Open your query in Design view.In the query design grid, click the Criteria row of the field where you want to add the criterion.

Open your query in Design view.In the query design grid, click the Criteria row of the field where you want to add the criterion.Add the criteria and press ENTER. You can use several types of criteria like text, dates (read about applying criteria to text and using dates as criteria) and functions.

2. Answer :- This option is used to view the page or make adjustments before any document gets printed.

This option is used to view the page or make adjustments before any document gets printed.By using print preview, you can discover any errors that may exist in the document or fix the layout before printing, which can save ink/toner and paper.