ITI COPA

MS Access Shortcut Keys

MS Access | Shortcut Keys

 

MS Access | Shortcut Keys

MS-Access Shortcut Keys


Task to perform

Shortcut Key

Open the Home tab

Alt+H

Display the shortcut menu for the selected item

Shift+F10

Show or hide a property sheet

F4

Switch between Edit mode and Navigation mode in the Datasheet or Design view

F2

Switch to Form view from the form Design view

F5

Move to the next or previous field in the Datasheet view

Tab or Shift+Tab

Go to a specific record in the Datasheet view

Alt+F5

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

Ctrl+P

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

S

Zoom in or out on a part of the page

Z

Open the Find tab

Ctrl+F

Open the Replace tab

Ctrl+H

Add a new record in Datasheet view or Form view

Ctrl+Plus Sign (+)

Open the Help window

F1

Exit Access

Alt+F4

Open the File page

Alt+F

Open the Home tab

Alt+H

Open the Create tab

Alt+C

Open the External Data tab

Alt+X or Alt+X,1

Open the Database Tools tab

Alt+Y

Open the Fields tab

Alt+J, B

Open the Table tab

Alt+J, T

Open a New Database

Ctrl+N

Open an Existing Database

Ctrl+O or Ctrl+F12

Show KeyTips

Alt or F10

Close the Active Database Window

Ctrl+W or Ctrl+F4

Switch between the Visual Basic Editor and the previous active window

Alt+F11

Maximize or Restore a selected window.

Ctrl+F10

Text Box Editing

 

Move to the beginning of the entry

Home

Move to the end of the entry

End

Move one character to the left or right

The Left or Right Arrow

Move one word to the left or right

Ctrl+Left Arrow or Ctrl+Right Arrow

Select from the insertion point to the beginning of the text

Shift+Home

Select from the insertion point to the end of the text

Shift+End

Change the selection by one character to the left

Shift+Left arrow

Change the selection by one character to the right

Shift+Right arrow

Change the selection by one word to the left

Ctrl+Shift+Left Arrow

Change the selection by one word to the right

Ctrl+Shift+Right Arrow

Combo or List Box

 

Open a Combo Box

F4 or Alt+Down Arrow

Move down one line

Down Arrow

Move down one page

Page Down

Move up one line

Up Arrow

Move up one page

Page Up

Exit the combo box or list box

Tab key

Navigate between Fields and Records

 

Move to the next field

Tab key or Right Arrow

Move to the last field in the current record

End

Move to the previous field

Shift+Tab or Left Arrow

Move to the first field in the current record

Home

Move to the current field in the next record

Down Arrow

Move to the current field in the last record

Ctrl+Down Arrow

Move to the last field in the last record

Ctrl+End

Move to the current field in the previous record

Up Arrow

Move to the current field in the first record

Ctrl+Up Arrow

Move to the first field in the first record

Ctrl+Home

Go to a specific record

Alt+F5

Enter data in a Datasheet or Form view

 

Insert the current date

Ctrl+Semicolon (;)

Insert the current time

Ctrl+Shift+Colon (:)

Insert the default value for a field

Ctrl+Alt+Spacebar

Insert the value from the same field in the previous record

