CREATING “USER DEFINED FUNCTIONS”

        1 – CREATING “USER DEFINED FUNCTIONS”

(Valid credit card number check – MOD-10)

2 – TELEPHONE BILL AUDIT SERVICE 

CREATING “USER DEFINED FUNCTIONS”


Sponsored Links

Using visual basic macros(functions) we can develop custom functions not built into Excel. These functions can then be used in formulas like any other function currently available in Excel. To demonstrate this we will create the “CardOK” function to test the validity of a credit card number. The “CardOk” function will perform a mathematical check to determine if the number in a specific cell could be a valid credit card number (know as the MOD10 check). It makes no determination of credit worthiness, available credit or whether this is an actual credit card number.

On the “Tools” menu, click “Macro”, and then click “Macros”. Type the name of the Macro, in this example type “CardOk” then click “create”.

This should bring up the Microsoft Visual Basic Editor.

Delete all the text on that page by pressing [Ctrl + A], and then press “delete”.

Then cut and paste the following text onto the page:

Function CardOk(CardNum$) As Boolean

‘Logic statement by Richard Harris – obtained from Deja News

‘Implemented by Chui Tey – obtained from Deja News
‘Concatenation and minor correction by Phil Bornemeier
‘Modified for Excel by www.finance-analyst.com
Dim tmpCardNum$, OddSum, EvenSum, i, OneLetter$, Digit, CheckSum
‘Initialize

      tmpCardNum$ = CardNum$

CardNum$ = “”

 

    OddSum = 0

 

    EvenSum = 0

 

      ‘Reverse order of cardnum drop non-number characters

 

    For i = Len(tmpCardNum$) To 1 Step -1

 

    OneLetter$ = Mid$(tmpCardNum$, i, 1)

 

    If OneLetter$ <= “9” And OneLetter$ >= “0” Then

CardNum$ = CardNum$ + OneLetter$

End If

 

    Next i

 

    ‘Add numbers in odd positions

 

    For i = 1 To Len(CardNum$) Step 2

 

    OddSum = OddSum + Val(Mid$(CardNum$, i, 1))

 

    Next i

 

    ‘Double numbers in even positions, add up all digits, accumulate

 

    For i = 2 To Len(CardNum$) Step 2

 

    Digit = Val(Mid$(CardNum$, i, 1))

EvenSum = EvenSum + Digit * 2 + (Digit * 2 >= 10) * 9

Next i

 

    ‘Add OddSum and EvenSum

 

        CheckSum = OddSum + EvenSum

 

        ‘Check if CheckSum divisible by 10

 

        If CheckSum Mod 10 = 0 Then

 

        CardOk = True

 

        Else

 

        CardOk = False

 

    End If

End Function

Sponsored Links

Now press [Atl + Q] to quit Microsoft Visual Basic Editor and return to Excel.

The function is now ready to be used. To test it, format cell A1 for text by highlighting cell A1 then pressing [Ctrl+1], click “number”, then click “text” and finally “ok”. Then enter in cell A1 enter the following valid credit card number:

4200123456789015

In cell A2 type:

=CardOk(A1)

The value in cell A2 should be “TRUE”

You can also access this function on the “Insert” menu, click “Function”, in the “Function Category” box select “User Defined”, “CardOk” should appear in “Function Name” box. Select “CardOk” and press “ok”. In the box that pops up enter “A1” (or the cell containing the credit card number), finally press “OK”.

One final note, this function (MOD10 check) is being used by many of the smaller e-commerce sites that can’t afford to have online credit card authorization!!

Enjoy!!!.

Sponsored Links

TELEPHONE BILL AUDIT SERVICE


Marketing Partners are now welcomed!

Do you know who is reviewing your Company’s telephone bill on a monthly basis?

If your Company is like most, the answer is a scary: NO ONE!

In fact, most US corporations pay their telephone bills without scrutinizing or challenging them. Department managers caught up in the operational demands of their departments, can’t possible do a detail analysis of their bill to discover errors, correct the problems, and obtain refunds. Usually a quick month-over-month comparison of the dollar amount on the bill is all that is done, before it is approved and sent off to accounts payable for payment.

Did you know that 60% of all US Corporations are being overcharged by as much as 30% on their telephone bills? While the majority of these overcharges are a direct result of the application of incorrect rates, other overcharges include incorrect tax rates, double billings, accounting errors, etc. Even though you may have negotiated excellent rates with the phone company, it doesn’t mean your bill reflects those rates. If you haven’t performed a complete detailed analysis of your telephone bill in the last two years, chances are your company is overpaying, maybe as much as 30%.

We, Finance-Analyst.com, can identify commercial telecom billing errors and overcharges for most businesses, and then negotiate for refunds, credits and lower costs. As your consultants, we will be constantly watching your telephone bill, striving to lower it and put more money back into your income statements’ bottom line.

This service is performed at no cost to you. You pay only a percentage of what we recover for you, and if we can’t reduce your costs for you, YOU PAY NOTHING.

Sponsored Links

To get started we need the following information from you:

-A copy of your telephone contract, including the rates
AND
-The actual paper bill for the last three months, or
-Electronic bills (CDR on ftp or CD-ROM) for same period, or
-CDR’s from your telephone company.

Once we have this information, we will perform a detailed analysis to verify the accuracy of your bills. The result of our analysis will be a report on errors and the amount of your money you can expect to recoup.

Remember, telephone billing-errors will continue indefinitely until you take the necessary steps to correct them! So reply to send us an email now and a senior consultant will call you to start the process.

You owe it to yourself and your bottom line to talk with us.

Microsoft Excel

Sponsored Links

Introduction:

Microsoft Excel is a spreadsheet application hence developed by the Giants “Microsoft” for Microsoft Windows and Mac OS. It mainly contains the following features as follows:

  • Calculation
  • Pivot tables
  • Graphing tools
  • Macro programming language called “Visual Basic for Applications”

It has been very widely used and applied for all these platforms, since in the version 5 in 1993, and it has replaced the other software’s such as “Lotus 1-2-3” . Excel forms part of Microsoft Office.

The top features and benefits of Microsoft Excel are as follows:

Sponsored Links

Build great charts

Excel allows mainly the business users to unlock all their potential data, by using different formulas across a grid of cells. Required Data is inserted into individual cells when ever required in either rows or else columns.

Allowing them to perform sort, filter, and then display them in a visual presentation.

Using pie charts, graphs and clustered columns which adds meaning to data. These visualizations can add some extra emphasis to all the business reports and even marketing material. Excel recommends charts thus explained are most suitable for the type of data being presented on either the X axis and Y axis.

Use conditional formatting

Excel users can format all their spreadsheets either using different

Bolds and italics, to differentiate, highlight the most important data.
colour shades,

This function could be more useful when presenting an accounting information, “pre-tax profit” as well the “balance that which being carried or forwarded by the company.”

Users can select their appropriate coloring scheme either by using the “Quick Analysis button” and then utilizing the Formatting tab.

Help identify trends:

When we are presenting the data in the form of graphs, it is helpful to include an average lines, which explicitly shows the key trends that which are emerging from the information.

This may also help to demonstrate the required key points to the other users in a straightforward manner.

For Example, let us consider an executive from a different department during their board meeting. Hence Excel allows you to trend the lines that which have to be extended beyond their graph.

Sponsored Links

Bring data together

Excel sheets are used to bring all the necessary information from various documents together, so that they can be maintained in a single location.

As well as the raw data that which is present contains all the information even from other spreadsheets too, hence it is possible to import the text and images where ever necessary. Other remaining objects can be added obviously either by using the Insert tab, or by the additional spreadsheets.

Online Access

Excel is available even in online as a part of the “Microsoft’s Office 365 productivity suite”. This means that business leaders and employees can have access to their programs from a range of devices, i.e. even from any location.

