Skip to main content

Ms Access Shortcut Key

Here are some common Microsoft Access shortcut keys along with their explanations:


1. Ctrl + N: New Database

   - Opens a new blank database file in Microsoft Access.


2. Ctrl + O: Open Database

   - Opens an existing database file in Microsoft Access.


3. Ctrl + S: Save Database

   - Saves the changes made to the current database file.


4. F12: Save As

   - Opens the "Save As" dialog box to save the current database with a new name or at a different location.


5. Ctrl + Z: Undo

   - Reverses the last action performed in Microsoft Access.


6. Ctrl + Y: Redo

   - Redoes the last undone action in Microsoft Access.


7. Ctrl + C: Copy

   - Copies the selected data or object to the clipboard.


8. Ctrl + X: Cut

   - Cuts the selected data or object and places it on the clipboard for pasting.


9. Ctrl + V: Paste

   - Pastes the content from the clipboard into the current location.


10. Ctrl + F: Find

    - Opens the "Find" dialog box to search for specific data within the current database.


11. Ctrl + H: Replace

    - Opens the "Replace" dialog box to find and replace specific data within the current database.


12. Ctrl + A: Select All

    - Selects all the data or objects in the current view.


13. Ctrl + P: Print

    - Opens the Print dialog box to print the current database object.


14. Ctrl + F4: Close

    - Closes the current database object.


15. Ctrl + F6: Next Pane

    - Switches to the next pane in the database window.


16. Ctrl + Tab: Next Tab

    - Switches to the next tab within the active object, like moving between tables or queries.


17. Ctrl + Shift + F2: Zoom to 100%

    - Resets the zoom level of the current view to 100%.


18. Ctrl + : (Colon): Insert Current Date

    - Inserts the current date into a field with Date/Time data type.


19. Ctrl + ; (Semicolon): Insert Current Time

    - Inserts the current time into a field with Date/Time data type.


20. Alt + Enter: Open Property Sheet

    - Opens the property sheet of the selected object.


21. F4: Open Property Sheet for Selected Control

    - Opens the property sheet for the selected control (in forms and reports).


22. F11: Database Window

    - Opens or closes the database window, which allows you to switch between different objects in the database.


These shortcuts can be very handy and save you a lot of time when working with Microsoft Access databases. Keep in mind that some shortcuts might vary depending on the version of Microsoft Access you are using and your operating system.

Comments

Post a Comment

Popular posts from this blog

Microsoft Word 2010 Shortcut Key in Gujarati

Microsoft Word 2010 Shortcut key in Gujarati
16 comments
Read more

How to create YouTube channel and get approved monetization

 Creating a YouTube channel and getting approved for monetization involves several steps. Here's a step-by-step guide to help you through the process: 1. **Create a Google Account**: If you don't have one, sign up for a Google Account. This account will serve as the foundation for your YouTube channel. 2. **Sign in to YouTube**: Using your Google Account, sign in to YouTube (https://www.youtube.com). 3. **Create Your Channel**: Click on your profile picture (if you have one) or the "Create" button in the top right corner of the YouTube homepage. Select "Create a channel" and follow the prompts to create your YouTube channel. 4. **Channel Name and Description**: Choose a name for your channel that represents your content. Write a channel description that explains what your channel is about. 5. **Channel Art and Profile Picture**: Customize your channel by adding channel art (banner) and a profile picture that reflect your brand or content. 6. **Upload Content
Post a Comment
Read more

List of all option in tally prime with explanation

 As of my knowledge cutoff in September 2021, TallyPrime is the latest version of Tally software, and it introduced a more user-friendly interface and several new features. Here is a list of some of the main options available in TallyPrime along with brief explanations: 1. **Dashboard**:    - The Dashboard provides an overview of critical business information, such as cash and bank balances, outstanding receivables and payables, and stock summary. 2. **Accounting Vouchers**:    - Accounting Vouchers are used to record financial transactions, such as payments, receipts, sales, purchases, journal entries, etc. 3. **Inventory Vouchers**:    - Inventory Vouchers are used to manage stock-related transactions, including stock transfers, stock journals, manufacturing entries, and more. 4. **Banking**:    - This option allows you to manage bank-related transactions, including cheque printing, bank reconciliation, and payment transactions. 5. **Payroll**:    - The Payroll feature enables you to
Post a Comment
Read more