1. Computing
Send to a Friend via Email

Discuss in my forum

Mike Chapple

Updated Articles and Resources

By Mike Chapple

    Updated Articles and Resources
    • Creating Reports with Microsoft Access 2010 Created: Sunday, December 04, 2011 Updated: Wednesday, April 16, 2014
      Microsoft Access 2010 allows you to easily create professionally formatted reports automatically from information stored in a database. In tis tutorial, we're going to design a nicely-formatted lis...
    • Introduction to Pivot Tables Created: Sunday, September 25, 2011 Updated: Wednesday, April 16, 2014
      If you’re looking for some of the flexible query power of a database but don’t want to mess with relational database design, pivot tables may be just the technology you need. Chances ar...
    • One-to-One Relationships Created: Saturday, May 05, 2007 Updated: Wednesday, April 16, 2014
      Looking for a definition of one-to-one database relationships? Read our definition in the About Databases glossary!
    • Installing the Northwind Sample Database in Microsoft Access 2013 Created: Thursday, June 06, 2013 Updated: Wednesday, April 16, 2014
      The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it in Microsoft Access 2013
    • Installing MySQL on Mac OS X 10.8 Mountain Lion Created: Sunday, August 05, 2012 Updated: Wednesday, April 16, 2014
      The MySQL database server is one of the most popular open source databases in the world. Although there is not yet an official package for installing it on the latest version of the Macintosh opera...
    • Databases Glossary Created: Sunday, August 21, 2005 Updated: Wednesday, April 16, 2014
      Glossary of database related terms, including definitions, explanations, examples, suggested reading, and other resources." itemprop="description"> SQL Books Created: Friday, June 15, 2007 Updated: Friday, April 11, 2014
      Looking for a book to help you get started with Strucutred Query Language? Need a new reference book for your shelf? Check out my favorite SQL books.
    • Building an Access Database From the Ground Up Created: Sunday, August 31, 2003 Updated: Thursday, April 10, 2014
      In this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up." ite#if expr="$zTP='t3'" --> ...
    • Password Protect an Access 2007 Database Created: Sunday, February 18, 2007 Updated: Wednesday, April 09, 2014
      Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process.
    • Trivial Functional Dependency Created: Sunday, June 05, 2011 Updated: Wednesday, April 09, 2014
      The definition of trivial functional dependency in relational database theory, along with an example and some further reading.
    • PCI DSS for Database Professionals Created: Sunday, January 20, 2008 Updated: Saturday, March 08, 2014
      The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or debit card transactions. These requirements stem from a series of significant security incidents affecting databases of consumer credit information over the past decade.
    • Verifying Credit Card Numbers with the Luhn Algorithm Created: Thursday, March 06, 2014 Updated: Thursday, March 06, 2014
      All valid credit card numbers are creating using an internal checksum that helps merchants quickly determine if a card number contains typographical errors. This checksum appears as the last digit of the credit card number and is calculated using a process known as the Luhn algorithm. In this article, we examine how the Luhn algorithm works so that database developers may use it to perform a cursory inspection of credit card numbers.
    • Choosing a Business Analytics Solution Created: Sunday, March 02, 2014 Updated: Sunday, March 02, 2014
      It’s hard to cut through the noise and understand what you really need in a Business Intelligence and Analytics solution. Because analytics is the engine that drives businesses to make the smartest and most accurate decisions, the software you choose for analysis is like picking out a car.
    • Data Definition Language Created: Sunday, March 05, 2006 Updated: Monday, February 17, 2014
      Looking for a definition of data definition language (DDL)? Find it here in the About Databases glossary.
    • Data Classification: A Simple Approach Created: Monday, February 03, 2014 Updated: Wednesday, February 05, 2014
      Many organizations avoid the challenge of data classification because they consider it a burdensome, difficult effort. In fact, it’s likely that organizations without actively used data classification policies have tried implementing such a policy in the past and failed, never to try again. In this article, I offer you some practical advice for getting a data classification effort off the ground and applying it to your sensitive information.
    • How To Install Microsoft Access 2007 Created: Sunday, January 08, 2006 Updated: Monday, February 03, 2014
      Due to its widespread availability and flexible functionality, Microsoft Access is arguably the most popular database software in use today. In this "How To", we explain the Access installation process in a straightforward manner.
    • How To Install Microsoft Access 2010 Created: Friday, July 23, 2010 Updated: Monday, February 03, 2014
      Due to its widespread availability and flexible functionality, Microsoft Access is arguably the most popular database software in use today. In this "How To", we explain the Access installation process in a straightforward manner.
    • How To Install Microsoft Access 2013 Created: Monday, February 03, 2014 Updated: Monday, February 03, 2014
      Due to its widespread availability and flexible functionality, Microsoft Access is arguably the most popular database software in use today. In this "How To", we explain the Access installation process in a straightforward manner.
    • How To Compact and Repair an Access 2013 Database Created: Monday, January 06, 2014 Updated: Monday, January 06, 2014
      Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.
    • Input Masks in Microsoft Access 2013 Created: Sunday, July 21, 2013 Updated: Monday, January 06, 2014
      Do your databases contain fields where users have entered a mess of information in a variety of different formats? Microsoft Access input masks may help you alleiviate this inconsistency in your desktop databases. Input masks allow you to specify the format of allowable user input, preventing users from entering information in a form that does not meet your data quality requirements.
    • How To Print Mailing Labels in Microsoft Access 2010 Created: Sunday, January 09, 2011 Updated: Saturday, January 04, 2014
      One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access 2010 using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
    • How To Print Mailing Labels in Microsoft Access 2000 Created: Sunday, August 20, 2006 Updated: Saturday, January 04, 2014
      One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
    • How To Print Mailing Labels in Microsoft Access 2013 Created: Saturday, January 04, 2014 Updated: Saturday, January 04, 2014
      One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access 2013 using the built-in Label Wizard.
    • Database Relationships in Access 2013 Created: Saturday, December 07, 2013 Updated: Saturday, December 07, 2013
      So you've made the move from a spreadsheet to a database. You've set up your tables and painstakingly transferred all of your precious data. You take a well-deserved break, sit back and look at the tables you've created. Wait a second -- they look strangely familiar to the spreadsheets you've just disowned. Did you just reinvent the wheel? What's the difference between a spreadsheet and a database anyway?
    • Data Scientists: The Hot Ticket in the Business World Created: Sunday, December 01, 2013 Updated: Sunday, December 01, 2013
      Finding data scientists is not easy. Demand for data scientists has grown alongside the popularity of big data and the technologies that allow companies to scale more easily – out, instead of up – and with less effort.
    • Choosing a Database for Your Organization Created: Friday, March 16, 2007 Updated: Monday, November 25, 2013
      Database management systems (or DBMSs) can be divided into two categories -- desktop databases and server databases. Generally speaking, desktop databases are oriented toward single-user applications and reside on standard personal computers (hence the term desktop). Server databases contain mechanisms to ensure the reliability and consistency of data and are geared toward multi-user applications.

    ©2014 About.com. All rights reserved.