1. Technology
Send to a Friend via Email
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Mike Chapple

Updated Articles and Resources

By Mike Chapple

    Updated Articles and Resources
    • Printing Query Results in Access 2013 Created: Saturday, July 05, 2014 Updated: Sunday, July 20, 2014
      Access offers users a way to print queries and their results. This provides users with a way to later review the results if they cannot remember which query was used.
    • Queries Using Multiple Tables in Access 2013 Created: Saturday, July 05, 2014 Updated: Saturday, July 05, 2014
      One of the primary benefits of using Microsoft Access is having the ability to pull data regardless of where it is saved within the database, especially if it is spread over half a dozen tables.
    • Saving Queries in Access 2013 Created: Saturday, July 05, 2014 Updated: Saturday, July 05, 2014
      After making tweaks and changes to a query, it can be difficult to remember exactly what changes pulled which results. This is one very good reason to get accustomed to saving queries with some frequency, even if they don’t provide exactly what the user is looking for at the time.
    • Installing the Northwind Sample Database in Microsoft Access 2010 Created: Sunday, November 06, 2011 Updated: Tuesday, July 01, 2014
      The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it in Microsoft Access 2010
    • Importing and Exporting Data with SQL Server 2012 Created: Sunday, September 23, 2012 Updated: Tuesday, July 01, 2014
      The SQL Server Import and Export Wizard is a component of SQL Server Integration Services (SSIS) that facilitates the transfer of information between your SQL Server databases and other data source...
    • Schema Created: Sunday, January 18, 2004 Updated: Monday, June 30, 2014
      What is a database schema? Find out here!
    • Flat File Created: Sunday, September 14, 2003 Updated: Monday, June 30, 2014
      What is a flat file? Find out here!
    • Domain Created: Sunday, August 10, 2003 Updated: Sunday, June 29, 2014
      What is the domain of a database? Find out here!
    • Free Call Tracking Database Template in Microsoft Access Created: Thursday, July 05, 2007 Updated: Friday, June 27, 2014
      Looking for a trouble ticket tracking solution for your help desk? Microsoft offers a free call tracking database template for Access 2007 allows you to keep
    • Atomicity Created: Sunday, July 27, 2003 Updated: Friday, June 27, 2014
      What is atomicity? Find out here!
    • Choosing a Business Analytics Solution Created: Sunday, March 02, 2014 Updated: Saturday, June 21, 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.
    • How To Export Data from Microsoft Access 2010 to Microsoft Excel Created: Friday, August 06, 2010 Updated: Saturday, June 21, 2014
      It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabil...
    • Creating an ADO Connection Created: Saturday, November 27, 2004 Updated: Saturday, June 21, 2014
      The first step in developing an ADO application is to create a connection to a data source. This tutorial walks you through the process." itemprop="description" Sunday, March 18, 2012 Updated: Saturday, June 21, 2014
      One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set. Microsoft SQL Server provides database administrators...
    • How To Convert a Database to Access 2007 Format Created: Sunday, February 04, 2007 Updated: Friday, June 20, 2014
      The ACCDB database format introduced in Access 2007 provides a number of enhanced features over the older MDB format. In this article, we'll walk you through the process of converting an MDB forma...
    • Top Microsoft Access 2007 Books for Beginners Created: Saturday, January 05, 2008 Updated: Friday, June 20, 2014
      So, you'd like to learn more about Microsoft Access 2007 and you don't know where to begin. I've selected five of my favorite introductory-level Access books for your perusal. Follow the "Compare P...
    • Access Queries Created: Sunday, March 21, 2004 Updated: Friday, June 20, 2014
      Part 9 of our Building an Access Database From the Ground Up series explores the use of queries to retrieve information from a database." itemprop="description" Sunday, January 07, 2007 Updated: Friday, June 20, 2014
      This free Access database of area codes provides database designers with a valuable tool to assist in mapping area codes to a state, province or region." itemprop="descript't3'" --> itemprop="descr...
    • How To Show or Hide Tabs in Microsoft Access 2010 Created: Sunday, August 22, 2010 Updated: Friday, June 20, 2014
      Access 2010 uses the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel of your database or more closely si...
    • Splitting an Access 2010 Database into Front-End and Back-End Components Created: Sunday, February 06, 2011 Updated: Friday, June 20, 2014
      You might 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 your dat...
    • Creating a Pivot Table in Excel 2013 Created: Wednesday, October 09, 2013 Updated: Friday, June 20, 2014
      Pivot tables provide a powerful data analysis tool embedded within your current spreadsheet software. They offer the ability to summarize data without the use of a relational database or aggregate ...
    • Metadata Created: Sunday, November 23, 2003 Updated: Thursday, June 19, 2014
      What is metadata? Find out here!
    • Publishing Access Data on the Web Created: Saturday, November 27, 2004 Updated: Wednesday, June 18, 2014
      Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.
    • First Normal Form (1NF) Created: Sunday, September 14, 2003 Updated: Wednesday, June 18, 2014
      What is First Normal Form? Find out here!
    • How To Add a Date or Time Stamp to an Access 2010 Database Table Created: Saturday, March 19, 2011 Updated: Wednesday, June 18, 2014
      There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s easy to do this in Microsoft Acces...
    • How To Create an Adobe PDF File From an Access 2010 Database Created: Monday, September 06, 2010 Updated: Wednesday, June 18, 2014
      Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database.
    • Clustering Created: Sunday, December 10, 2006 Updated: Tuesday, June 17, 2014
      What is clustering? Learn more about this data mining term here!
    • Installing MySQL on Windows 8 Created: Saturday, April 06, 2013 Updated: Monday, June 16, 2014
      The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible ...
    • Introduction to SQL Created: Sunday, September 04, 2005 Updated: Monday, June 16, 2014
      The Structured Query Language (SQL) is the language of databases. All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building b...
    • How To Back Up a Microsoft Access Database Created: Friday, July 20, 2007 Updated: Monday, June 16, 2014
      Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-ste.
    • How To Export Data from Microsoft Access 2007 to Microsoft Excel Created: Thursday, July 02, 2009 Updated: Sunday, June 15, 2014
      It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabil...
    • SQLCMD Step-by-Step Created: Sunday, October 26, 2008 Updated: Sunday, June 15, 2014
      Microsoft SQL Server provides users with a variety of rich graphical user interfaces to retrieve and manipulate data and configure SQL Server databases. However, sometimes it’s just easier to...

    ©2014 About.com. All rights reserved.