One of the biggest mistakes new database developers make is they don’t plan. Instead, they just open up Microsoft Access or FileMaker Pro and start creating their tables. But, as with just about everything else in life, a little bit of planning upfront can make a huge difference down the line. Think about it – […]
As discussed in a previous blog post about Database Terms, a field in a database table is like a column in a spreadsheet. But one of the main differences between a spreadsheet and a database is that fields must have a specific data type in a database. The purpose of this post is to list […]
Sometimes you need to create a form with Microsoft Word that you want someone else to fill out. So you create a beautiful form like Figure 1 below, only to have the it come back looking like Figure 2 or worse like Figure 3. In this blog post we will review how to create a […]
Many sites on the World Wide Web, as well as many applications on PCs, Macs, smart phones, and tablets use databases. The purpose of this blog post is to define some basic database terms which need to be understood by anyone who wants to create a database. Database: A database is an organized collection of […]
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 […]
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 […]
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: […]
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 […]
I confess, I am always in a hurry (except maybe when I am watching reruns of Star Trek with my family). As a result, when I am on the computer I want to get as much done as I can. Maybe I’m a fanatic, but I have found that taking the time to move my hand […]
Have you ever received a poorly constructed and hard-to-understand spreadsheet? The data is scattered all over the place, the fonts and colors are inconsistent… It’s just a pain to read and nearly impossible to use. Laying out a spreadsheet so users can quickly read, find, filter, sort and print its data is one of the most […]
©2014 Snippet Training, all rights reserved.
Home | Sitemap | Contact us
