microsoft access training - access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Access

microsoft access training - Access

resolvedResolved · Low Priority · Version Standard

replyReply Wed 18 Jul 2007, 10:03Delegate Tatiana said...

Tatiana has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Excel VBA Intro Intermediate course

Access

how to reate a report?

For upcoming training course dates see: Pricing & availability

replyReply Fri 20 Jul 2007, 10:05Trainer Richard said...

RE: Access

Hello Tatiana

Initially report creation can be done best with the Report Wizard. Until you learn the finer details of report design, stick with the Wizard, and modify from there.

To create a report:

1.
Start the wizard, and then select the Table or Query that you want the report to come from.

2.Choose the fields, layout, formatting and style you want for for the report.

3.
Name you report and then Finish.


Regards

Richard

 

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard