Labels

Wednesday, 11 April 2012

How to Unhide hidden object (tables, queries, form) in Access 2010

Problem:
You have hidden access objects (tables, queries, form etc) in your Microsoft access database and you want to make the hidden object appear again.

Solution:
In "Navigation Pane" on the left of the screen, right click on "All Access Objects" and then click on "Navigation Options".

A dialog box will appear. In "Display Options" group check "Show Hidden Objects".

Monday, 3 October 2011

Insert checkbox, combo box, radio button etc.

If you are designing a form in Microsoft Word, Excel or Powerpoint and want to restrict user data entry using checkboxes, combo boxes, radio buttons, date picker, toggle buttons etc.
Go to Office Home/File  >  Options  >  Customize Ribbons  >  Check Developer in Main Tabs category (if not already checked). Developer ribbon will appear now.

Go to "Developer" ribbon. Select  Controls  >  select desired object from the list of options available.

Sunday, 21 August 2011

Applying background to an excel worksheet

To add a picture background to an excel worksheet, Go to Page Layout ribbon >  Page Setup  > Background. (Browse to your image location and press Open)


You may have to adjust the size and resolution of your picture according to requirement


After you have applied a background, the default button changes to "Delete background" button which can be used to remove the background (if required).


You can also remove gridlines for better visibility .(removing gridlines)


Note: The background is only for on-screen display and will not be printed.