microsoft access courses - Query

The UK's most regular instructor-led training courses.
Training information: microsoft access courses · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Query

Sharon has attended:
Access Intermediate course

by - delegate Sharon [1 post] (2007 Mar 15 Thu, 15:55) Reply

How do I create a report?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Query

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 16 Fri, 13:04) Reply

Hi Sharon,

Thanks for the question, once you have opened Access from the Start menu, find the database you wish to create a report on.

On the left hand side there are a list of menus, which start, tables, queries, forms and the next one down is reports. If you click on the report option it will give you the option, create report in Design view, or create report using wizard.

If you follow the wizard it will help you pick what information you want in your report.

Hope that helps

Tracy

· Why Do I Need To Use Access?
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Get More Out of MS Access Courses
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· How Reorganising Your Data Can Take Your Business to the Next Level

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips