Access 2007

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

Resolved · Low Priority · Version Standard

Access 2007

Christopher has attended:
Access Introduction course
Access Intermediate course

by - delegate Christopher [2 posts] (2008 Mar 18 Tue, 16:41) Reply

can you create a report from a table?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access 2007

by - trainer Pete platinum contributer [799 posts] (2008 Mar 27 Thu, 09:13) Edited on 2008 Mar 27 Thu, 09:14 Reply

Hi Christopher, thank you for the post, In answer to your question, a report can be created from a table or a query, in either case you can use the AutoReport button, the Report Wizard or create the Report manually. In each case select the query or table you wish to base the Report on and follow the steps required. I hope that answers your question, best regards Pete

· Why go on a Microsoft Access Training Course?
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Take an Access Course to Learn About Relational Databases
· Why a Microsoft Access Course Could Change the Way You Do Business
· How Reorganising Your Data Can Take Your Business to the Next Level

Please browse our web site to find out more about
microsoft/access/training/courses and other Microsoft training courses.

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips