In Microsoft Office 97, the default path for the Northwind database is \Program Files\Microsoft Office\Office\Samples\North... A QueryDef is created in Microsoft Access and saved with the database file. It consists of a query and may or may not...

Bored with the same rectangle yellow comment boxes on your file? Here is a way to change them to shapes of your choice with picture on it (I am Using Excel 2007)Select the cell with the commentPress Shift+F2 to edit the comment boxSelect any border...

If you want to disable the Generate GetPivotData setting, follow these steps, as appropriate for the version of Excel that you are running. Microsoft Excel 2003On the Tools menu, click Customize. <

=Info() can be used to get information about the location of the file, information about the OS, excel version, about the memory status etc....Here are some examples:=info("directory") Path of the current directory or folder.=info("memavail") Amount...

We will see some Text functions which can be very useful:1. TEXT() :This functions formats a number and convert it to Text. For E.g., Cell A1 is having date 1/1/2009. We can convert this date to text in whatever format we like; e.g.,...