Forum home » Delegate support and help forum » Microsoft Access Training and help » Access shortcuts
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access shortcuts
Resolved · Low Priority · Version 2003
Reply Mon 3 Nov 2008, 11:29Delegate Filsan said...
Filsan has attended:
Access Introduction course
Access shortcuts
Can you please provide mw with any key combinations that can save time while using access.
For upcoming training course dates see: Pricing & availability
Reply Tue 4 Nov 2008, 21:47Delegate Mark said...
RE: Access shortcuts
Hi Filsan,
There are lots of shortcuts and 'made easy' functionalities that can be used in access. The number of them can be regarded as limitless. What you need to use depends on where you are using them.
If you are working directly with an access table and wish to copy an entry within the same field from one record line to the next, use holding down CTRL key with key press of appostrophe ' to copy. This also works in other places showing more than one record such as query results, and forms (when the form is as per default set up not with records locked or Edit unenabled). It will also work with forms in single view (but of course then you may not see the previous entry unless you have shown it in a subform or specialsed field cell).
Have you looked in the full access tips given in the foot area of these forum pages? There is a Tip given, but look lower down for the click on link to Show All Tips.
One that may not be in that lot is adding the ampersand character & to the front of labels that are associated with any 'field window' or button on a form (ie any form control). What this does is underline the first letter of the field name (as it appears on the form) and allows you to go straight to that field using the Alt key and the undelined letter. So say you are entering details of products in and you decide on price some time later, when you go back to the form you can Alt+P to go straight in and enter the price.
If you have a form for data entry and some fields are rarely used or data entered at a different time or by different user to a given set of fields, you can disable the tab stop in the properties for the fields concerned. In any case making sure your tab order on a form is correct can make life easier.
Good use of combo box drop downs including, where appropriate, putting criteria behind the supply to these is a fundamenetal but extremely good way of improving database usability and efficiency.
If you ever have to enter time of booking (or whatever it is that created a record needing a record creation time) then don't enter the time, just put =Now() in the Default property of your Time/Date field and in the format property for the field put a time format. The the time is automaitically put in when you create the recored. Or put in a date format if you want the date, or you can show date and time. If you wonly wnat date you can also use =Date()
There are probably thouands of examples like this. Macros, modules and VBA code really go further in helping the machines work for us. Reasons to love Access!
RE: Access shortcuts
Dear Filsan
Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.
Please find attached the list of short cut keys for Access. It is a pdf format so I am hoping that I would be able to upload the file for your viewing!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Attached files...
access_keyboard_shortcuts.pdf
|