by fccadmin | Jul 26, 2013 | Access, Microsoft, SQL
Access gives you the easy to use query design grid interface for combining data from tables that share one or more related fields. It’s simple to use and generally effective. However, there are still some times when the query design grid isn’t enough to...
by fccadmin | Feb 25, 2013 | Microsoft, Microsoft Office, Outlook
You can use AutoCreate to quickly create new items from existing ones. With AutoCreate, you can drag and drop Outlook items from the view area to another folder on the Navigation Pane or Folder List. Say you’ve received an email from a colleague with details on...
by fccadmin | Nov 13, 2012 | Excel, Microsoft, Microsoft Office
Thousands, Millions, etc. — Learn about number formats in Excel! If you use a number format like 0, Excel simply writes the number with no decimal point or decimal digits. To truncate the last three digits of a number in the thousands, append a comma to the...
by fccadmin | Nov 13, 2012 | Microsoft, Microsoft Office
In Microsoft Word 2007 and 2010, you can save an individual document in Word 2003 version by clicking the Office button in 2007 or the File Menu in 2010, then Save As, and changing the Save As Type to Word 97 – 2003 as shown below. If you’ve used Word...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table. In an Access database, there may be times when you’d like to make sure that there are no duplicate records in a table. The Find Duplicates...
by fccadmin | Nov 13, 2012 | Excel, Microsoft, Microsoft Office
Sharing the Wonder of Excel PivotTables! The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and...
Recent Comments