Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy.
Office ProPlus is being renamed to Microsoft Apps for enterprise. You can use the Field List pane to add fields from the underlying table or query to your report design. To display the Field List pane, do one of the following:. You can then add fields by dragging them from the Field List pane to the report. You can also fine-tune your report's design by working in Design view. You can add new controls and fields to the report by adding them to the design grid.
The property sheet gives you access to a large number of properties that you can set to customize your report. To switch to Design view, right-click the report name in the Navigation Pane and then click Design View. You can use the property sheet to modify the properties for the report itself and the controls and sections it contains.
To add a single field, drag the field from the Field List pane to the section where you want it displayed on the report. To add several fields at once, hold down CTRL and click the fields that you want. Then, drag the selected fields onto the report. When you drop the fields onto a report section, Access creates a bound text box control for each field and automatically places a label control beside each field.
Some controls are created automatically, such as the bound text box control that is created when you add a field from the Field List pane to your report. Many other controls can be created in Design view by using the tools in the Controls group on the Design tab.
Click the tool for the type of control that you want to add. For example, to create a check box, click the Check Box tool. Click in the report design grid where you want to position the upper-left corner of the control. Click once to create a default-sized control, or click the tool and then drag in the report design grid to create a control of the size that you want. If you don't position the control perfectly on the first try, you can move it by using the following procedure:.
Position the mouse pointer over the edge of the control until the pointer turns into a four-headed arrow. This procedure creates an "unbound" control. If the control is the type that can display data a text box or check box, for example , you need to enter a field name or expression in the ControlSource property for the control before it will display any data. See the Understand controls section in this topic for more information. On the Design tab, in the Tools group, click Property Sheet.
After you save your report design, you can run the report as often as you need to. The report's design stays the same, but you get current data every time you print or view the report. If your reporting needs change, you can modify the report design or create a new, similar report based on the original.
If the report is untitled, type a name in the Report Name box, and then click OK. After you save your report design, you can use it over and over again. The report's design stays the same, but you get current data every time you view or print the report. There are several ways to view your report. Which method you choose depends on what you want to do with the report and its data:.
If you want to make temporary changes to which data appears on the report before you print it, or if you want to copy data from the report to the clipboard, use Report view. If you want to be able to change the design of the report while looking at the data, use Layout view.
Note: If your report is formatted with multiple columns, you can only see the column layout in Print Preview.
Layout view and Report view display the report as a single column. Report view is the default view that is used when you double-click a report in the Navigation Pane. If the report is not open, double-click the report in the Navigation Pane to see it in Report view. If the report is already open, right-click the report name in the Navigation Pane and then click Report View.
In Report view, you can select text and copy it to the clipboard. To select entire rows, click and drag in the margin next to the rows that you want to select. You can then copy these rows to the clipboard by doing one of the following:. On the Home tab, in the Clipboard group, click Copy.
You can apply filters directly to your report without leaving Report view. This does not remove the filter — it just turns it on and off. Click Clear Filter from fieldname. Your actual field is listed for fieldname. Once a filter has been removed, you cannot switch it back on by using the Toggle Filter command. You must first re-create the filter. Note: If you apply a filter to a report and then save and close the report, the filter will be saved. However, the next time you open the report, Access will not apply the filter.
This feature works the same in all modern versions of Microsoft Access: , , and You may change the order of, remove, or edit any existing items. You may also add a group and a sort as well. Course Catalog. Training Delivery Methods. Live Online Classes. Private Classes. Self-Paced Training.
Enterprise Training. All Training Options. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback? Go to Reports. To add a new report, select New. You can only use the Report Wizard to edit reports that were created with the wizard.
Select the starting point for your report. To create a new report, select Start a new report. Select Next. Enter the name of the report, and specify which record types the report will use. Enter data in the fields: Report name. This value will be displayed in the reports area.
0コメント