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

Power Point Shortcut key

Below is a list of common PowerPoint shortcut keys along with their details: 1. New Presentation: Ctrl + N    - Creates a new, blank PowerPoint presentation. 2. Open Presentation: Ctrl + O    - Opens an existing PowerPoint presentation from your computer. 3. Save Presentation: Ctrl + S    - Saves the current presentation to its existing file location. 4. Save As: F12    - Opens the "Save As" dialog box to save the current presentation with a new name or at a different location. 5. Close Presentation: Ctrl + W    - Closes the current presentation. 6. Cut: Ctrl + X    - Cuts the selected content (text, images, etc.) and places it on the clipboard for pasting. 7. Copy: Ctrl + C    - Copies the selected content (text, images, etc.) to the clipboard for duplication. 8. Paste: Ctrl + V    - Pastes the content from the clipboard into the presentation. 9. Undo: Ctrl + Z    - Reverses the last action perfor...
Post a Comment
Read more

SQL Cheat Sheet

SQL cheat sheet with explanations for each command: 1. SELECT: Retrieve data from a database table.    Example: `SELECT column1, column2 FROM table_name;` 2. DISTINCT: Remove duplicate rows from the result set.    Example: `SELECT DISTINCT column FROM table_name;` 3. WHERE: Filter rows based on specific conditions.    Example: `SELECT * FROM table_name WHERE column = value;` 4. AND / OR: Combine multiple conditions in a WHERE clause.    Example: `SELECT * FROM table_name WHERE condition1 AND condition2;` 5. ORDER BY: Sort the result set based on one or more columns.    Example: `SELECT * FROM table_name ORDER BY column ASC;` 6. GROUP BY: Group rows based on specified columns (usually used with aggregate functions).    Example: `SELECT column, COUNT(*) FROM table_name GROUP BY column;` 7. HAVING: Filter groups of rows based on aggregate function results.    Example: `SELECT column, COUNT(*) FROM table_name GROUP BY col...
Post a Comment
Read more