Microsoft Access 2019 raccourcis clavier

Microsoft Access 2019  

defkey.com -
5 ans
- Raccourcis
0
Alt

or F10  Select the active tab of the ribbon and activate KeyTips

0
Alt + H

Open the Home tab

-1
F6

Move the focus to a different pane of the window

0
Ctrl + O

Open an existing database

-1
ou Ctrl + F12
-2
F11

Show or hide the Navigation Pane

-2
F4

Show or hide a property sheet

1
F2

Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design view

0
F5

Switch to Form view from form Design view

0
Tab

Move to the next or previous field in a Datasheet view

0
ou ↑   Maj + Tab
1
F5

Go to a specific record in a Datasheet view

0
Ctrl + P

Open the Print dialog box from Print (for datasheets, forms, and reports)

0
S

Open the Page Setup dialog box (for forms and reports)

0
Z

Zoom in or out on a part of the page

0
Ctrl + F

Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form view

0
Ctrl + H

Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form view

0
Ctrl + +

Add a new record in Datasheet view or Form view

0
F1

Open the Help window

0
Alt + F4

Exit Access

There are two ways to navigate the tabs in the ribbon:
To get to the ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys.
To go directly to a tab on the ribbon, press one of the following KeyTips:
0
Alt + F

Open the File page

0
Alt + H

Open the Home tab

0
Alt + C

Open the Create tab

0
Alt + X

Open the External Data tab

0
Alt + Y

Open the Database Tools tab

0
Alt + J puis B

B Open the Fields tab

0
Alt + J puis T

T Open the Table tab

0
Alt + X puis 2

2 Open the Add-ins tab, if present

0
Alt + Q

and then enter the search term to open the Tell me box on the ribbon

0
Ctrl +   

Move between groups on a ribbon

0
Tab

Move between commands within a group

0
ou ↑   Maj + Tab
You activate controls in different ways, depending upon the type of control.
If the selected command is a button, to activate it, press Spacebar or Enter.
If the selected command is a split button (that is, a button that opens a menu of additional options), to activate it, press Alt+Down Arrow. Tab through the options. To select the current option, press Spacebar or Enter.
If the selected command is a list (such as the Font list), to open the list, press the Down Arrow key. Then, to move between items, press the Up Arrow key or the Down Arrow key.
If the selected command is a gallery, to select the command, press Spacebar or Enter. Then, tab through the items.
Here is the ways to move the focus by using the keyboard:
0
Alt

Select the active tab of the ribbon and activate KeyTips

0
ou F10
0

Move to a different tab

0
Tab

Move the focus to commands on the ribbon

0
ou ↑   Maj + Tab
0

Move among the items on the ribbon

0
Ctrl + F1

Expand or collapse the ribbon

0
↑   Maj + F10

Display the shortcut menu for the selected item

1
F6

Move the focus to a different pane of the window

0
Tab

Move to the next or previous command on the ribbon

0
ou ↑   Maj + Tab
0
Espace

Activate the selected command or control on the ribbon

0
ou ⤶ Entrée
0
Espace

Open the selected menu or gallery on the ribbon

0
ou ⤶ Entrée
0

Open the selected list on the ribbon, such as the Font list

0
Tab

Move between items in an open menu or gallery

0
⤶ Entrée

Finish modifying a value in a control on the ribbon, and move the focus back to the document

0
Ctrl + N

Open a new database

0
Ctrl + O

Open an existing database

-1
ou Ctrl + F12
0
⤶ Entrée

Open the selected folder or file

0
Retour Arrière

Open the folder one level above the selected folder

0
Suppr

Delete the selected folder or file

0
↑   Maj + F10

Display a shortcut menu for a selected item such as a folder or file

0
Tab

Move forward through options

0
↑   Maj + Tab

Move backward through options

0
F4

Open the Look in list

0
ou Alt + I
0
Ctrl + S

Save a database object