Providing that they have web-enabled PC, Smartphone, Laptop or Tablet through which it should be possible to access an Excel, making remote and mobile working as expected.

Sponsored Links

Disadvantages:

  • A disadvantage is that we can observe that the software requires frequent updating which is most time consuming task.
  • The risk factor is that it is more likely when the software starts updating.
  • Another important thing to be remembered is that not all computer users will have the programs that which are compatible to have a view/glance the documents which have been made in the program.

Conclusion: 

Excel is a Microsoft program that which has certain formulas to ease the calculations. But the disadvantage of using it is that it minimizes or else limits the knowledge of solving different applications/ problems manually.

Excel Formulas

This Excel formula helps us how to create and make use of this formulas, with including a step by step examples. It is mainly intended for those for the users with little or no experience at all in working with spreadsheet programs such as Excel.

Sponsored Links

1. SUM

Formula: =SUM (6,6) or

=SUM (A1, B1) or

=SUM(A1:B5)

The SUM formula helps us to add 2 or more numbers together.

You can have different numbers there by separated by commas, it will add them together, you can also have cell references and you have to add  numbers in these cells and they  will add them together , or you can also have a range of cells separated by  a colon in between the cells, and it will add the numbers.

2. COUNT

Formula:

=COUNT (A1:A10)

The count formula counts the number of cells in a range that have numbers in them.

3. COUNTA

Formula:

=COUNTA (A1:A10)

It   even helps to count all the numbers of  non-empty cells in a particular  range. It will count that if cells have numbers or any other characters involved in them.

The COUNTA Formula works with all data types.

images

 

4. LEN:

Formula: =LEN (A1)

The LEN formula helps us to count all the number of characters in a give range of cells. This sometimes  also includes spaces.

Sponsored Links

doc-reverse-text-words10

Note:

10 characters, that without spaces, in between the words, where as 12 characters with spaces between the words.

5. TRIM

Formula: =TRIM (A1)

We will find  this formula to be more useful  when we run into situations, where you pull data from a database. When we  try comparing it either  using “IF statement” or else  “VLOOKUP’s.”

TRIM remove extra spaces

6. RIGHT, LEFT, MID

Formulas: = RIGHT(text, number of characters), =LEFT(text, number of characters), =MID(text, start number, number of characters).

The formula which we used here  returns  the specified number of characters as mentioned  from a given  text string.

Note:

  • RIGHT gives us the number of characters that are from the right of the text string.
  • LEFT gives us the number of characters that are from the left.
  • And MID gives us the required number of characters from the middle

7. VLOOKUP

Formula: =VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)

“ It First Looks up for a value which is in the leftmost column  in table, and then returns the value which is in the same row,from that of a  column we  specify…”.

Sponsored Links

Note: If at all possible we  use any  number for the lookup value. it makes it more and more easier to make sure that  the data  that which you are getting back would be a correct match.

8. IF Statements

Formula: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)

Example:

=IF(C3>D3, “Met Quota”, “Did Not Meet Quota”)

9. SUMIF, COUNTIF, AVERAGEIF

Formulas: =SUMIF (range, criteria, sum range), =COUNTIF(range, criteria), =AVERAGEIF(range, criteria, average range)\

10. CONCATENATE

It is the procedure of   combining the 2 different cells into one cell.

Sponsored Links

concatenate-function

Finding all the  required right Excel Formulas For The Job. There are around 316 predefined or built in functions in Excel

 

 

 

 

Excel Keyboard Shortcut Keys

Sponsored Links

   1. To format any selected object, press ctrl+1

2. To insert current date, press ctrl+;

3. To insert current time, press ctrl+shift+;

4. To repeat last action, press F4

5. To edit a cell comment, press shift + F2

6. To autosum selected cells, press alt + =

7. To see the suggest drop-down in a cell, press alt + down arrow

8. To enter multiple lines in a cell, press alt+enter

