Unique Free Articles. Free submission.
Search:

Unique Free Article:
'Microsoft Access Cheat Sheet: Tips and Shortcuts'

Article Source: http://www.unique-free-articles.com


Author is a trainer with a www.microsofttraining.net/microsoft-office-training.php'>Microsoft Office training company, the UK industry leader in its sector. For more information on www.microsofttraining.net/access-training.php'>Access training, visit www.microsofttraining.net/'>www.MicrosoftTraining.net.



"....The asterisk will match any number of characters, for example, s*d will find 'sad', 'started' and '.....
.....microsoft access training....."


Microsoft Access is a database management system that allows you to govern and process data in a database, which has rapidly become the database of election for Windows based database development. This article aims to make provision some instrumental tips and shortcuts to help you when using Access.

Tips

Here are a few homely tips to make using Access easier:

Importing a Microsoft Word table

To import a Microsoft Word table into Access 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 ordinance to import the lading of your of late 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. If you are self taught and have not had any Microsoft Access training you are like enough unaware of the divers shortcuts available within Access. 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 reimburse the current date and time, but when entered in a column which is not wide enough to display the returned esteem the cell displays 3 hash symbols. The question mark will match any single character, for example, s?t will find 'set' and 'sat'. The solution is to use the TEXT function to convert the measurement returned by the NOW function to text. 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 distributeADJ Mixture settings. There are two arguments in the TEXT function.

Text, as opposed to a number, will spring back into the next column. Custom number codes in quotation marks should be used to realize the format. The first is the appraise to convert to text, the second is the format to show it in. You can then use the measurement in this field to determine whether to show records. For example, TEXT(NOW(),'ddd dd/mm/yy hh:mm') will give back the current date and time in the format MON 09/10/06 11:38.

Archiving data

If you can't bear the reflection of deleting no longer in use records you can instead flag them with a Yes/No field. In the Tools menu select Database Utilities and then click on Compact and Repair Database. For example, you could only display records with a Yes valuation in your queries, reports, forms and so on.

Automatically bargain and repair

To ensure optimum performance you should agreement and repair your Microsoft Access files regularly. Here is a catalogue UK 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 stand field in remain 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



"..... You can simplify the process and get Access to do this for you automatically by final the following steps:

-Open the Access database or project you want Access to stipulation 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 you don't have to go through the point, select and click sequence. You can simplify the process and get Access to do this for you automatically by final the following steps:

-Open the Access database or project you want Access to stipulation 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 you don't have to go through the point, select and click sequence...."

Additional Articles From - Home | Computers And Technology | Software
  • One Powerful Software For Shareware Author - By : iSnare Articles
  • easy photo sharing ~ Easy Photo Sharing -- Out Of The Shoebox And Into Your PC ~ easy photo printing - By : iSnare Articles
  • antivirus ~ Panda Software Internet Security 2008 Provides More Than Just Antivirus Protection ~ software - By : iSnare Articles
  • copy tv shows to dvd ~ How To Copy Television Sitcoms To DVD Disc ~ dvd copy - By : Isaiah Henry
  • record audio ~ Record Your Favorite Show into an MP3 File ~ record podcast - By : Ivan Gerasymchuk
  • FlippingBook ~ FlippingBook Joomla Gallery for Joomla 1.5 - a totally new approach to creating galleries. ~ Flipping Book - By : Mediaparts Interactive
  • Matchmaking software to get hundreds more friends - By : Steve Silvester
  • copy copyrighted dvd ~ copy copyrighted dvd ~ Ways to Clone from CSS Encrypted DVD Movies ~ dvd copy ~ dvd copy - By : Isaiah Henry
  • console accessories ~ console accessories ~ Various Types Of Console Accessories ~ game consoles ~ game consoles - By : iSnare Articles
  • recruiting ~ recruiting ~ Using Software To Help You Recruit ~ software ~ software - By : Shaun Parker


    • RSS XML Search N Find Articles
    Click the XML Icon Above to Receive Software Articles Via our RSS system!

    Microsoft Access Cheat Sheet: Tips and Shortcuts
    Authors Register Here
    Sign Up for a free account or learn more.
    Main Menu
    Home
    Submit Articles
    Member Login
    Top Authors
    Most Popular Articles
    Submission Guidelines
    Ezine Notifications
    Article RSS Feeds
    Info
    New Stuff
    About Us
    Link to Us
    Contact Us
    Privacy Policy
    Terms of Service
    Software Download
    Article Directory Software
    Click here to download the exact software that powers this directory for FREE. Start your own article directory today!

    Partners

    Powered by Article Dashboard