Back to Newsletter Archives
Back to The Software Pro Home
============================================================
Smart & Easy Software Tips, Tricks & Techniques
April 2005 - Issue 6, Volume 2
Publisher: Dawn Bjork Buzbee mailto:Dawn@SoftwarePro.com
The Software Pro (tm), Microsoft Certified Office Expert
http://www.SoftwarePro.com
============================================================
IN THIS ISSUE
Microsoft Access: Shortcuts, Tips & Tricks
1. Navigation Shortcuts
2. Data Entry & Editing Shortcuts
3. More Keyboard Shortcuts
4. Easy Date Entry
5. An Expert Resource
============================================================
Navigate, edit, and work with Microsoft Access data more easily
with these quick shortcuts and resources.
=====================================================
1. Navigation Shortcuts
=====================================================
Try these keyboard shortcuts to easily navigate in an Access
form or table:
Current field in the first record: [Ctrl] + [Up]
Current field in the last record: [Ctrl] + [Down]
First field in the first record: [Ctrl] + [Home]
Last field of the last record: [Ctrl] + [End]
First field of a record: [Home]
Last field of a record: [End]
=====================================================
2. Data Entry & Editing Shortcuts
=====================================================
Save time with these quick and easy ways to enter data in an
Access table or form:
Make your data entry and editing much easier with these great
shortcuts:
Add a new record: [Ctrl] + [+] (plus sign)
Delete the current record: [Ctrl] + [-] (minus sign)
Insert the value from the same field in the
previous record: [Ctrl] + ['] (apostrophe/single quote)
Enter current date: [Ctrl] + [;] (semicolon)
Toggle between the navigation mode (highlighted) and
editing mode (vertical insertion point displayed): [F2]
=====================================================
3. More Keyboard Shortcuts
=====================================================
Print this useful handout of all of these Microsoft Access
keyboard shortcuts and more:
http://www.softwarepro.com/docs/Access-KeyboardShortcuts.pdf
=====================================================
4. Easy Date Entry
=====================================================
When typing a date such as 07/05/2005 into an Access table or
form, just enter the month, slash, day as in 7/5 and then
press [Enter] or move to the next field. Save keystrokes
because there is no need to type the year because Microsoft
Access assumes that it is the current year. The display of the
date depends on the formatting of the field.
You will only need to type the year when it differs from the
current year.
=====================================================
5. Dig Deeper-An Expert Resource
=====================================================
Are you already creating custom queries, forms, macros, or
writing code in Microsoft Access? If you are an intermediate to
expert Access user, then add the Access Watch newsletter
(formerly Woody's Access Watch) to your resources.
http://www.office-watch.com
Check out the archives for help for new users as well.
------------------------------------------------------------
Please pass this along to others who may appreciate it!
------------------------------------------------------------
For the latest additions to The Software Pro (tm) website:
http://www.SoftwarePro.com/whatsnew.htm
Past newsletter issues are found at:
http://www.SoftwarePro.com/archives.htm
For Website or e-zine questions: mailto:Dawn@SoftwarePro.com
If you are receiving this issue as a forward, and want
your own subscription, visit
http://www.SoftwarePro.com/subscribe.htm
Privacy Policy - We hate receiving sp^m as much as
you do. Therefore, we never rent, trade, or sell
our email lists to anyone for any reason. You or
someone you know subscribed you to this e-zine list.
We never add names to our list until you voluntarily
subscribe.
(c) 2005 The Software Pro (tm)
All rights reserved.
http://www.SoftwarePro.com
To Subscribe go to:
http://www.SoftwarePro.com/subscribe.htm
============================================================
Geek Speak Becomes People Friendly (tm)
Dawn Bjork Buzbee
The Software Pro (tm)
11675 Bent Oaks Street, Suite 200
Parker, CO 80138-5703 USA
(303) 699-6868, Fax (303) 766-0886
mailto:Dawn@SoftwarePro.com
http://www.SoftwarePro.com