Parameter Query is a query that needs input(s) from the users before it can be run and produced a result. When a user runs a parameter query, a dialog box will pop up and prompt the user for a parameter value (or multiple parameter values). Parameter query greatly enhances the flexibility and versatility of a … Read more Use Input Form for Parameter Query
Mark-to-Market is an important accounting concept. It reflects the “fair value” of an asset or a portfolio based on the current market price. “Fair value” is normally called “fair market value” and is a critical part of the “General Accepted Accounting Principles” (GAAP). Market value of an asset or a portfolio may deviate from its … Read more Mark to Market Financial Report
When you deal with shape objects in Excel and need to do certain automation, it is critical to know the coordinates of the objects, especially for maps. The coordinates are calculated from the top left end of an Excel Worksheet. The very top left end of cell A1 will be (0, 0) for X and … Read more Find the Coordinates of a Shape Object
Excel Visual Basic modules require triggers to initiate. They can be initiated by using CTRL + combination shortcut keys, clicking a button, or simply pressing an ENTER key. I normally shun the use of CTRL + combination shortcut keys because it is not user-friendly. It requires the user to remember what keys to be pressed … Read more Press ENTER key to trigger a Visual Basic Module
You might have seen that your Access database file keeps on growing in size, even though you have not been putting in many new data. This is caused by the way how a database is structured. For all the database software that I used before, the database software leaves an unused section every time you … Read more Compact your Access database to keep it small and improve its performance
Both the WORKDAY and NETWORKDAYS functions are essential for project planning. The WORKDAY function allows you to calculate the completion date provided that you know the number of days that is required to complete the project. The NETWORKDAYS function does the opposite. You have a desired completion date and you want Excel to calculate how … Read more WORKDAY and NETWORKDAYS Functions
Your Microsoft Access files are initially created in MDB or, with Access 2007 or after versions, in ACCDB format. In MDB or ACCDB formats, everyone can have access to your Visual Basic modules. Users can maliciously or accidentally change your codes and make your VB modules inoperable. To protect the integrity of your Access files, … Read more Hide Visual Basic Modules by saving your Access Files in MDE or ACCDE file format
You may want to include simple calculations in some of your Word documents, notably Quotes and Invoices. Ideally the quotes and invoices are generated from an Accounting system. But for a lot of small business owners, Microsoft Excel may already be their Accounting system. I have seen many small business owners use a calculators to … Read more Embed an Excel Object into Microsoft Word Document
Quick Launch Bar is a wonderful tool to enhance your efficiency. It’s more convenient than placing your frequently used applications on your desk top. It is easy to put applications to the Quick Launch Bar. You just need to drag-and-drop the icons to the Quick Launch Bar. Besides putting the application icons from your desktop … Read more Creating a Quick Launch Bar in Window to enhance your efficiency
I was once a part time interpreter about 20 years ago. I went to court houses, law firms, hospitals, and insurance companies to do instant verbal translations and document translations between Chinese and English. It was not an easy job but it paid well. The requirements of an interpreter are very high because you need … Read more Use Translator in Microsoft Office to translate documents