Ctrl+Apostrophe (')

Add a new record

Ctrl+Plus Sign (+)

In a datasheet, delete the current record

Ctrl+Minus Sign (-)

Save changes to the current record

Shift+Enter

Switch between the values in a check box or option button

Spacebar

Insert a new line in a Short Text or Long Text field

Ctrl+Enter


डेटाबेस मैनेजमेंट सिस्टम / एम एस एक्सेस प्रैक्टिकल
MS-Access Practicals

डेटाबेस मैनेजमेंट सिस्टम / एम एस एक्सेस प्रैक्टिकल के अंतर्गत एम एस एक्सेस के प्रैक्टिकल माइक्रोसॉफ्ट एक्सेस में टेबल, फॉर्म, क्वेरी, रिपोर्ट, डेटाबेस में डाटा को इम्पोर्ट / एक्सपोर्ट करना आदि के प्रेक्टिकल उपलब्ध कराए जा रहे हैं।


डेटाबेस मैनेजमेंट सिस्टम / एम एस एक्सेस ऑनलाइन टेस्ट सीरीज
Online Test MS-Access

डेटाबेस मैनेजमेंट सिस्टम (DBMS/MS-Access) ऑनलाइन टेस्ट सीरीज आपकी सुविधा के लिए पूरी तरह से मुफ्त है। कोपा-गाइड सभी कंप्यूटर विषयों कंप्यूटर फंडामेंटल, ऑपरेटिंग सिस्टम, एमएस-ऑफिस, डेटाबेस मैनेजमेंट सिस्टम, इंटरनेट और एचटीएमएल, जावा स्क्रिप्ट, प्रोग्रामिंग विथ वीबीए, अकाउंटिंग सॉफ्टवेयर, टैली, इंटरनेट और ई कॉमर्स के ऑनलाइन टेस्ट सीरीज उपलब्ध कराता है।


डेटाबेस मैनेजमेंट सिस्टम / एम एस एक्सेस वीडियो ट्यूटोरियल्स
Video Tutorials MS-Access

डेटाबेस मैनेजमेंट सिस्टम / माइक्रोसॉफ्ट एक्सेस के वीडियो ट्युटोरियल्स की सहायता से आप डेटाबेस मैनेजमेंट सिस्टम / माइक्रोसॉफ्ट एक्सेस को हिंदी भाषा में आसानी से समझ सकते हैं. यह हिंदी वीडियो ट्युटोरियल्स सभी के लिए नि:शुल्क हैं.


Microsoft Access Shortcut Keys Various Keys to perform Task in Access. MS-Access Hindi Notes Books, PDF Download. Learning MS-Access in Hindi. MS-Access Project. What is DBMS? Database Management System. How to Use MS Access? Introduction to DBMS-MS Access. Microsoft Access Hindi Tutorials. Creating database in MS-Access. How to create table in MS-Access? Database Records, Fields, Table. How to create forms in MS-Access? Creating Queries in MS-Access? Form Design Controls. Microsoft Access Hindi Notes Books, PDF Download. Free Online Database Notes in Hindi. DBMS Database Management System / MS Access in Hindi. Learn Basic to Advance DBMS-MS Access Free Online Tutorials in Hindi and also test your preparation for online computer exam. In this tutorial series we provide notes, books, pdf for DBMS Database Management System / MS Access in Hindi. DBMS Free Online Mock Test Series Online Database Test - Online Tests for Interview, Competitive Exams. Creating database and designing a simple tables in Access. Creating Relationships and joining tables. Creating Forms. Creating simple select queries with various criteria and calculations.Creating Simple update, append, make table, delete and crosstab queries on Reports.Creating Simple update, append, make table, delete and crosstab queries on Forms. Modifying form design with controls,Importing and exporting data to and from Access, Compressing and Encrypting databases Practical on Forms settings and button, textbox, label , check box, combo box properties. Relational Database Management System. Microsoft Access Practical Examples in Hindi Tutorials.  

Dbms Quiz   Basic Computer Online Tutorials is very helpful for computer learners, students of various computer course like CCA, DCA, BCA, PGDCA, ITI-COPA and aspirants of competitive examinations. These Online Tests are free for all candidates and available in Hindi Language to better understanding for the computer subjects.

COPA-Guide provides free online tutorials, notes, pdf books in Hindi for Computer FundamentalOperating System, MS-Office, Database Management System, Internet & HTMLJava ScriptVBAAccounting SoftwareTallyInternet and E commerce

 

||    Theory    ||    Practicals    ||    Video Tutorials    ||    Online Test Series   ||