Microsoft Access

Splitting an Access Database

One of the most useful features of a Microsoft Access database is the ability to split the database into two files. The first file, which is commonly called the back-end or data file, holds the data (the tables). The second file, which is commonly referred to as the front-end or shell file, contains the user […]

Continue Reading 0
Microsoft Access

Microsoft Access – How to update linked tables

Open your Access database.   Start the Linked Table Manager feature. In Access 2003, from the menu choose Tools, Database Utilities, Linked Table Manager. In Access 2007 from the ribbon choose Database Tools, Linked Table Manager. In Access 2010 from the ribbon choose External Data, Linked Table Manager.   In the Linked Table Manager dialog […]

Continue Reading 0
Microsoft Excel

Excel PivotTable 101

What is a PivotTable? A PivotTable is a useful tool for creating summary reports from Excel data. And the cool thing is you can “Pivot” or move the fields of the report. For example all of the following screen shots are from PivotTables that were created from an Excel list of 5406 movies. Figure 1: […]

Continue Reading 0
Microsoft Word

Inserting one word document into another

In Word 2003 you could insert one word document into another by selecting from the menu Insert | File. But now in Word 2007 / 2010 it is not so obvious. Here’s how to do it. Open the first word document. Position the cursor where you want the second document inserted. From the ribbon choose […]

Continue Reading 0

Ask us how we can service your company's training requirements.

©2014 Snippet Training, all rights reserved.

Home   |   Sitemap   |   Contact us