How to Make a Temporary Report in Access 2003

A temporary report is a report that you create based on the data in a specific table or query. You can use this type of report to test the data or to find out how it will look in a final version of your report.
The report is created by using a table or query as the record source and by dragging fields from the Field List pane to the sections on the report that you want them to appear in. Then, you can modify the data or change the design of the report as needed.
You can use the Label Wizard to create labels that you can place on the records of a table or query. The Label Wizard enables you to easily and quickly create labels for a wide variety of standard label sizes.
In the first step, select the table or query that you want to be used as the record source for your labels. In the second step, select the label size you want to use.
Once you have selected the record source and chosen the label size, Access displays the label on your screen in Print Preview so that you can see how it will look. You can then change the settings on the Page Layout and Page Size groups to adjust the pages, including page orientation, paper size, and margins.
When you view the report, you can zoom in and out to get a closer look at the data. In Print Preview, you can also click the slider control on the Access status bar to increase or decrease the zoom level. You can also open the report in any view and then use the navigation buttons to view several pages at a time.
Make a Header Widget That Comes from a Custom Field
Let’s say you want to add a student’s date of birth in the header of your report card. To do this, create a table widget called “Date of Birth” inside the Report Card Demo and make it one row and one column. Then, under Contents, you can make the number of horizontal rows take up all the space on the page. This way, the date will wind up in the middle of the page and it will look much better.
Next, use a merge function to insert the date in the contents of the table widget. Copy “user_date” from the table and paste it into the first cell in the table widget, and then use a merge function modifier to customize it. Then, add a colon and a couple of spaces to make it the right length.
To make a second table widget that comes from another field, such as school address, you can create the first widget and then clone it. Then, change the contents in the second widget to say “school address”.
Use the Property Sheet To Edit Your Report
To change the properties of your report and the controls and fields that you have placed on it, switch to Design view. You can do this by right-clicking the report name in the Navigation Pane and then clicking Design View.
Comments on 'How to Make a Temporary Report in Access 2003' (0)
Comments Feed