Archive for 'Access'

Ms Access And Ms Excel – What To Do When Sorting Does Not Work

Posted 18 March 2010 | By Rolan | Categories: Access, Excel | No Comments

Author: Richard Killey

In both Microsoft Access and Microsoft Excel it is very easy to sort columns of text or numbers. Both programs supply us with toolbar buttons that allow either ascending sorts (1 … 999) or descending sorts (999 … 1). The Ascending button has a blue “A” above a red “Z” with a downward [...]

Twitter client using MS Access 2007

Posted 28 October 2009 | By Rolan | Categories: Access, MS Office, Microsoft Access, Office 2007, microsoft, microsoft office, twitter, twitter client | 2 Comments

//
Tweeting from your favorite Application!
Wouldn’t it be cool to tweet using your favorite MS Access application.  You will not have to worry about your boss passing at your back and seeing that you are browsing the internet and making tweets at tweeter.  While doing your regular duties as a database programmer or [...]

Short-Cut keys for Microsoft Office

Posted 13 October 2009 | By Rolan | Categories: Access, Excel, MS Office, Microsoft Access, Office 2007, Powerpoint, Word, microsoft, microsoft office, microsoft outlook, ms word | No Comments

Author: Wesley Skiles
All of the Microsoft Office programs include the use of quick keys. Quick keys are simple short cuts for functions that are done using the ‘Ctrl’ key and a corresponding letter. There are a few quick keys that are fairly well known but there are many more that users do not use that [...]

Why Consider Access Visual Basic Training?

Posted 12 October 2009 | By Rolan | Categories: Access, MS Office, Microsoft Access, microsoft, microsoft office, vba, visual basic | No Comments

Author: Suzanne Mullett
Having reached a high level of proficiency in Microsoft Access you may be looking for a new challenge. It is logical to assume that the more you and your employees learn about a piece of software, the more productive you and your company can become. By taking your skills to [...]

Microsoft Access: Your Total Business Solution

Posted 12 October 2009 | By Rolan | Categories: Access, MS Office, Microsoft Access, Office 2007, microsoft, microsoft office | 1 Comment

Author: Microsoft Access Developers – Data Gopher
Microsoft Access is often times overlooked by businesses as an effective all around business solution. Many times businesses’ will opt for expensive vendor software that is very expensive and often times does not provide the flexibility of enhancements without the need for paying the software vendor a huge amount [...]

How I achieved 1000% Increase in Efficiency with MS Access!

Posted 08 October 2009 | By Rolan | Categories: Access, MS Office, Microsoft Access, Office 2007, microsoft, microsoft office | No Comments

When I was still a Credit and Collection Analyst for a big appliance company, I was tasked to handle the processing of reports for the discount and promo data for all the appliance dealers of the company I worked for.  Their sales data was forwarded to our department by our I.T. Unit.
The data was in [...]

How to get answers for your Office 2007 questions?

Posted 23 September 2009 | By Rolan | Categories: Access, MS Office, Office 2007, Word, microsoft, microsoft office, ms word | No Comments

You can go to microsoft’s website at Office Online for various Office 2007 and previous versions for information about your questions.  They also have their Templates tab for your “microsoft office templates” that you need.  They have various ms office 2007 templates for ms word, ms excel, ms access, powerpoint presentation templates and powerpoint backgrounds. [...]

Powered by WP Robot

