Microsoft Office 2010 Expert, Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 trainingSoftware Tips & Tricks, Expert Speaker, Microsoft Office 2010 Training, Microsoft Certified Trainer, Microsoft Office Consultant, Books, Videos, Web Training 
 Home Products Programs Meet Dawn Free E-zine Media Room Contact
Access  

Technology Trainer
Software & Tech Speaker
Software Consultant
Tips & Tricks
The Pro Shop
Free Software Articles
How-To Lessons
Tips Newsletter
Bonus Resources

 
Dawn Bjork Buzbee
The Software Pro


Microsoft Certified Trainer (MCT)

Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor

Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor

Microsoft Certified Application Specialist (MCAS) Instructor

Certified Microsoft Office Expert

Certified Women's Business Enterprise (WBE)
WBENC Certified

WOSB (Women-Owned Small Business) Certified

(303) 699-6868
Dawn@SoftwarePro.com


Microsoft Access Tips & Tricks

>>Home >>Tips & Tricks

Supports Microsoft Office Access 2003, Microsoft Access 2002/XP, and Microsoft Access 2000 unless noted

Back Up Your Database
Don't risk losing key data or regret changes to critical Access objects. With Microsoft Office Access 2003, it's easy to back up the active (open) database and all of its objects:

  1. File > Back Up Database
  2. Choose or create a location such as a backup folder.
  3. Access automatically suggests a backup name that includes the current date.
  4. Change name if desired and pick Save.
  5. Continue working with the database.

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]

Zoom In for Easy Edits
Here's a way to add or edit an Access query expression, report or form control, table field, and many other Access database objects and data elements:

  • Click or move into the control or field
  • Press [Shift] + [F2] to open the Zoom dialog box
  • Type or edit your entry; choose Font to increase or change the size and style of the font for easier display
  • OK when done

Quick Data Entry
Save time with these quick and easy ways to enter data in an Access table or form:

  • Add a new record: [Ctrl] + [+] (plus sign)
  • Delete the current record: [Ctrl] + [-] (minus sign)
     
  • Enter current date: [Ctrl] + ;
     
  • Repeat data from same field in the previous record: [Ctrl] + ' (apostrophe/single quote)
     
  • Toggle between the navigation mode (highlighted) and editing mode (vertical insertion point displayed): [F2]

Easy Date Entry
When typing a date into an Access table or form, just enter the month, slash, day such as 7/15 and then press [Enter] or move to the next field. Save keystrokesno need to type the yearAccess assumes that it is the current year. The display of the date depends on the formatting of the field.

>>More Tips & Tricks

Go To Top of Page
 



Tips, Tricks, Secrets you need to know now!
Discover the secrets you wish you knew before...all of this plus 15 BONUS SHORTCUTS and access to handouts with 477+ MORE SHORTCUTS AND TIPS when you
sign-up for the Smart & Easy Software Tips & Tricks eMagazine!

Start Being More Productive Today!
CLICK HERE to
sign-up by email.
Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
Hot Access Tip
When entering dates, just type the month/date and move to the next field.  The current year will automatically be added to the date.
 
Did You Know?
Press [Ctrl] + ' (single quote) to duplicate the data from the same field in the previous record.
 
 
www.SoftwarePro.com
HomeContact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

Copyright 1995-2013 The Software Pro & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
Dawn@SoftwarePro.com 11675 Bent Oaks Street, Suite 200; Parker, Colorado 80138 USA www.SoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist (MOS) Master Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE) WBENC Certified
WOSB (Women-Owned Small Business) Certified
The Software Pro
is a registered trademark
Terms & Conditions       Privacy Policy