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)
WOSB (Women-Owned Small Business) Certified
>>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:
- File > Back Up Database
- Choose or create a location such as a backup folder.
- Access automatically suggests a backup name that includes the current date.
- Change name if desired and pick Save.
- Continue working with the database.
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 keystrokes−no need to type the year−Access assumes that it is the current year. The display of the date depends on the formatting of the field.
>>More Tips & Tricks
Tips, Tricks, Secrets you need to know now!
|When entering dates, just type the month/date and move to the next field. The current year will automatically be added to the date.|
|Press [Ctrl] + ' (single quote) to duplicate the data from the same field in the previous record.|