access/courses - Reports

Resolved · Low Priority · Version Standard

Reports

Sue has attended:
Excel Advanced course
Access Advanced course
Access VBA course

by - delegate Sue [2 posts] (2007 May 9 Wed, 16:18) Reply

how do i export a report

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	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
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: reports

by - trainer Pete platinum contributer [801 posts] (2007 May 10 Thu, 13:37) Reply

Hi Sue, Exporting a Report to Either Word or Excel can be accomplished quite quickly. When you are in the Report in Print Preview, you can select the Menu command Tools, and choose Office Links, from there you can select to either Publish it with Microsoft Word or Analyze it with Microsoft Excel options.

· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Learn about Subqueries in Access Courses
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Microsoft Access Training Opens Doors
· How Reorganising Your Data Can Take Your Business to the Next Level

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

Rate this page: