reports

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

Resolved · Low Priority · Version Standard

reports

Emma has attended:
Access Introduction course

by - delegate Emma [3 posts] (2008 Mar 3 Mon, 16:51) Reply

how do your filter search in reports

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	4	book now	£224	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	7	book now	£203	£230
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
2003	2008 Nov 21 Fri	Bloomsbury	7	book now	£190	£224
Full Schedule: See all 53 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: reports

by - trainer Pete platinum contributer [799 posts] (2008 Mar 18 Tue, 11:37) Reply

Hi Emma, Thank you for your post, In answer to your question if you create your report following the steps in the Report Wizard you will be given the options to sort, group, summarise and filter your records before they are sent to the final report. Another way is to use a query to supply information to the report and filter the data in the query. I hope that helps best regards Pete.

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Access VBA Handling Errors and Debugging Code
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Why consider Access Visual Basic training?
· Material covered on a Microsoft Access Course

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

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