A developer already created a database for the small business you work for. Your supervisor likes the way that the database performs, but needs some changes made to the reports that are part of the database. Describe how to change a sales report that contains the names and order amounts of your customers so that any order over $25,000.00, in the Orders column, appears bold.

Question

What will be an ideal response?

Answer 1

With the report in Layout View, click any field value in the Orders column in the report. Click on the Report Layout Tools Format tab, and then click the Conditional Formatting button in the Control Formatting group, then click the New Rule button in the Conditional Formatting Rules Manager dialog box. Click the between list arrow and select greater than, press [tab] and then type 25000 in the text box and click the Bold button under the text box. Click OK and save your database.