Ecom Software Solutions
Wales' Most Flexible Training Provider
tel: 029 2044 0010
fax: 029 2044 0019
Contact • Find
.
.
Home  • Short Courses  • Facilities  • ECDL  • Resources  • News  • ReAct  • Online Shop
.
.
.
Tips and Tricks Keyboard Shortcuts Touch Typing Word Processing with MS Word Spreadsheets with MS Excel Databases with MS Access MS Office
.
.
Share |

.
.

Find us on...

Ecom on FacebookEcom on TwitterEcom on LinkedIn

.
.

MS Access Tips & Tricks

.

Shortcut keys to use in Access

  • To add the current date to a field pres CTRL+SEMICOLON
  • To add the current time to a field press CTRL+SHIFT+SEMICOLON
  • To change case from upper or lower case, highlight the text area then press Shift+F3
  • To decrease the font size, press CTRL+SHIFT+<
  • To undo any changes to the current record hit the ESC key
  • To increase the font size, press CTRL+SHIFT+>
  • To duplicate the entry press CTRL+' (apostrophe), this will copy the contents of the previous entry in the same field.
  • Display the database window by pressing F11
  • Open a new database by pressing CTRL+N
  • Open an existing database by pressing CTRL+O
  • Switch between the Visual Basic Editor and the previous active window by pressing ALT+F11
  • To open up find and replace press CTRL+F
.
.
.
.
.