9. To insert a new sheet, press shift + F11

10. To edit active cell, press F2 (places cursor in the end)

11. To hide current row, press ctrl+9

12. To hide current column, press ctrl+0

13. To unhide rows in selected range, press ctrl+shift+9

14. To unhide columns in selected range, press ctrl+shift+0

15. To recalculate formulas, press F9

16. To select data in current region, press ctrl+shift+8

17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)

18. While editing formulas to change the reference type from absolute to relative vice versa, press F4

19. To format a number as currency, press ctrl+shift+4 (ctrl+$)

20. To apply outline border around selected cells, press ctrl+shift+7

21. To open the macros dialog box, press alt+F8

22. To copy value from above cell, press ctrl+

23. To format current cell with comma formats, press ctrl+shift+1

24. To go to the next worksheet, press ctrl+shift+pg down

25. To go to the previous worksheet, press ctrl+shift+pg up

Excel Tips for Improving Productivity Using Excel

Sponsored Links
  • To remove grid lines from excel worksheet, go to menu > tools > options > and un-check grid lines option. (Excel 2007: office button > excel option > advanced) 
  • To hide a worksheet, go to menu > format > sheet > hide 
  • To freeze rows on top, select the a row and use menu > window > freeze panes 
    Sponsored Links
  • To disable annoying formula errors, go to menu > tools > options > error checking tab and disable errors you don’t want to see.
  • To change the shape of cell comments from rectangle to some other symbol,selects the comment, go to drawing tool bar and change the shape from there. 
  • To transpose a range of cells, copy the cells, go to empty area, and press alt+e+s+e 
    Sponsored Links
  • To save data filter settings so that you can reuse them again, use custom views 
  • To select all formulas, press CTRL+G, select “special” and check “formulas” 
  • To select all constants, press CTRL+G, select “special” and check “constants” 
  • To clear formats from a range, select menu > edit > clear > “formats”
Sponsored Links

MS OFFICE

Why Microsoft Office?

Introduction: 

Using Microsoft office one’s that your grammar would be correct considering all the factors that which it has been built by using -in grammar-checking tool. It also has options to either view the documents, or else it offers some conditional formatting. Microsoft office provides high quality that which permits to easily create diagrams.

Sponsored Links

One of the advantages of Microsoft word is that it allows easy as well as textual input. Microsoft word also has a large variety of formatting choices. It contains  self explanatory “discourse boxes and menu options”.

It’s been found that more than the two decades since “Microsoft’s”  suite of office productivity  has been released

Forrester reported that two years ago 80% of the companies were running some different versions of Office; this number did not have much budget.

As easy as it is, sometimes it may cause or to dislike the Offices, it’s very hard to deny that it “ a  robust feature set which is pretty.”

Sponsored Links

For example 

Let us consider the “Web-based tools like Google Docs, which are the only one that which contains a portion  what Office does. And while they accomplish this the majority of commonly-needed tasks from being based in the cloud, which is still not enough for other businesses.

Eagerness to provide an office suite completely depends on the type of worker. A Web-based solution can be especially ideal for the workers who go on travelling extensively, such as sales, marketing etc.

Example 2:

IT decision makers usually said that they’d be more likely to give up a solution to workers who have some documents to be edited. Hence as opposed to those who have certain jobs to revolve more heavily?

Sponsored Links

The second important factor by larger companies is that the desire to cut/minimize the costs that which have been incurred.

Obviously, for small businesses and other nonprofit organizations it’s a much more important factor and as a result these organizations tend to have more important  office alternatives.

MS WORD SHORTCUTS AND TIPS

Some Handy short cuts helps the even the non computer user to work with Ms-office with more easier and an Efficient way with performance much better than the before. Beginners and experts can  speed up their creating and as well as  editing the  Microsoft Word documents.

Shortcut                                       Description           

