A Simple Computer Library

Creating reports

As you know, Microsoft Access has many objects that can be created. Not only can Microsoft Access create reports easier, but also it can be controlled to run a certain object.
Here is a file demo of the real database application by using Microsoft Access that contains the combination of form, table, report and module.
See the picture below:

- Download ——-
Click here to download.
The file is downloaded as a zip file that you will unpack on your computer. You will need Microsoft Access 2003 or 2007 on your computer.

Automatic back up

Not only can Microsoft Word save your document to restore the complete document if your computer system crashes before you have a chance to save your work, but also it can save a copy of the original document.
To do that you have to set file-saving features in Microsoft word by clicking The Tools, Options, click Save tab then select or click Always create a backup copy box and select or click Save Autorecover info every (set your desired time in minutes) in Save options.
The original document is safely stored as long as you set that option.
The .bak extension is the file created by Microsoft Word when you make a new document in Microsoft Word. It means, even the power goes out, you still have a copy of the document that you create it.

Wavy lines

If you see green and red wavy lines indicate that Microsoft Word found a possible grammar error. The easy way to hide wavy lines is to set in Tools options.
To do that, follow these steps:
- Click Tools, Options and click Spelling and Grammar tab.
- Click any language, select or clear the Check spelling as you type box and clear or the Check grammar as you type box and clear the Check grammar with spelling box.
- Click OK to end.

Selecting Text

When you create a document in Microsoft Word, there are many ways to select any text, word, sentence and paragraph. There are some selection options in Microsoft Word to select any text, you just click your mouse at the start of the text then drag the mouse to the end of the text.
To select a word, double-click the word.
To make a sentence selection, you can press Ctrl in your keyboard and click where the sentence starts.
If you select the entire document, you can press Ctrl + A.
Not only can you select a text, word or sentence using your mouse, you can also use your keyboard by pressing the Shift key to select them.
If you select with your keyboard, move the text cursor to the beginning of the selection, press Shift key then use arrow key to select.

Using formulas in Microsoft Excel

As you know, the formula in Microsoft Excel becomes an extremely powerful when we make a calculation in a cell. Microsoft Excel’s primary math operators are +, -, /,* and ^ for exponentiation.
When we try to make a formula in Microsoft Excel always starts with an equal sign (=).
Point to remember, an absolute address uses specific address/cell and does not change when we copy the formula. However, if we use a relative address that based on the current cell’s location the result depends on the contain cell addresses.
On this picture below, I made an experiment between absolute column and absolute row versus relative column and absolute row. Finally, I find the same result.

Add comments to a cell

Adding comments in Microsoft Excel is easy.
Click a cell you want to add your comments.
Right-click then choose Insert Comment.
Type your comments in the comment box.
To end your comments, left-click your mouse button in any cell you like but not in the selected cell.
The typing text of your comments do not appear in the cell, but they reside within the cell by flagginf the cell’s upper-right corner with a red triangle.

Easy autofill technique.

Autofill makes you faster when you fill data in certain cells.
By using autofill, you can fill data across rows and columns. This technique is used to complete data from a cell or cell selection. The easy way to use autofill is to select both cells by using your mouse, of course you have to fill both cells first and then drag the fill handle to the right or down direction, so when you release your mouse button, the cell contents will be filled automatically.
If you can not see the fill handle, you can click Options on the Tools menu and click the Edit tab and then select or click the Allow cell drag and drop check box.

This library is just for my own fun, but others may use it. As far as I know, it is the easiest way to create simple program by using assembly language. The lack of this library is just for dos operating only.
You can still run this program in Microsoft Windows 95 to Windows XP from command prompt.
This library is called dedeslib.obj
All commands always use \ (backslash) sign to begin.
Maximum column is 79.
Maximum row is 24
Here are some commands that included in object file:
Print character to the right direction
The symbol used to print is \?Rnumbercharacter
\?R09* print * 9 times to the right from cursor position.
Create single box
The symbol used to create single box is \xrow,colS
Don’t forget to insert coma between row and column
\x10,05S create single box at row 10 and column 5
Create double box
The symbol used to create single box is \xrow,colD
Don’t forget to insert coma between row and column
\x11,09S create single box at row 11 and column 9
Using tabs with certain color
\t0 cursor position in column 0 with 0Fh color
\t1 cursor position in column 10 with 0Ah color
\t2 cursor position in column 20 with 0Bh color
\t3 cursor position in column 30 with 0Ch color
\t4 cursor position in column 40 with 0Dh color
\t5 cursor position in column 50 with 0Eh color
\t6 cursor position in column 60 with 09h color
\t7 cursor position in column 70 with 07h color
Using certain color to print character, word or sentences
\&09 the output color is 09h
\&0A will produce 0Ah color
\&0B will produce 0Bh color
\&0C will produce 0Ch color
\&0D will produce 0Dh color
\&0E will produce 0Eh color
\&0F will produce 0Fh color
\&F1 will produce 1Fh color
\&F2 will produce 2Fh color
\&F3 will produce 3Fh color
\&F4 will produce 4Fh color
\&F5 will produce 5Fh color
\&F6 will produce 6Fh color
Cursor position
To set cursor position is easy by using \@row,column
Don’t forget to insert coma between row and column
\@12,15 will set cursor positon to row 12 and column 15
Set to the next line
\~0 to the next line to column 0
\~1 to the next line to column 1
These commands work for those number only.
Please see Assembly for fun topic in this site to see how to use this library in Assembly category.

Edit a cell

If we type in a cell but then realize that we have made a mistake, so we have to correct our data-entry.
There are some way to correct our mistake:
You can select a cell by double clicking the cell that contains the data you want to edit then press backspace to erase our mistake or press the arrows keys to move the text cursor to the certain position where your error is found and press ENTER to end cell editing.
Another way to edit cell is by pressing F2 key, where the text cursor will be in the end position of the text you just type then move the text cursor to the location of our mistake edit to the correct one and don’t forget to press ENTER to end.
If you just have a short word, you can retype the correct word the press ENTER key.

Selecting Cells

Selecting a row of a cells or a cell is easy, by clicking and dragging your mouse.
By holding down SHIFT and using (right, down, up and left) arrow key can be used to select cells.
Click the first cell in the range, and then hold down SHIFT and click the last cell in the range.
If you have nonadjacent cells or cell ranges, you can use CTRL key and use your mouse to select the other cell or ranges; the easy step is to select the first area and then press CTRL while you click another cell and drag the mouse.