Tips and Tricks for Office XP - Part 5

(306 total words in this text)
(1087 Reads)  

Database conversion

Access XP gives you the option of converting databases to different version formats. It allows you to convert Access databases either from or to Access 97, 2000 or 2002. To convert one format to any other format, go to Tools > Database Utilities and choose Convert Database. Access XP lists you all the conversion schemes. Choose the one that you want. If the database is not open, Access will prompt you to choose a database to convert as well as the filename in which you can store.

Note: Access 97 does not support ADO. Converting Access 2000 or 2002 Database into Access 97 format would result in loss of information or some critical errors. Watch out for this when you do the conversion.

<img src="http://www.hashdot.com/access3_tmb.jpg" width="510" height="215" border="0" alt="" />

Keyboard around forms

Working on forms and reports is a breeze with Access XP. Mentioned below are some shortcut keys that would make work simpler and easier:

[Ctrl] + [Tab] To move to a subsection.
[F2] To switch between Edit mode (with insertion point displayed) and Navigation mode.
[F4] To switch to the property sheet (Design view in forms and reports in databases and Access projects).
[F5] To switch to Form view from Form Design view.
[F6] To switch between the upper and lower portions of a window (Design view of the Advanced Filter/Sort window only).
[F7] To switch to the Code Builder from Form or Report Design view (Design view window or property sheet).
[F8] Invokes the field list in a form, report, or Data Access Page. If the field list is already open, it moves focus to field list. After selection of a field from the list, you could just press [Enter] to insert that field.
[Ctrl] + [Enter] or [Alt] + [D] To open the selected table, query, form, report, Data Access Page, macro, or module in Design view.