Ctrl + 0 Used to Add or remove 6pts of spacing before a paragraph.
Ctrl + A Used to Select all contents of the page.
Ctrl + B Mainly used for Bold highlighted selection.
Ctrl + C Copy selected text.
Ctrl + D Opens the font preferences window.
Ctrl + E It Aligns the line or selected text to the center of the screen.
Ctrl + F Opens find box.
Ctrl + I It helps in the Italic highlighted selection.
Ctrl + J Helps in Aligning  the selected text or line to justify the screen.
Ctrl + K Used to Insert the  link.
Ctrl + L Helps to Align the line or selected text to the left of the screen.
Ctrl + M Helps to Indent the paragraph.
Ctrl + P Helps to Open the print window.
Ctrl + R Used to Align the line or selected text to the right of the screen.
Ctrl + T Helps in Creating a hanging indent.
Ctrl + U Underline the highlighted selection.
Ctrl + V Paste.
Ctrl + X Cut the  selected text.
Ctrl + Y It is used to Redo the last action performed.
Ctrl + Z It helps in Undo last action.
Ctrl + Shift + L Quickly creates a bullet point.
Ctrl + Shift + F Change the font.
Ctrl + Shift + > Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ] Increase selected font +1pts.
Ctrl + Shift + < Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [ Decrease selected font -1pts.
Ctrl + / + c Used mainly to Insert a cent sign (¢).
Ctrl + ‘ + <char> Insert a character with an accent (grave) mark, where <char> is the character you want. For example, if you wanted an accented è you would use Ctrl + ‘ + e as your shortcut key. To reverse the accent mark use the opposite accent mark, often on the tilde key.
Ctrl + Shift + * Used mainly to View or hide non printing characters.
Ctrl + <left arrow> Moves one word to the left.
Ctrl + <right arrow> Moves one word to the right.
Ctrl + <up arrow> Moves to the beginning of the line or paragraph.
Ctrl + <down arrow> Currently Moves to the end of the paragraph.
Ctrl + Del Deletes the word to the  right of cursor.
Ctrl + Backspace Deletes word to the  left of cursor.
Ctrl + End Moves the cursor to the end of the document.
Ctrl + Home Moves the cursor to the beginning of the document.
Ctrl + Spacebar Reset highlighted text to the default font.
Ctrl + 1 Single-space lines.
Ctrl + 2 Double-space lines.
Ctrl + 5 1.5-line spacing.
Ctrl + Alt + 1 Changes text to heading 1.
Ctrl + Alt + 2 Changes text to heading 2.
Ctrl + Alt + 3 Changes text to heading 3.
Alt + Ctrl + F2 Open new document.
Ctrl + F1 Open the Task Pane.
Ctrl + F2 Display the print preview.
Ctrl + Shift + > Increases the highlighted text size by one.
Ctrl + Shift + < Decreases the highlighted text size by one.
Ctrl + Shift + F6 Opens to another open Microsoft Word document.
Ctrl + Shift + F12 Prints the document.
F1 It is used to Open the  Help window.
F4 Used to Repeat the last action performed (Word 2000+)
F5 Open the find, replace, and go to window in Microsoft Word.
F7  Hence allows the Spell check and grammar check selected text or document.
F12 Save as.
Shift + F3  It helps us to change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7 Allows us to Run a Thesaurus check on the word highlighted.
Shift + F12 Save.
Shift + Enter Helps to Create a soft break instead of a new paragraph.
Shift + Insert Paste.
Shift + Alt + D Allows us to Insert the current date.
Shift + Alt + T Helps us to Insert the current time.

Advanced PowerPoint Tips

1. Editing Shortcuts

When selecting a particular object, make use of  the right mouse button to click on it . Not only select the object but also you will be asked to  show some editing menu so particular to that object.

Sponsored Links

2. Tearing off Sub-menus

When we are asked t use the same menu for several times, we can make use of shaded bar, tear it off and placing it on the screen.

3. Seamless Screen Builds

Duplication of the slide can be thus made using (CTRL+D) as many times required to build the sequence. This will allow us to to ensure that all the objects have been placed, eliminating those misplace of shifts.

.4. Reduce File Size

Make a note that you should “Keep the number of slides minimum.”

For example If you have a 15-minute presentation, prepare the slides in between 10-12 slides.

Sponsored Links

If your presentation and skills found to be  so formal, that your audience doesn’t feel comfortable to ask  the questions, the presentation will not fulfill its intended mission.

In addition, it is better to finish the  presentation skills, as with less time than the actually allotted time.

5. Recycling Slides

This is mainly in tented to add new slides from different slides, in to your new presentation. We can observe that only the imported slides are inserted and the background is unaffected.

6. A Summary Slide

With the help of this power point, one can  add a summary Slide to your presentation.

7. Embed a Presentation in Word

Hence in order to use this we have to insert our own  slide show into a Word document, i.e. it can be either the document in Word or else the  slide show presentation in PowerPoint.

Sponsored Links

The Mighty Control Key

  • It helps to Hold down the CTRL key while clicking the particular slide show view button when editing a slide show.
  •  Then CTRL key helps in  dragging a required an existing Guide to create the new guide.
  • And also it helps to Hold down the CTRL key while making certain changes in  the wheel, on the mouse to zoom in and out of the slide.
  • CTRL + A  to select all the  objects
  • CTRL + A  to select all slides
  • CTRL + A  to select all text in your slide show
  • CTRL + B to apply bold formatting
  • CTRL + C to copy the selected object
  • CTRL + D to duplicate (make a copy of) the selected slide
  • CTRL + E to center the  paragraph.
  • CTRL + F to find the  text
  • CTRL + G to open all  the necessary  grids and guidelines of the dialog box
  • CTRL + H to replace the  text
  • CTRL + I to apply italic formatting
  • CTRL + J to justify a paragraph with the  alignment
  • CTRL + K to insert a hyperlink where ever required.
  • CTRL + L to left align a paragraph
  • CTRL + M Allows to insert a new slide
  • CTRL + N to Prepare a new presentation
  • CTRL + O to open up an already existing presentation
  • CTRL + P to print the  presentation
  • CTRL + Q to quit the PowerPoint
  • CTRL + R to provide the right align a paragraph
  • CTRL + S to save the  presentation
  • CTRL + T to change the formatting of all the characters between sentences,  uppercase and lowercase.
  • CTRL + U to apply underline formatting
  • CTRL + V to paste a cut or copied object in the file.
  • CTRL + W to close the  presentation
  • CTRL + X to cut the  selected objected
  • CTRL + Y to redo or repeat an action repeatedly
  • CTRL + Z to undo the last action performed
  • CTRL + Equal Signs to apply subscript formatting
  • CTRL + SHIFT + Plus Sign to apply superscript formatting
  • CTRL + Space Bar To remove subscript and superscript

MS-POWERPOINT

Introduction:

Sponsored Links

The main features of Microsoft PowerPoint propose having included   all the advanced cropping tools and artistic filters which used here such as paintbrush, blur as well as watercolor. These features of ms PowerPoint mainly helps in adding certain visual impact/additional features to the presentations when ever required.

Sponsored Links

The 2010 edition which we used before have different video styles and also certain effects such as “3-D rotation”, “reflections and bevels”.

Features of MS PowerPoint:

1.      Editing & Composition: 

  • All the recent releases of PowerPoint allow the users to embed different audio, images, video and text within their presentations.
  • More recent releases asks for rudimentary editing and compressions of all the media assets as well as a few  advanced options, which may be either  artistic filters or else  video effects.

2.      Presentation:

  • Many Years ago, some user have to remove and place them individually in a printed acetate sheets from an “overhead” projector. 
  • Now a presenter can make use of or else advance the  virtual slides using either a mouse, or handheld device. 
  • With embedding an audio and video devices , the presenter can easily have a  control on the  complete organized presentations from  their start to finish.

3.     Minimum Requirements

  • The PC must meet certain minimum specifications where it have been installed. This can ensure that the software can run properly. 
  1. It should  have at least a 500 MHz processor
  2. 512MB RAM,
  3. 3G of disk space,
  4. a 1024×576 display with DirectX9 and 64M video RAM.

This is a very  low requirement as most  new machines do  much better than all this equipped.

Sponsored Links

 Embossing Images:

  1. Insert the Clip Art image (and be sure it is still selected).
  2. Ungroup the selected image.
  3. Quickly again re-group the image.
  4. Select the “shadow settings “from  the “Drawing Toolbar.
  5. From the Format menu, choose the  Object.
  6. Then Click the on “Colors and Lines” Tab.

Creating Soft Shadows:

  1. Make a copy of the particular object.
  2. Make slight changes in the object properties, if required. Change the copy’s fill that have to be shaded from either black to some background color, with the shadings  set, from the center.
  3. Make use of the  shaded object, 150% bigger than the actual object.
  4. Then Position the actually shaded object behind that of the original object.

 

Function Keys:

Function Key

Pressed Alone

with SHIFT

with CTRL

with ALT

F1

Displays the  the Help Window

Context-sensitive help

F2

Select a complete text box if the text that what we have selected.

Save As

F3

Change the case letters

F4

Repeat the last action

Repeat the last  action find

Close active Window

Close  active application

F5

Start your slide show from the beginning slide

Restores  the active window

Restores the application window

F6

Move clockwise among panes of normal view

Move counter clockwise among panes

When more than one window is open, switch to the next window

F7

Check spelling

If window is not maximized, allows you to move the window

Find the next misspelling

F8

If window is not maximized, allows you to size the window

Macros

F9

Toggles the grid on and off

Minimize the active window

Toggles the guides on and off

F10

Activate the menu bar

Open the shortcut menu (same as right-clicking the mouse)

Maximize the active window

Maximize the application window

F11

Visual Basic Editor

F12

Save As

Save

Open

 

Using MS ACCESS

Sponsored Links

Why Ms-Access?

Ms Access is a tool which is used “for Database management” and its been given as a package as that of Ms-office. Many corporate, private organizations make use of this to handle huge amount of the data. The place where we store the Data is called “Database”.

Sponsored Links

Database Management is the process or a mechanism used for performing multiple operations like:

  •   Storing
  •   Retrieving Information
  •  Managing

With the help of access, one can easily enter the data in the forms, making it simpler and even accurate.

Access can be the best solution, when multiple users thus have been working on the certain piece of data at a stretch and at a time. Access locks a record while the user makes any changes to it. With the help of Access, one can create as many reports as needed by the user which can run at any time.

images (4)

Sponsored Links

Whenever user has been connected to different resources and perform some editing options on them, something like editing the part of data etc, access would be the best choice. User can have an external view of the data, but cannot make any manipulations to them.

TIPS AND TRICKS:

Change the default working folder    

This is mainly used to change the default working folder to that of your own new folder by changing the path in the Default database folder box in that of the General tab, Options dialog box.

Controls and expressions

  1. Administering a database

Create a vertical control :In Access, you can create your vertical label or text box in a form or a report by setting their Vertical properties of the control.

Sponsored Links

Customizing Access

  • Add the descriptions for your database objects:
  1. Right-click the object in the Database window.
  2. Click the Proxy parties in the shortcut menu, and then type your description in the Description box.
  • The Process Used To Turn off Office:  
  1. Click on the options which are a short cut menu.
    b.      And then on the options tab
    c.      Later on you can make use  of the office assistant check box and
    d.      Then activate the Office assistant from the help menu.
  • Hide the new object shortcuts    

Firstly we need to clear all the respective “New object shortcuts” which are present there and click on the check box button from “View tab Options dialog box (Tools menu)

  •  Database Object Details    

To have all the necessary information with respect to that of the database objects, you can obtain it from the Database window, i.e. from the View menu.