If you enter data regularly, becoming familiar with data entry and navigation shortcuts can save you significant time and effort. But there are several lesser-known accelerator shortcut keys that can simplify your typing and keep you working mouse-free.
The lists below include some of the shortcuts that I find most useful, but Access offers many more shortcuts for you to take advantage of.
For a list, refer to the "Keyboard Shortcuts" topic online or in the Microsoft Access help file. For details, refer to the following topics online or in the Microsoft Access help file: Keyboard shortcuts for Microsoft Access. Remembering these shortcuts may seem like a pain, and they may even slow you down at first. If you make a conscious effort to use them, however, they will become second nature. Microsoft Access within an Organization's Database Strategy.
How many simultaneous Microsoft Access users? Blaming Microsoft Access instead of the Developer. Microsoft Access Version Feature Differences.
Split Database Architecture for Multiuser. Field Type Consistency. Table Normalization Tips. Avoid Unnecessary or Duplicate Indexes. Replace Attachment Field Paperclip Icon. Avoid Decimal Data Types. Microsoft Access Query Tips and Techniques. Copy Command Button and Keep Picture. Resync Record in a Subform. Subform Reference to Control Rather than Field. Annual Monthly Crosstab Columns.
Add Buttons to the Quick Access Toolbar. Collapse the Office Ribbon for more space. Avoid Exits in the Body of a Procedure. Shortcut Debugging Keys. Rename a File or Folder. Error Handling and Debugging Techniques.
Error Number and Description Reference. Basic Error Handling. Pinpointing the Error Line. Disable Design Changes. Terminal Services and RemoteApp Deployment. Reboot Remote Desktop. Unavailable Mapped Drives. Disaster Recovery Plan. Class Not Registered Run-time Error Inconsistent Compile Error. Error Could Not Use.
Celebrating our 35th Year of Software Excellence. Vienna, Virginia Privacy Policy Webmaster. Toggle navigation. Products Microsoft Access Products.
All Microsoft Access Products. Total Access Admin. Total Access Analyzer. Total Visual CodeTools. Total Access Components. Total Access Detective. Total Access Memo. Total Visual SourceBook. Total Access Speller. Total Access Startup. Total Access Statistics. Multi-Product Suites. Total Access Ultimate Suite. Total Access Developer Suite.
Total Visual Developer Suite. Visual Basic 6 Products. Total Visual Agent. Total VB Statistics. Total VB Microsoft access 2013 shortcut keys free download Suite. Other Products. Sentinel Visualizer.
Total ZipCode Database. All Products: Demos, Catalog, Awards, etc. All Products. Product Awards. Forum and Ticket Submissions. Support Options. Basic Shortcut Keys. This is invaluable if you keep historical records, or include the date microsoft access 2013 shortcut keys free download any notes or other fields in your database.
It not only saves time, but ensures data accuracy and keeps you from having to remember the date. Like the Insert Date shortcut, this feature can save more time than you realize, and it also helps to keep your data accurate.
When you need to enter several records consecutively, you probably find that many of the fields are the same from record to record. Using the clipboard to copy data microsoft access 2013 shortcut keys free download help, but you may need to enter several fields of duplicate information your name in one field, the date in another field, and some generic comments in a third.
Use this shortcut to insert the same field's value from the previous record. This comes in handy when you start typing, and then realize that you should have kept the default. Navigation mode hides the insertion point, and selects the entire field.
When in Navigation mode, use the arrow keys to move between fields. Database Window and Searching. Data Refresh. Useful when the lookup table's data changes. Microsoft access 2013 shortcut keys free download to Access Developer Help Center. Microsoft Access Developer Center. Excel How many simultaneous Microsoft Access users? Best Practices.
Table Design. Query Design. Form Design. Report Design. Design Environment. VBA Programming. Source Code Library. VBA Error Handling. Performance Tips. System Admin.
Database Corruption. SQL Server Upsizing.