Microsoft Access Shortcuts

Tips Here are a few simple tips to generate using Access easier:
Importing a Microsoft Word dining room table To import a Microsoft Word table into Discover follow the steps explained below:
In Word select the table you wish to import, click on a Table menu, select Make and click Table to Text
Copy your selected table into a new document and save it as the text file
In Access use the Get External Data receive to import the contents to your newly created text document

Use wildcards in the search text box You can use wildcards such as query mark (? ) and asterisk (*) in the search text box. The question mark will fit any single character, for example, s? t will obtain '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 almost any width The function =NOW() will return the prevailing date and time, but when entered in a column which is not wide enough to produce the returned value the particular cell displays ###. You could get round this by widening the column but this may not always convenient, the column may previously be at its maximum width to be able to see all the columns on one screen or it may force someone to change your print settings. The solution is to implement the TEXT function to convert the value returned by the NOWADAYS function to text. Text, as opposed to many, will stretch into the other column. There are two arguments during the TEXT function. The first is the value to convert to be able to text, the second is the format to show the item in. Custom number codes in quotation marks should be used to specify the actual 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 concept of deleting obsolete records you possibly can instead flag them with a Yes/No field. You can then use the value in this field to determine whether of showing records. For example, you could only display records by using a Yes value in ones queries, reports, forms and so on.
Automatically compact and repair To ensure optimum performance you really should compact and repair any Microsoft Access files regularly. In the Tools list select Database Utilities and then click on Compact and additionally Repair Database. You can simplify the process and get access to do this for a person automatically by completing the following steps:

Open the Access database or project you'd like Access to compact automatically To the Tools menu select Options Click on the General tab Select a 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 will not go through the phase, select and click pattern. Here is a directory of speedy keyboard shortcuts that you can use to save you time whenever using your Access databases.
Moving records Add a new record CTRL++ Cut current line and content to clipboard CTRL+Y Remove current record CTRL+- Set new line CTRL+ENTER
Moving through database Move to beginning of multiple line field CTRL+HOME Proceed to end of multiple line field CTRL+END Move to first field in very first record (Navigation mode) CTRL+HOME Proceed to last field in last record (Navigation mode) CTRL+END Proceed to page number/record number package F5 Next window CTRL+F6
Get and replace Find CTRL+F Uncover next SHIFT+F4 Find former SHIFT+F3 Goto CTRL+G Change CTRL+H
Misc Close CTRL+W Reproduce CTRL+C Cut CTRL+X Edit/navigation style (toggle) F2 File/Save Seeing that F12 Save current track record SHIFT+ENTER
More tips For more tips when making use of Microsoft Access, why not visit the Tips and tricks page?