microsoft/access/training/courses - Access -creating a report

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

microsoft/access/training/courses - Access -creating a report

Access -creating a report

Susan has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Susan [3 posts] (2007 Dec 4 Tue, 16:57) Reply

when you creaste

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	5	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: access -creating a report

by - trainer Richard platinum contributer [818 posts] (2007 Dec 11 Tue, 14:52) Reply

Hi Susan

There are three ways to create a report.

-----------------------------------------------------------------
1.
Based on a single table or query by using AutoReport. AutoReport creates a report that displays all fields and records in the underlying table or query

How?

In the Database window, click Reports under Objects.
Click the New button on the Database window toolbar.
In the New Report dialog box, click one of the following wizards:

AutoReport: Columnar
Each field appears on a separate line with a label to its left.

AutoReport: Tabular
The fields in each record appear on one line, and the labels print once at the top of each page.

------------------------------------------------------------
2.
Based on one or more tables or queries with a wizard.

The wizard asks you detailed questions about the record sources, fields, layout, and format you want and creates a report based on your answers.

How?

In the Database window, click Reports under Objects.
Click the New button on the Database window toolbar.
In the New Report dialog box, click the wizard that you want to use. A description of the wizard appears in the left side of the dialog box.
Click the table or query that contains the data you want to base your report on.

Note You don't need to do this step if you clicked Report Wizard in step 3— you can specify the record source for the report in the wizard.

Click OK.
Follow the instructions in the wizard.
If the resulting report doesn't look the way you want, you can change it in Design view

------------------------------------------------------------
3.
In DESIGN VIEW

In the Database window, click Reports under Objects.
Click the New button on the Database window toolbar.
In the New Report dialog box, click Design View.
Click the table or query that contains the data you want to base your report on.
Click OK.
Drag, position and format the controls and fields as you see fit.

------------------------------------------------------------

Regards

Richard
Microsoft Office Specialist

microsoft/access/training/courses - Access -creating a report

Related articles

Access tip:

Display current date & time in column of any width