MS Access ShortCuts

ACCESS

Action Keystroke Database actions Open existing database CTRL+O Open a new database CTRL+N Save CTRL+S Save record SHIFT+ENTER Print CTRL+P Display database window F11 Find and Replace CTRL+F Copy CTRL+C Cut CTRL+X Paste CTRL+V Undo CTRL+Z Help F1 Toggle between Form and Design view F5 Other Insert line break in a memo field CTRL+ENTER Insert current date CTRL+; Insert current time CTRL+: Copy data from previous record CTRL+' Add a record CTRL++ Delete a record CTRL+-

Action Keystroke Editing Select all CTRL+A Copy CTRL+C Cut CTRL+X Paste CTRL+V Undo CTRL+Z Redo CTRL+Y Find CTRL+F Replace CTRL+H Spell checker F7 Toggle between Edit mode and Navigation mode F2 Open window for editing large content fields SHIFT+F2 Switch from current field to current record ESC Navigating Through a datasheet Next field TAB Previous field SHIFT+TAB First field of record HOME Last field of record END Next record DOWN ARROW Previous record UP ARROW First field of first record CTRL+HOME Last field of last record CTRL+END

How to change the module name in VBA / Edit Module Name In VBA

You might have noticed that when you create a module, VBA allocates a default name (Module1, Module2, so on).

It would be a professional look to your code if you change the module names as per the code inside.

We can change the default name of a module by following very simple steps below.


See the steps in a short video below :

Steps

1. Open your project in VBE (ALT + F11)

2. Select the Module from your project explorer.

3. You can see the Name property of the selected module in the properties panel.

4. Edit the name and give the name as you wish.


Notes :

-:- If project Explorer not visible, press CTRL + R

-:- If properties window is not visible, press F4 to make it visible.

-:- The naming criteria is subject to VBA's naming parameters.