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
    • Database Management System Created: Sunday, July 16, 2006 Updated: Tuesday, April 22, 2014
      A database management system (DBMS) is the software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.
    • Exporting Access Tables to Excel Created: Monday, March 31, 2003 Updated: Tuesday, April 22, 2014
      Microsoft Access allows you to export data to a variety of formats for sharing and analysis. In this tutorial, we walk through the process of exporting an Access table to an Excel workbook."
    • Oracle Definition Created: Saturday, December 20, 2003 Updated: Tuesday, April 22, 2014
      What is Oracle? Find out here! Databases.
    • Splitting an Access Database, Step by Step Created: Sunday, June 04, 2006 Updated: Tuesday, April 22, 2014
      Oftentimes, you wish to share data with users in your organization who may, in turn, wish to create their own forms and reports. While you may want them to have the ability to view and/or update yo...
    • Retreiving Data with the SELECT Statement Created: Sunday, October 02, 2005 Updated: Tuesday, April 22, 2014
      The SELECT command is the most commonly used command in SQL. It allows database users to retrieve the specific information they desire from an operational database." itempr expr="$zTP='t3'" --> ite...
    • Installing SQL Server 2012 Express Edition Created: Sunday, May 06, 2012 Updated: Tuesday, April 22, 2014
      Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing env...
    • Candidate Key Created: Sunday, August 03, 2003 Updated: Monday, April 21, 2014
      What is a Candidate Key? Find out here!
    • Choosing a Database for Your Organization Created: Friday, March 16, 2007 Updated: Monday, April 21, 2014
      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.
    • Password Protect an Access 2007 Database Created: Sunday, February 18, 2007 Updated: Sunday, April 20, 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.
    • Password Protecting an Access 2010 Database Created: Sunday, November 14, 2010 Updated: Sunday, April 20, 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 of encrypting your database and protecting with ...
    • SQL Server Replication Created: Sunday, April 13, 2003 Updated: Sunday, April 20, 2014
      Microsoft SQL Server provides a robust replication facility to distribute and update data in a decentralized fashion." itemprop="description">> Sunday, November 06, 2011 Updated: Sunday, April 20, 2014
      Have you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access 2010 offers a powerful query function with an easy-to-learn interface tha...
    • Boyce-Codd Normal Form (BCNF) Created: Sunday, August 03, 2003 Updated: Sunday, April 20, 2014
      What is Boyce-Codd Normal Form (BCNF)? Find out here!
    • Databases Glossary Created: Sunday, August 21, 2005 Updated: Sunday, April 20, 2014
      Glossary of database related terms, including definitions, explanations, examples, suggested reading, and other resources." itemprop="description"> itemprop="descripti...
    • Importing and Exporting SQL Server Data from the Command Line with bcp Created: Sunday, May 10, 2009 Updated: Thursday, April 17, 2014
      The bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line. In addition to being a great tool for command-l...
    • Normalizing Your Database: Second Normal Form (2NF) Created: Sunday, April 17, 2005 Updated: Thursday, April 17, 2014
      Second Normal Form allows you to enhance the normalization of your database. In this article, we explore the requirements of 2NF and the process of normalizing your database."
    • Database Normalization Basics Created: Saturday, November 27, 2004 Updated: Thursday, April 17, 2014
      Database normalization can save storage space and ensure the consistency of your data. Learn the basics in this introductory article." itemprop="description"="description" Saturday, February 17, 2007 Updated: Thursday, April 17, 2014
      In this article, we begin our look at the first of three major normal forms -- first normal form (otherwise known as 1NF)." itemprop="description">