0
ou ↑   Maj + F12
0
F12 or Alt + F + S

Open the Save As dialog box

0
Ctrl + P

Print the current or selected object

0
P

From Print Preview, open the Print dialog box

0
ou Ctrl + P
0
S

From Print Preview, open the Page Setup dialog box

0
C

or Esc  Cancel Print Preview or Layout Preview

0
Échap

From the Backstage, return to your database

By default, Access databases display as tabbed documents. To switch to windowed documents instead, on the File tab, select Options. In the Access Options dialog box, select Current Database and, under Document Window Options, select Overlapping Windows.
-1
F11

Show or hide the Navigation Pane

0
Ctrl + F

Go to the Navigation PaneSearch box (if the focus is already on the Navigation Pane)

0
F6

Switch to the next or previous pane in the workspace

0
ou ↑   Maj + F6
Note: You might need to press F6 more than once; if pressing F6 doesn't display the task pane you want, press Alt to move the focus on the ribbon and then press Ctrl+Tab to move to the task pane.
0
Ctrl + F6

Switch to the next or previous database window

0
ou Ctrl + ↑   Maj + F6
0
⤶ Entrée

Restore the selected minimized window when all windows are minimized

0
Ctrl + F8

Turn on Resize mode for the active window when it is not maximized (press the arrow keys to resize the window, and then, to apply the new size, press Enter)

0
Ctrl + W

Close the active database window

0
ou Ctrl + F4
0
Alt + F11

Switch between the Visual Basic Editor and the previous active window

0
Ctrl + F10

Maximize or restore a selected window

Working with menus, dialog boxes, wizards, and property sheets
0
Alt

or F10  Show KeyTips

0
Alt + Espace

Show the program icon menu (on the program title bar), also known as the control menu

0
  

With the menu or submenu visible, select the previous or next command

0
  

Select the menu to the left or right; or, when a submenu is visible, switch between the main menu and the submenu

0
Debut

Select the first or last command on the menu or submenu

0
ou End
0
Espace

Open the selected menu, or perform the action assigned to the selected button

0
ou ⤶ Entrée
0
↑   Maj + F10

Open a shortcut menu or open a drop-down menu for the selected gallery item

0
Pg Préc

Scroll up or down in the selected gallery list

0
ou Pg Suiv
0
Ctrl + Debut

Move to the top or bottom of the selected gallery list

0
ou Ctrl + End
0
Alt

Close the visible menu and submenu at the same time

0
Échap

Close the visible menu; or, with a submenu visible, close only the submenu

0
Ctrl + Tab

Switch to the next or previous tab in a dialog box

0
ou Ctrl + ↑   Maj + Tab
0
Tab

Move to the next or previous option or option group

0
ou ↑   Maj + Tab
0

Move between options in the selected drop-down list box, or move between options in a group of options

0
Espace

Perform the action assigned to the selected button; select or clear the check box

First letter of an option in a drop-down list:  Open the list if it is closed and move to an option in the list
0
Alt + A - Z

Select the option, or select or clear the check box by the letter underlined in the option name

0
Alt +

Open the selected drop-down list box

0
Échap

Close the selected drop-down list box

0
⤶ Entrée

Perform the action assigned to the default button in the dialog box

0
Échap

Cancel the command and close the dialog box

0
Tab

Toggle the focus forward between controls in the wizard

0
F6

Toggle the focus between sections (header, body, footer) of the wizard

0
Alt + N

Move to the next page of the wizard

0
Alt + B

Move to the previous page of the wizard

0
Alt + F

Complete the wizard

0
F4

Show or hide the property sheet

0
Alt + ⤶ Entrée

Display a property sheet in Design view

0
  

Move among choices in the control selection drop-down list one item at a time

0
Pg Suiv

Move among choices in the control selection drop-down list one page at a time

0
ou Pg Préc
0
Tab

Move to the property sheet tabs from the control selection drop-down list

0
  

Move among the property sheet tabs with a tab selected, but no property selected

0
Tab

With a property already selected, move down one property on a tab

0
↑   Maj + Tab

With a property selected, move up one property on a tab; or if already at the top, move to the tab

0
Ctrl + Tab

Toggle forward between tabs when a property is selected

0
Ctrl + ↑   Maj + Tab

Toggle backward between tabs when a property is selected

0
Debut

Move to the beginning of the entry

0
End

Move to the end of the entry

0
  

Move one character to the left or right

0
Ctrl +

Move one word to the left or right

0
ou Ctrl +
0
↑   Maj + Debut

Select from the insertion point to the beginning of the text entry

0
↑   Maj + End

Select from the insertion point to the end of the text entry

0
↑   Maj +

Change the selection by one character to the left

0
↑   Maj +

Change the selection by one character to the right

0
Ctrl + ↑   Maj +

Change the selection by one word to the left

0
Ctrl + ↑   Maj +

Change the selection by one word to the right

0
F4

Open a combo box

0
ou Alt +
0
F9

Refresh the contents of a Lookup field list box or combo box

0

Move down one line

0
Pg Suiv

Move down one page

0

Move up one line

0
Tab

Exit the combo box or list box

0
Ctrl + E

Open the Edit List Items dialog box

Note: In order to use the Ctrl+E keyboard shortcut for opening the Edit List Items dialog box, you must have an Office 365 subscription. Currently this shortcut is only available to Insiders at this time.
0
F2

Rename a selected object

Note: F2 works only when the object is closed.
0

Move down one line

0
Pg Suiv

Move down one window

0
End

Move to the last object

0

Move up one line

0
Pg Préc

Move up one window

0
⤶ Entrée

Open the selected table or query in Datasheet view

0
⤶ Entrée

Open the selected form or report

0
⤶ Entrée

Run the selected macro

0
Ctrl + ⤶ Entrée

Open the selected table, query, form, report, macro, or module in Design view

0
Ctrl + G

Display the Immediate window in the Visual Basic Editor

0
F2

Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet

0
Échap

Exit Navigation mode and return to Edit mode in a form or report

0
F4

Switch to the property sheet (Design view and Layout view in forms and reports)

0
ou Alt + ⤶ Entrée
0
F5

Switch to Form view from form Design view

0
F6

Switch between the upper and lower portions of a window (Design view of queries, macros, and the Advanced Filter/Sort window)

0
F6

Cycle through the field grid, property sheet, field properties, the Navigation Pane, Quick Access Toolbar, and KeyTips on the ribbon (Design view of tables)

0
F7

Open the Choose Builder dialog box from a selected control on a form or report (Design view only)

0
F7

Open the Visual Basic Editor from a selected property in the property sheet for a form or report

0
Alt + F11

Switch from the Visual Basic Editor back to form or report Design view

0
Ctrl +

Toggle forward between views when in a table, query, form, or report

0
ou Ctrl + ,
Note: If additional views are available, successive keystrokes move the focus to the next available view.
0
Ctrl +

Toggle backward between views when in a table, query, form, or report

0
ou Ctrl + .
Note: Ctrl+Period (.) does not work under all conditions with all objects.
0
Tab

Move to the next field

0
ou
0
End

Move to the last field in the current record

0
↑   Maj + Tab

Move to the previous field

0
ou
0
Debut

Move to the first field in the current record

0

Move to the current field in the next record

0
Ctrl +

Move to the current field in the last record

0
Ctrl + End

Move to the last field in the last record

0

Move to the current field in the previous record

0
Ctrl +

Move to the current field in the first record

0
Ctrl + Debut

Move to the first field in the first record

0
F5

(then, in the record number box, type the record number and press Enter) Go to a specific record

0
Pg Suiv

Move up one screen

0
Pg Préc

Move down one screen

0
Ctrl + Pg Suiv

Move right one screen

0
Ctrl + Pg Préc

Move left one screen

0
Ctrl + Espace

Select the current column or cancel the column selection, in Navigation mode only

0
↑   Maj +

Extend the selection one column to the right, if the current column is selected

0
↑   Maj +

Extend the selection one column to the left, if the current column is selected

0
Ctrl + ↑   Maj + F8 puis   

ht Turn on Move mode

0
Tab

Enter the subdatasheet from the last field of the previous record in the datasheet

0
↑   Maj + Tab

Enter the subdatasheet from the first field of the following record in the datasheet

0
Ctrl + Tab

Exit the subdatasheet and move to the first field of the next record in the datasheet

0
Ctrl + ↑   Maj + Tab

Exit the subdatasheet and move to the last field of the previous record in the datasheet

0
Tab

From the last field in the subdatasheet enter the next field in the datasheet

0

From the datasheet, bypass the subdatasheet and move to the next record in the datasheet

0

From the datasheet, bypass the subdatasheet and move to the previous record in the datasheet

0
Alt + F5

Go to a specific record in a subdatasheet

Note: This moves the focus from the subdatasheet to the record number box.
0
Ctrl + ↑   Maj +

Move from the datasheet to the record's subdatasheet

0
Ctrl + ↑   Maj +

Collapse the subdatasheet

Note: To navigate between fields and records in a subdatasheet, use the same keyboard shortcuts you use in Datasheet view.
0
F2

Switch between Edit mode (with insertion point displayed) and Navigation mode

0
F4

Open or close the property sheet

0
ou Alt + ⤶ Entrée
1
F5

Switch to Form view from form Design view

0
F6

Switch between the upper and lower portions of a window (Design view of queries, macros, and the Advanced Filter/Sort window)

Note: Use F6 when the Tab key does not take you to the section of the screen you want.
0
F6

Toggle forward between the design pane, properties, Navigation Pane, ribbon, and Zoom controls (Design view of tables, forms, and reports)

0
F7

Open the Visual Basic Editor from a selected property in the property sheet for a form or report

0
Alt + F8

Invoke the Field List pane in a form, or report (if the Field List pane is already open, the focus moves to the Field List pane)

0
↑   Maj + F7

When you have a code module open, switch from the Visual Basic Editor to form or report Design view

0
↑   Maj + F7

Switch from a control's property sheet in form or report Design view to the design surface without changing the control focus

0
Ctrl + C

Copy the selected control to the Clipboard

0
Ctrl + X

Cut the selected control and copy it to the Clipboard

0
Ctrl + V

Paste the contents of the Clipboard in the upper-left corner of the selected section

0

Move the selected control to the right by a pixel along the page's grid

0

Move the selected control to the left by a pixel along the page's grid

0

Move the selected control up by a pixel along the page's grid

Note: For controls in a stacked layout, this switches the position of the selected control with the control directly above it, unless it is already the uppermost control in the layout.
0

Move the selected control down by a pixel along the page's grid

Note: For controls in a stacked layout, this switches the position of the selected control with the control directly below it, unless it is already the lowermost control in the layout.
0
Ctrl +

Move the selected control to the right by a pixel (irrespective of the page's grid)

0
Ctrl +

Move the selected control to the left by a pixel (irrespective of the page's grid)

0
Ctrl +

Move the selected control up by a pixel (irrespective of the page's grid)

Note: For controls in a stacked layout, this switches the position of the selected control with the control directly above it, unless it is already the uppermost control in the layout.
0
Ctrl +

Move the selected control down by a pixel (irrespective of the page's grid)

Note: For controls in a stacked layout, this switches the position of the selected control with the control directly below it, unless it is already the lowermost control in the layout.
0
↑   Maj +

Increase the width of the selected control (to the right) by a pixel

Note: For controls in a stacked layout, this increases the width of the whole layout.
0
↑   Maj +

Decrease the width of the selected control (to the left) by a pixel

Note: For controls in a stacked layout, this decreases the width of the whole layout.
0
↑   Maj +

Decrease the height of the selected control (from the bottom) by a pixel

0
↑   Maj +

Increase the height of the selected control (from the bottom) by a pixel

0
Ctrl + C

Copy the selected control to the Clipboard

0
Ctrl + X

Cut the selected control and copy it to the Clipboard

0
Ctrl + V

Paste the contents of the Clipboard in the upper-left corner of the selected section

0

Move the selected control to the right (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments) Move the selected control to the right (except a control that is part of a layout)

0

Move the selected control to the left (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments)  Move the selected control to the left (except a control that is part of a layout)

0

Move the selected control up (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments)  Move the selected control up (except a control that is part of a layout)

0

Move the selected control down (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments) Move the selected control down (except a control that is part of a layout)

0
↑   Maj +

Increase the height of the selected control

Note: If used with a control that is in a layout, the entire row of the layout is resized.
0
↑   Maj +

Increase the width of the selected control

Note: If used with a control that is in a layout, the entire column of the layout is resized.
0
↑   Maj +

Reduce the height of the selected control

Note: If used with a control that is in a layout, the entire row of the layout is resized.
0
↑   Maj +

Reduce the width of the selected control

Note: If used with a control that is in a layout, the entire column of the layout is resized.
0
Tab

Move to the next field

0
↑   Maj + Tab

Move to the previous field

0
End

Move to the last control on the form and remain in the current record

0
Ctrl + End

Move to the last control on the form and set focus in the last record

0
Debut

Move to the first control on the form and remain in the current record

0
Ctrl + Debut

Move to the first control on the form and set focus in the first record

0
Ctrl + Pg Suiv

Move to the current field in the next record

0
Ctrl + Pg Préc

Move to the current field in the previous record

0
F5

Go to a specific record

0
Pg Suiv

Move down one page; at the end of the record, moves to the equivalent page on the next record

0
Pg Préc

Move up one page; at the end of the record, moves to the equivalent page on the previous record

0
Tab

Enter the subform from the preceding field in the main form

0
↑   Maj + Tab

Enter the subform from the following field in the main form

0
Ctrl + Tab

Exit the subform and move to the next field in the master form or next record

0
Ctrl + ↑   Maj + Tab

Exit the subform and move to the previous field in the main form or previous record

0
Ctrl + P

Open the Print dialog box from Print (for datasheets, forms, and reports)

0
S

Open the Page Setup dialog box (for forms and reports)

1
Z

Zoom in or out on a part of the page

0
C

Cancel Print Preview or Layout Preview

0
ou Échap
0

Scroll down in small increments

0
Pg Suiv

Scroll down one full screen

0
Ctrl +

Move to the bottom of the page

0

Scroll up in small increments

0
Pg Préc

Scroll up one full screen

0
Ctrl +

Move to the top of the page

0

Scroll to the right in small increments

0
End

Move to the right edge of the page

0
Ctrl + End

Move to the lower-right corner of the page

0

Scroll to the left in small increments

0
Debut

Move to the left edge of the page

0
Ctrl + Debut

Move to the upper-left corner of the page

0
Alt + F5

Move to the page number box

0
Tab

Move among tables, views, and functions (and join lines, if available)

0
ou ↑   Maj + Tab
0

Move between columns in a table, view, or function

0
Espace

Choose the selected data column for output

0
ou +
0
Espace

Remove the selected data column from the query output

0
ou -
0
Suppr

Remove the selected table, view, or function, or join line from the query

Note: If multiple items are selected, pressing Spacebar affects all selected items. Select multiple items by holding down Shift while selecting them. Toggle the selected state of a single item by holding down Ctrl while selecting it.
0

Move among cells

0
ou Tab
0
ou ↑   Maj + Tab
0
Ctrl +

Move to the last row in the current column

0