Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version Standard

Reply Wed 5 Mar 2008, 16:16Delegate Matt said...

Matt has attended:
Access Introduction course
Access Intermediate course
Access VBA course
Access Advanced course

Access

Thanks for the course! Can you give me your number one time-saving short-cut when using Access a lot for extracting accounts information? Something that'll save me a few minutes every day. Thanks!

For upcoming training course dates see: Pricing & availability

Reply Mon 17 Mar 2008, 08:25Trainer Pete said...

RE: Access

Hi Matt, Thanks for the post, I have been away for a while, so left your question for someone else to answer, seems like no one wants to take it on. Not having an accounts background, I can only answer with standard Access procedure - remember the KIS principle (Keep it Simple) keep your queries simple if you need to query a query then do so. Hope that helps a little bit, best regards, Pete

Access articles

· Express Yourself With Microsoft Access
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Access Corruption Avoidance Tip #1: Split Your Database
· Protect Sensitive Access Databases With A Password
· Access Database Optimization: First Normal Form

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

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips