Microsoft Access Shortcuts
Importing a Microsoft Word table To import a Microsoft Word table into Access follow the steps described below:
In Word select the table you wish to import, click on the Table menu, select Convert and click Table to Text
Copy your selected table into a new document and save it as a text file
In Access use the Get External Data command to import the contents of your newly created text file
Use wildcards in the search text box You can use wildcards such as question mark (?) and asterisk (*) in the search text box. The question mark will match any single character, for example, s?t will find "set" and "sat". The asterisk will match any number of characters, for example, s*d will find "sad", "started" and "standard".
Display current date and time in a column of any width The function =NOW() will return the current date and time, but when entered in a column which is not wide enough to display the returned value the cell displays ###. You could get round this by widening the column but this is not always convenient, the column may already be at its maximum width to be able to see all the columns on one screen or it may force you to change your print settings. The solution is to use the TEXT function to convert the value returned by the NOW function to text. Text, as opposed to a number, will stretch into the next column. There are two arguments in the TEXT function. The first is the value to convert to text, the second is the format to show it in. Custom number codes in quotation marks should be used to specify the format. For example, TEXT(NOW(),"ddd dd/mm/yy hh:mm") will return the current date and time in the format MON 09/10/06 11:38.
Archiving data If you can't bear the thought of deleting obsolete records you can instead flag them with a Yes/No field. You can then use the value in this field to determine whether to show records. For example, you could only display records with a Yes value in your queries, reports, forms and so on.
Automatically compact and repair To ensure optimum performance you should compact and repair your Microsoft Access files regularly. In the Tools menu select Database Utilities and then click on Compact and Repair Database. You can simplify the process and get Access to do this for you automatically by completing the following steps:
Open the Access database or project you want Access to compact automatically On the Tools menu select Options Click on the General tab Select the Compact on Close check box
Shortcuts It is true that the keyboard is faster than the mouse for a number of commonly used tasks because you don't have to go through the point, select and click sequence. Here is a list of speedy keyboard shortcuts that you can use to save you time when working with your Access databases.
Moving records Add a new record CTRL++ Cut current line and copy to clipboard CTRL+Y Delete current record CTRL+- Insert new line CTRL+ENTER
Moving through database Move to beginning of multiple line field CTRL+HOME Move to end of multiple line field CTRL+END Move to first field in first record (Navigation mode) CTRL+HOME Move to last field in last record (Navigation mode) CTRL+END Move to page number/record number box F5 Next window CTRL+F6
Find and replace Find CTRL+F Find next SHIFT+F4 Find previous SHIFT+F3 Goto CTRL+G Replace CTRL+H
Misc Close CTRL+W Copy CTRL+C Cut CTRL+X Edit/navigation mode (toggle) F2 File/Save As F12 Save current record SHIFT+ENTER
More tips For some more tips when using Microsoft Access, why not visit the Tips and Tricks page?
Related Tags: help, free, tips, microsoft, tip, tricks, access, database, msaccess, ms access, mdb
Danny Wareham is founder of DataMouse.biz. They are a UK-based company, specialising in Microsoft Office development (specifically MS Access and MS Excel), web graphic and icon design, and web design.
Your Article Search Directory : Find in ArticlesRecent articles in this category:
- Improper Way Of Marketing Reflects Poorly On A Company.
New business, product or service everything requires visibility, awareness in order to come into the - Replacing Paper Prints With Online Versions
Nowadays saving out on resources and being additionally informative are both aspects that are in. In - Stop Smoking Effectively
If I told you of a way that you could stop smoking harmful tobacco would you believe it? Most people - What Is Runtime Error 182? And How To Fix It
Are you finding an effective way to fix runtime error 182? Do you think fixing runtime error 182 is - Do You Know How To Fix Runtime Error 87 In Minutes?
Are you finding an effective way to fix runtime error 87? Do you think fixing runtime error 87 is to - Knowledge About Avi, Avi Player, Avi Converter On Mac
Knowledge about AVI, AVI player, AVI Converter on MacWhat is an AVI?AVI, an acronym for Audio Video - Buy Your Highly Successful Email Survey Software Today
Email Survey Software- Boost Your Business and Increase ProfitsAn email survey software could be one - Xrm - The Anything Relationship Management Solution
I recently attended the Microsoft Dynamics West Region FY11 Sales Planning Retreat. This year's meet - What Are The Benefits Of Working With Electronic Medical Records
Recording medical information is a vital part of health care services. These records are necessary f - Basic Factor To Make Website Business Oriented
Internet is home for millions of websites. The online business is becoming more and more competitive
Most viewed articles in this category:
- Parental Control Software
Parental control software is software that can help parents protect their children when they are onl - Digital Asset Management Software
Managing and organizing your organization's documents is a critical component to your business's suc - AdobeRGB vs. sRGB
Understanding color spaces I'll try to explain it very simplified, but understandable for everyone - Confessions of a Prankster
I wanted to get a jump on April Fool's Day, partially because of the long, cold winter blues, and pa - Malicious Thoughts About The Spyware Ills Of My PC
Who would think I was capable of such revengeful thoughts about the parties responsible for inflicti - Recover File and Recover Deleted File Tools
Data recovery software is a very effective way of retrieving data from a worn or damaged hard disk d - Life without Windows
Ubuntu, a user-friendly version of Linux, has been running so nicely on my home PC that I decided to - What Benefit Does an Online Software Download Site Offer You?
Are you having a problem that where you find a good softeware when you consider to have a try or wan - Maintaining A Website
There was an era when people were talking about how to create a website using html coding or some ea - Benefits Of Proper Time Tracking
Have you ever written down time when you have started and finished your work? Maybe you have had mul