What are the common microsoft office access 2010 keyboard shortcut to perform a task free download. Access 2013: The Missing Manual by Matthew MacDonald
Keyboard shortcuts for OneDrive for work or school. Keyboard shortcuts for Sticky Notes. Keyboard shortcuts for Access. Keyboard shortcuts for Visio. Keyboard shortcuts for Sway. Keyboard shortcuts for Office Delve. Keyboard shortcuts for the File menu in Office for Windows. Keyboard shortcuts for SmartArt graphics in Office for Window. Use a. The keyboard shortcut keys listed in this topic are for Access desktop databases including keys for navigating records, ribbon commands, online help, and others. There are also keyboard shortcut keys listed in this topic available when you are customizing an Access web app or when you are using an Access web app in the browser. Use an Access keyboard shortcut instead of the mouse to work . These keyboard shortcuts are especially useful in Access Some keystrokes work anywhere in Access , while others work only in specific views, as noted. Keystroke Function F1 Opens the Help window Alt+f Opens Backstage view Ctrl+n Create a new blank database Ctrl+o Open an existing database Ctrl+p Opens Print dialog box F11 Show/hide Navigation [ ].
1. Creating Your First Database – Access The Missing Manual [Book]
Open the File tab to use the Backstage view. Microsoft Access is one of the applications for managing database system, comes with Keyhoard office suite of applications. Was this information helpful? Display the complete hyperlink address URL for a selected hyperlink.
What are the common microsoft office access 2010 keyboard shortcut to perform a task free download
Alternatively, you can use the backup feature described in the previous section. When you create a new database, Access uses its modern. Microsoft introduced the. That makes it the go-to choice for new databases. However, there may be times when you need to share your data with people who are using truly ancient copies of Access.
Versions before Access use a different database format, called. And, as you can see in Figure , the. The standard. But if you need to share databases with people running much older versions of Access, the. Older database formats are less reliable and may not support all of the Access features you want to use. The best approach is to stick with the.
However, if possible, keep using the modern. You can also use the old-style. Access opens the File New Database window which you saw back in Figure Instead, Access is more concerned with getting information in and out of the database as quickly as it can. If you want to trim your database back to size, you can use a feature called compacting.
Access then closes your database, compacts it, and opens it again. If you compact a brand-new database, Access shows a harmless security warning when the database is reopened. The only problem with the database-compacting feature is that you need to remember to use it. If you want to keep your databases as small as possible at all times, you can switch on a setting that tells Access to compact the current database every time you close it. Open the database that you want to automatically compact.
To open one, just click it. Incidentally, you see the same list of recent databases when you first start Access Figure Do you want to hide your recent work?
Or, just click the big Browse button underneath to hunt around in the current folder. When you find the file you want, double-click it. If you want to keep your database on the Web, you need the web database feature described in Chapter Finally, as always, you can open a database file from outside Access by simply double-clicking it in Windows Explorer or on your desktop.
Access pops up a message bar with a scary-sounding security warning Figure In those situations, you need to know if Access trusts your database and will allow it to run code and action queries. You have two options:. Click the X at the right side of the message bar to banish it.
Click Enable Content to tell Access that it can trust this database. If you want to see more than one database at a time, you need to fire up more than one copy of Access at the same time. Computer geeks refer to this action as starting more than one instance of a program. If you double-click another database file while Access is already open, a second Access window appears in the taskbar for that database. Access handles old database files differently, depending on just how old they are.
However, if you change the design of the database, the new parts you add may not be accessible in Access anymore. If you attempt to open an older Access file like one created for Access 95 or 97 , Access presents a warning message…and gives up. If you need to rescue valuable data trapped in a Paleolithic database, your best bet is to find someone who still has a copy of Access , which can handle older file formats. Instead, the table opens in an ordinary window that can float wherever it wants inside the main Access window.
This seems fine at first, until you open several tables at once. This somewhat unfriendly behavior is designed to mimic old versions of Access, like Access All you need to do is set a single configuration option:. Under the Application Options heading, look for the Document Windows Options setting, where you can choose Overlapping Windows the Access standard or Tabbed Windows the wave of the future. Close and open your database so the new setting takes effect.
For a retro touch, you can use the same setting to make a brand-new Access database use overlapping windows instead of tabs. For example, if you have more than one table, you need a way to move back and forth between the two. That tool is the navigation pane, shown in Figure The navigation pane shows the objects Understanding Access Databases that are part of your database, and it lets you manipulate them.
The navigation pane has several different viewing modes, so you can home in on exactly what interests you. When you first create a database, the navigation pane shows only the tables in your database.
To try out the navigation pane, you need a database with more than one table. Follow the steps starting on Creating a Simple Table to define the table and insert a record or two. Not sure what table to create? Try creating a Collectors table that tracks all the friends you know who share the same bobbleheaded obsession.
If you want to open a table, then, in the navigation pane, just double-click it. If you have more than one datasheet open at once, Access organizes them into tabs see Figure In this situation, Access adds tiny scroll buttons to the left and right of the tab strip. You can use these buttons to move through all the tabs, but it takes longer. Most people are happy to have the ribbon sitting at the top of the Access window, with all its buttons on hand.
However, serious data crunchers demand maximum space for their data. To do so, just double-click the current tab title. Even when the ribbon is collapsed, you can still use all its features. Just click a tab. If you click Home, the Home tab pops up over your worksheet.
As soon as you click the button you want in the Home tab or click somewhere else in the Access window , the ribbon collapses itself again. The same trick works if you trigger a command in the ribbon using the keyboard, as described on Using the Ribbon with the Keyboard. If you use the ribbon only occasionally, or if you prefer to use keyboard shortcuts, it makes sense to collapse the ribbon.
Even when collapsed, the ribbon commands are available; it just takes an extra click to open the tab. So far, you know how to open a table using the navigation pane. You can actually perform three more simple tasks with any database object that shows up in the navigation pane:. Rename it. Right-click the object, and then choose Rename. Note: For controls in a stacked layout, this switches the position of the selected control with the control directly below it, unless it is already the lowermost control in the layout.
Note: For controls in a stacked layout, this increases the width of the whole layout. Note: For controls in a stacked layout, this decreases the width of the whole layout. Note: If used with a control that is in a layout, the entire row of the layout is resized.
Note: If used with a control that is in a layout, the entire column of the layout is resized. These keyboard shortcuts work in Navigation mode in the Form View. Move up one page, or at the end of the record, move to the equivalent page on the previous record. Note: If multiple items are selected, pressing Spacebar affects all selected items.
Select multiple items by holding down Shift while selecting them. Toggle the selected state of a single item by holding down Ctrl while selecting it. Note: If multiple items are selected, pressing this key affects all selected items. You can use the standard Windows editing keys when working in the SQL pane.
You can only insert text; there is no overtype mode. As an alternative, press F2. Learn how to use your keyboard to select a field, record, or text within a field. You can also use keyboard shortcuts to extend your selection or find and replace text or data. Note: To cancel a selection, use the opposite arrow key. Switch between selecting the current record and the first field of the current record, in Navigation mode.
F8, then repeatedly F8 to extend the selection to the word, the field, the record, and all records. Extend a selection to adjacent fields in the same row in the Datasheet View. Find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed in the Datasheet View and Form View only. Use the keyboard shortcuts in the following sections to navigate to an insertion point within a field, copy, move, or delete text, and undo changes.
You can also use your keyboard to enter data in the Datasheet View or Form View and refresh fields. Note: If the insertion point is not visible, press F2 to display it. Move the insertion point to the end of the field, in single-line fields or move it to the end of the line in multiline fields.
Move the insertion point to the beginning of the field, in single-line fields or move it to the beginning of the line in multiline fields. Esc If both the current field and current record have been changed, press Esc twice to undo changes, first in the current field and then in the current record. Requery the underlying tables or in a subform, requery the underlying table only for the subform. Use the keyboard shortcuts in the following sections to navigate and move around in tables and cells.
Select the next hidden text or hyperlink, including Show All or Hide All at the top of a topic. Perform the action for the selected Show All , Hide All , hidden text, or hyperlink. Scroll larger amounts up or down, respectively, within the currently displayed Help topic. Switch among areas in the Help window, such as the toolbar and the Search list. Open the Zoom box to conveniently enter expressions and other text in small input areas.
Screen reader support for Access. Use a screen reader to explore and navigate Access. Use a screen reader to start Access. Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance.
The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region. If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk. Office Accessibility. Keyboard shortcuts for Access. Notes: The shortcuts in this topic refer to the US keyboard layout.
A comma sign , in a shortcut means that you need to press multiple keys in order. Need more help? Not enough information. Not enough pictures. Any additional feedback?
Submit feedback. Thank you for your feedback! Open the File page to use Backstage view. Select the active tab on the ribbon and activate the access keys. Alt or F To move to a different tab, use access keys or the arrow keys. Show the tooltip for the ribbon element currently in focus.
When a menu or submenu is open, move to the next command. Move to the submenu when a main menu is open or selected. Move the cursor by scrolling the document view up by one screen.
Move the cursor by scrolling the document view down by one screen. Move the cursor to the location of the last revision made before the document was last closed. Cycle through floating shapes, such as text boxes or images. Exit the floating shape navigation and return to the normal navigation. Display the Navigation task pane, to search within the document content.
Cycle through the locations of the four previous changes made to the document. Open the list of browse options to define the type of object to browse by. Select from the current position to the beginning of the current line. Select from the current position to the end of the current line. Select from the current position to the beginning of the current paragraph.
Select from the current position to the end of the current paragraph. Select from the current position to the bottom of the screen. Select from the current position to the beginning of the document. Select from the current position to the end of the document.
Select from the current position to the bottom of the window. F8 In the extend selection mode, clicking a location in the document extends the current selection to that location. F2, move the cursor to the destination, and then press Enter. Copy the header or footer used in the previous section of the document. Display the Object dialog box, to insert a file object into the document.
Display the Apply Styles task pane. Switch the text between upper case, lower case, and title case. Apply underline formatting to the words, but not the spaces.
Display the Reveal Formatting task pane. Move to the next cell in the row and select its content. Move to the previous cell in the row and select its content. Update the linked information in a Word source document.
Display the Language dialog box to set the proofing language. Switch to the Read Mode view. In Word and , this is called Full Screen Reading view. Switch between showing the first line of body text and showing all body text.
Show all headings with the Heading 1 style. F1 alone: displays the Word help task pane. F4 alone: repeats the last command or action, if possible. F5 alone: displays the Go To dialog box. F9 alone: updates the selected fields.
F10 alone: turns KeyTips on or off. F11 alone: moves to the next field. F12 alone: displays the Save As dialog box. Display the Spelling and Grammar dialog box. Find text move focus to the Search in Document box. I know, I know, these are basic shortcuts and most of you are comfortable with them. Still, let me write them down again for beginners. The Ctrl and Alt keys are located on the bottom left and bottom right sides of most keyboards. Table of contents.
Must-have Excel shortcuts no workbook can do without Formatting data Working with formulas Navigating and viewing data Entering data Selecting data Must-have Excel shortcuts no workbook can do without I know, I know, these are basic shortcuts and most of you are comfortable with them. F12 Save the active workbook under a new name, displays the Save as dialog box.
Save my name, email, and website in this browser for the next time I comment. Post Comment. Data Recovery Software. Data Recovery Tools. Download For Mac.