PHVsPjxsaT48c3Ryb25nPndvb19hYm91dF9iaW88L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19hYm91dF9ncmF2YXRhcjwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2Fib3V0X3JlYWRtb3JlPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fYWRzX3JvdGF0ZTwvc3Ryb25nPiAtIGZhbHNlPC9saT48bGk+PHN0cm9uZz53b29fYWRfYmxvY2tfYWRzZW5zZTwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2Jsb2NrX2ltYWdlPC9zdHJvbmc+IC0gaHR0cDovL3d3dy5teW1zb2ZmaWNlLm5ldC93cC1jb250ZW50L3VwbG9hZHMvMjAxMC8wOC9mcmVld2luMjAwMC5naWY8L2xpPjxsaT48c3Ryb25nPndvb19hZF9ibG9ja191cmw8L3N0cm9uZz4gLSBodHRwOi8vd3d3LmV4YW1zaW11bGF0b3JzLm15bXNvZmZpY2UubmV0PC9saT48bGk+PHN0cm9uZz53b29fYWRfY29udGVudF9hZHNlbnNlPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fYWRfY29udGVudF9kaXNhYmxlPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19hZF9jb250ZW50X2ltYWdlPC9zdHJvbmc+IC0gaHR0cDovL3d3dy53b290aGVtZXMuY29tL2Fkcy93b290aGVtZXMtNDY4eDYwLTIuZ2lmPC9saT48bGk+PHN0cm9uZz53b29fYWRfY29udGVudF91cmw8L3N0cm9uZz4gLSBodHRwOi8vd3d3Lndvb3RoZW1lcy5jb208L2xpPjxsaT48c3Ryb25nPndvb19hZF9oZWFkZXJfYWRzZW5zZTwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2hlYWRlcl9pbWFnZTwvc3Ryb25nPiAtIGh0dHA6Ly93d3cud29vdGhlbWVzLmNvbS9hZHMvd29vdGhlbWVzLTQ2OHg2MC0yLmdpZjwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2hlYWRlcl91cmw8L3N0cm9uZz4gLSBodHRwOi8vd3d3Lndvb3RoZW1lcy5jb208L2xpPjxsaT48c3Ryb25nPndvb19hZF9pbWFnZV8xPC9zdHJvbmc+IC0gaHR0cDovL3d3dy53b290aGVtZXMuY29tL2Fkcy93b290aGVtZXMtMTI1eDEyNS0xLmdpZjwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2ltYWdlXzI8L3N0cm9uZz4gLSBodHRwOi8vd3d3Lndvb3RoZW1lcy5jb20vYWRzL3dvb3RoZW1lcy0xMjV4MTI1LTIuZ2lmPC9saT48bGk+PHN0cm9uZz53b29fYWRfaW1hZ2VfMzwvc3Ryb25nPiAtIGh0dHA6Ly93d3cud29vdGhlbWVzLmNvbS9hZHMvd29vdGhlbWVzLTEyNXgxMjUtMy5naWY8L2xpPjxsaT48c3Ryb25nPndvb19hZF9pbWFnZV80PC9zdHJvbmc+IC0gaHR0cDovL3d3dy53b290aGVtZXMuY29tL2Fkcy93b290aGVtZXMtMTI1eDEyNS00LmdpZjwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX3VybF8xPC9zdHJvbmc+IC0gaHR0cDovL3d3dy53b290aGVtZXMuY29tPC9saT48bGk+PHN0cm9uZz53b29fYWRfdXJsXzI8L3N0cm9uZz4gLSBodHRwOi8vd3d3Lndvb3RoZW1lcy5jb208L2xpPjxsaT48c3Ryb25nPndvb19hZF91cmxfMzwvc3Ryb25nPiAtIGh0dHA6Ly93d3cud29vdGhlbWVzLmNvbTwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX3VybF80PC9zdHJvbmc+IC0gaHR0cDovL3d3dy53b290aGVtZXMuY29tPC9saT48bGk+PHN0cm9uZz53b29fYWx0X3N0eWxlc2hlZXQ8L3N0cm9uZz4gLSBkZWZhdWx0LmNzczwvbGk+PGxpPjxzdHJvbmc+d29vX2F1dG9faW1nPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19ibG9nX3N1Ym5hdmlnYXRpb248L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fY29udGVudF9hcmNoaXZlczwvc3Ryb25nPiAtIGZhbHNlPC9saT48bGk+PHN0cm9uZz53b29fY3VzdG9tX2Nzczwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2N1c3RvbV9mYXZpY29uPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fZXhjbHVkZV9wYWdlc19mb290ZXI8L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19leGNsdWRlX3BhZ2VzX21haW48L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19mZWF0dXJlZF9sYXlvdXQ8L3N0cm9uZz4gLSBzbWFsbF93aXRoX2FkLnBocDwvbGk+PGxpPjxzdHJvbmc+d29vX2ZlYXRfYWx0X2hlaWdodDwvc3Ryb25nPiAtIDg1PC9saT48bGk+PHN0cm9uZz53b29fZmVhdF9hbHRfd2lkdGg8L3N0cm9uZz4gLSAxMzA8L2xpPjxsaT48c3Ryb25nPndvb19mZWVkYnVybmVyX3VybDwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2dvb2dsZV9hbmFseXRpY3M8L3N0cm9uZz4gLSA8c2NyaXB0IHR5cGU9XCJ0ZXh0L2phdmFzY3JpcHRcIj4NCnZhciBnYUpzSG9zdCA9ICgoXCJodHRwczpcIiA9PSBkb2N1bWVudC5sb2NhdGlvbi5wcm90b2NvbCkgPyBcImh0dHBzOi8vc3NsLlwiIDogXCJodHRwOi8vd3d3LlwiKTsNCmRvY3VtZW50LndyaXRlKHVuZXNjYXBlKFwiJTNDc2NyaXB0IHNyYz1cJ1wiICsgZ2FKc0hvc3QgKyBcImdvb2dsZS1hbmFseXRpY3MuY29tL2dhLmpzXCcgdHlwZT1cJ3RleHQvamF2YXNjcmlwdFwnJTNFJTNDL3NjcmlwdCUzRVwiKSk7DQo8L3NjcmlwdD4NCjxzY3JpcHQgdHlwZT1cInRleHQvamF2YXNjcmlwdFwiPg0KdHJ5IHsNCnZhciBwYWdlVHJhY2tlciA9IF9nYXQuX2dldFRyYWNrZXIoXCJVQS0xMDU4NTI2NS0xXCIpOw0KcGFnZVRyYWNrZXIuX3RyYWNrUGFnZXZpZXcoKTsNCn0gY2F0Y2goZXJyKSB7fTwvc2NyaXB0PjwvbGk+PGxpPjxzdHJvbmc+d29vX2hlYWRlcl9sYXlvdXQ8L3N0cm9uZz4gLSBhYm91dC5waHA8L2xpPjxsaT48c3Ryb25nPndvb19pbWFnZV9oZWlnaHQ8L3N0cm9uZz4gLSAxNzA8L2xpPjxsaT48c3Ryb25nPndvb19pbWFnZV9zaW5nbGU8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2ltYWdlX3dpZHRoPC9zdHJvbmc+IC0gNDMwPC9saT48bGk+PHN0cm9uZz53b29fbG9nbzwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX21hbnVhbDwvc3Ryb25nPiAtIGh0dHA6Ly93d3cud29vdGhlbWVzLmNvbS9zdXBwb3J0L3RoZW1lLWRvY3VtZW50YXRpb24vYmxvZ2dpbmdzdHJlYW0vPC9saT48bGk+PHN0cm9uZz53b29fcmVsYXRlZDwvc3Ryb25nPiAtIHRydWU8L2xpPjxsaT48c3Ryb25nPndvb19yZXNpemU8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fc2hvcnRuYW1lPC9zdHJvbmc+IC0gd29vPC9saT48bGk+PHN0cm9uZz53b29fc2luZ2xlX2hlaWdodDwvc3Ryb25nPiAtIDEyMDwvbGk+PGxpPjxzdHJvbmc+d29vX3NpbmdsZV93aWR0aDwvc3Ryb25nPiAtIDE4MDwvbGk+PGxpPjxzdHJvbmc+d29vX3RoZW1lbmFtZTwvc3Ryb25nPiAtIEJsb2dnaW5nc3RyZWFtPC9saT48bGk+PHN0cm9uZz53b29fdGh1bWJfaGVpZ2h0PC9zdHJvbmc+IC0gNjQ8L2xpPjxsaT48c3Ryb25nPndvb190aHVtYl93aWR0aDwvc3Ryb25nPiAtIDY0PC9saT48L3VsPg==