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...
by fccadmin | Nov 13, 2012 | Microsoft, Microsoft Office
In all of the Microsoft Office products, Drawing Objects allow for the addition of graphics in the form of simple, basic shapes such as lines, arrows, rectangles, ellipses and even text boxes. These shapes can overlap on each other, much like a felt board allows...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
Searching for a specific record in Microsoft Access You can search for a specific record in a table or form by using the Find tab in the Find and Replace dialog box. This is an effective choice for locating a specific record when the record that you want to locate...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
Using the Report Wizard to Group and Summarize Data The Report Wizard provides options for grouping and summarizing report data. You can organize your report by selecting the fields into which you want to group data. If you create more than one group, you can...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
Looking for another great time saver? Make the data entry job just a little bit easier! You can set a default value for a field — that value will automatically appear in the field for all new records. You can still modify the default field value as needed when...
Recent Comments