Report

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

Resolved · Medium Priority · Version 2003

3 posts

ReplyTue 8 Dec 2009, 15:24Delegate Enat said...

Enat has attended:
Access Intermediate course
Access Intermediate course

Report

how do you do a report

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

648 posts

ReplyWed 9 Dec 2009, 10:07Trainer Simon said...

RE: report

Hi Enat,

Thank you for your question.

To create a report follow the instructions below:

1. Go to Reports via the objects toolbar.
2. Click the New button and choose the Wizard option.
3. Select the table or query you would like to base the report on.
4. Add the fields you want to see in the report.
5. Continue through the wizard setting the layout and formatting options.
6. Finally save the report with a name.

I hope this answers your question.

Regards

Simon

Tue 15 Dec 2009: Automatically marked as resolved.

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Innovation with Microsoft Access
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Microsoft Access as a Business's Database Management System
· How Microsoft Access grows with your company

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

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.