General Keyboard shortcuts
Open a Database Ctrl + O
a Database Ctrl + W
Print Current View Ctrl + P
Undo Ctrl + Z
Delete Record Ctrl + –
Cancel Changes Esc
Insert Date Ctrl + ;
Insert Time Shift + Ctrl + :
Insert Value from Ctrl + ’
Same Field in (Apostrophe)
Check Spelling F7
Switch Applications Alt + Tab
Editing Keyboard shortcuts
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Find Ctrl + F
Replace Ctrl + H
Select All Ctrl + A
Design View Keyboard shortcuts
Open object in Ctrl+Enter
Save Object Ctrl + S
Formatting Text Keyboard shortcuts
Bold Ctrl + B
Italics Ctrl + I
Underline Ctrl + U
Navigation Keyboard shortcuts
Next Field Tab
Previous Field Shift + Tab
Next Screen Page Down
Previous Screen Page Up
First Record Ctrl + ↑
Last Record Ctrl + ↓
Toggle Navigation Pane F11
Using the Ribbon from the Keyboard
The ribbon is set up for you to use the mouse to click on its parts. But, you can also use keyboard shortcuts to get to all of the ribbon commands. There are even screen tips for what keys to use!
Press the ALT key.
Screen tips appear beside each ribbon tab. Press again to hide the screen tips.
Press a key to switch to a tab, like C to open the Create tab.
Screen tips appear beside the buttons on that tab.
A screen tip that is grayed out is not available at this point. In the illustration many parts and their screen tips are gray because no object was open.
Ctrl plus page up button: it directs you to the first field of the current field.
Ctrl plus page down button: It directs you to the last field of the current field.
Ctrl plus home button: It directs you to the first record of the first field.
Ctrl plus end button: It directs you to the last record of the first field.
Home button: It directs you to the first field of the record.
End button: It directs you to the last field of the record.
Shift plus the F2 button: It allows you to open the Zoom dialogued box.
Ctrl button and a plus sign: It allows you to add a new record.
Ctrl button and a minus sign: It allows you to remove or delete the current record.
F2 button: It allows you to toggle between the navigation mode and editing mode.
Ctrl button plus semicolon: It allows you to enter the current data.
Ctrl button plus single quote: It allows you to repeat data that is from the field in the prior record.
Ctrl plus F8 button: It allows you to turn on move mode.
F5 button: It allows you to switch to form view.
F6 button: It allows you to switch between the upper or lower panes.
F7 button: It allows you to check spellings and grammar.
Ctrl button plus space bar: It allows you to select or unselect column.
Field Data Types
Data Type Description
Text (Default) Stores text, numbers, or a combination of both, up to
255 characters long.
Number Stores numbers that can be used in calculations.
Currency Stores numbers and symbols that represent money.
Date & Time Stores dates, times, or both.
Yes/No Stores only one of two values, such as Yes or No.
Stores values from a table, query, or value list. Can be
Rich Text Stores, text, numbers, or a combination of both that can
be formatted using color and font controls.
Memo Stores long text entries—up to 64,000 characters long.
Attachment Allows you to attach files and images to your database.
Hyperlink Stores clickable links to Web pages on the Internet or
files on a network.
Calculated Field Stores results of a calculation. The calculation must
refer to other fields in the same table.
Working with Queries and Reports
– To Create a Select Query: Click the Create tab on the Ribbon and click the
Query Wizard button in the Queries group. Click Simple Query Wizard and
click OK. Follow the instructions to select the fields you want to use from the
desired tables and create the query. If you want to filter records, view the
query in Design view and enter the criteria in the Criteria row.
– To Switch Views: Click the Home tab on the Ribbon and click the View
button in the Views group. Or, right-click the tab and select the view you want
to use in the contextual menu.
– To Summarize Values: Open the Query in Datasheet View, click the Home
tab on the Ribbon, and click the Totals button in the Records group. Click the
list arrow in a column in the Total row in the query select a calculation type
(Sum, Average, etc.).
Criteria Example Description
“London” Displays records where the field equals “London”.
Between 1/1/00 and
Displays records where the date is between 1/1/00
NOT “USA” or
Displays records where the field does not contain
the text “USA” and is not blank.
Like “S*” Displays records where the field text starts with an
IS NULL Displays records where the field is blank.
IS NOT NULL Displays records where the field is not blank.
100 Displays records whose field value is greater than
To Create a Report: Click the Create tab on the Ribbon and click the Report
Wizard button in the Reports group. Follow the instructions to select the fields
you want to use from the desired tables and create the report.
Can we ask you a favor? Can you please share this page if it’s useful to you? Thanks!
Thank you for your continuing supports!
twitter adreslerimiz. @selimzor @NoktaYardim