TAILIEUCHUNG - Office 2010 visual quick tips phần 8

Nếu, sau khi chỉ định một màu sắc mới, bạn muốn quay trở lại các thiết lập mặc định, chỉ cần xem lại các thiết lập hộp thoại và chuyển đổi tự động lựa chọn màu sắc của bạn cho các gridlines. Hộp thoại Excel Options | Chapter 9 Harnessing Access 5 Set arguments for the macro. In this case because the selected action was OpenQuery the query name to be run must be selected. 6 Click here to close Macro Builder. Access asks whether you want to save the macro. 7 Click Yes. A Save As dialog box opens. 8 Type a name for the macro. 9 Click OK. Access saves the macro and adds it to the Navigation pane. Apply It To run a macro you have created right-click it in the Navigation pane and choose Run from the menu that appears. Macros are easily identifiedin the Navigation pane by their unique yellow scroll-like paper icon the same icon found on the Macro button on the Ribbon s Create tab as well as the Run Macro tool on the Database Tools tab. Alternatively you can also click the Database Tools tab on the Ribbon click Run Macro and in the dialog box that appears click the Macro Name drop-down arrow choose the macro you want to run and click OK. 11249 Customizing Your Database and Forms To be sure Access databases can hold volumes of data so much so that it can sometimes be difficult to comprehend. Fortunately you can mitigate this difficulty by using Access s formatting tools. For example you can apply themes to your forms and reports to create a more polished and professional look as well as add pictures to them to give them some visual interest. To expedite data entry you can change the tab order of your forms that is the order in which the insertion point is moved from one field to another when Tab is pressed. To draw attention to data that meets criteria you set you can apply conditional formatting. For example you might set a rule to highlight fields that contain values greater than less than equal to or between a range of specified values. This enables you to detect problems patterns and trends at a glance. Another way to display your data is in PivotTable or PivotChart form. A PivotTable is an interactive table that summarizes your data by using format and calculation methods you .

Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.