Access

Resolved · Low Priority · Version Standard

Access

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

by - delegate Matt [4 posts] (2008 Mar 5 Wed, 16:16) Reply

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!

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access

by - trainer Pete platinum contributer [816 posts] (2008 Mar 17 Mon, 08:25) Reply

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 Database Optimization: First Normal Form
· Microsoft Access 2007: New Features
· Three Myths About Microsoft Access
· Why a Microsoft Access Course Could Change the Way You Do Business
· Microsoft Access Cheat Sheet: Tips and Shortcuts

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

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips

Rate this page: