Cheatsheet Microsoft Access
Sistema de gestão de bases de dados da Microsoft
Microsoft Access
File and Database
New Database
Ctrl + N
Creates a new blank database.
Ctrl + P
Prints the current object or view.
Open Database
Ctrl + O
Opens an existing database.
Database (Properties)
Alt + F, I
Opens database info/properties.
Save
Ctrl + S
Saves the active object (table, form, etc.).
Compact and Repair
Alt + F, C, A
Compacts and repairs the database.
Close Window
Ctrl + W (active object)
Ctrl + F4 (current window)
Closes the object or window.
Exit Access
Alt + F4
Closes Microsoft Access.
Navigation
Next / Previous Record
Ctrl + Page Down (next)
Ctrl + Page Up (previous)
Navigates between records.
Switch Between Objects
Ctrl + F6
Switches between open object windows.
First / Last Record
Ctrl + Home (first)
Ctrl + End (last)
Jumps to the beginning or end.
Go to Specific Field
F5
Opens "Go To" (record number).
New Record
Ctrl + + (plus)
Moves to the new (blank) record.
Navigation Pane
F11
Shows/hides the navigation pane.
Editing Records
Copy / Cut / Paste
Ctrl + C (copy)
Ctrl + X (cut)
Ctrl + V (paste)
Clipboard operations.
Edit Field (Memo)
Ctrl + F2
Opens the zoom editor for long fields.
Undo / Redo
Ctrl + Z (undo)
Ctrl + Y (redo)
Revert or reapply actions.
Spell Check
F7
Starts the spell check.
Delete Record
Ctrl + - (minus)
Deletes the current record (with confirmation).
Select All
Ctrl + A
Selects all the field/record content.
Insert Date/Time
Ctrl + ; (current date)
Ctrl + Shift + ; (current time)
Inserts the system date or time.
Hyperlink
Ctrl + K
Inserts a hyperlink in the field.
Tables and Queries
New Table
Ctrl + N (in navigation pane)
Creates a new table.
Add Field (Table)
Ctrl + Space
Selects the current field column.
New Query
Create → Query Wizard
Opens the query wizard.
Field Properties
Alt + Enter
Opens the properties of the selected field.
Run Query
Alt + Q, R (Query Design)
Runs the query in design view.
Primary Key
Design → Primary Key
Sets the field the the primary key.
Switch View (Table/Query)
Ctrl + , (comma)
Switches between datasheet and design view.
Filter by Selection
Ctrl + Shift + F
Filters records by the selected value.
Forms and Reports
New Form
Create → Form
Creates an automatic form.
Print Preview
Ctrl + F2
Opens the report preview.
Switch Form View
Ctrl + , (comma)
Switches between form view and design view.
Refresh Form Data
Shift + F9
Recalculates the form controls.
Next / Previous Control
Tab (next)
Shift + Tab (previous)
Navigates between form fields.
Subform (Enter/Exit)
Ctrl + Tab (enter)
Ctrl + Shift + Tab (exit)
Navigates between main form and subform.
New Report
Create → Report
Creates an automatic report.
Selection and Research
Find
Ctrl + F
Opens the "Find and Replace" dialog.
Select Field
F2
Selects all the text of the current field.
Replace
Ctrl + H
Opens the replace dialog.
Filter by Form
Ctrl + Alt + F
Opens the filter by form.
Repeat Search
Shift + F4
Repeats the last find operation.
Remove Filter
Ctrl + Alt + Shift + F
Removes all applied filters.
Select Entire Record
Shift + Space
Selects the entire current record.
Design View
Design View
Ctrl + , (comma)
Switches to design/structure view.
Move Control
Ctrl + Arrow Keys
Moves the control pixel by pixel.
Property Sheet
F4 (open)
Alt + Enter (properties)
Shows the object properties.
Align Controls
Format → Align
Aligns the selected controls.
Expression Builder
Ctrl + F2 (in an expression field)
Opens the expression builder.
Insert Row (Table Design)
Ctrl + Shift + +
Inserts a new field row.
Resize Control
Shift + Arrow Keys
Resizes the selected control.
Delete Row (Table Design)
Ctrl + -
Removes the selected field row.
Advanced
VBA Editor
Alt + F11
Opens the Visual Basic for Applications editor.
Set Breakpoint
F9 (in the VBA editor)
Sets/removes a breakpoint.
Immediate Window (VBA)
Ctrl + G (in the VBA editor)
Opens the immediate execution window.
References (VBA)
Tools → References
Adds libraries to the VBA project.
Run Macro / Code
F5 (in the VBA editor)
Runs the current procedure.
Database (Options)
Alt + F, T
Opens the Access options.
Step Through (Debug)
F8 (in the VBA editor)
Executes line by line (debug).
Help
F1
Opens Microsoft Access help.