Computing

Articles Index

Installing MySQL on Windows 8

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 to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Creating Forms in Microsoft Access 2007

Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.

Creating Forms in Microsoft Access

Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Creating Forms in Microsoft Access 2010

Creating Forms in Microsoft Access 2013

Backing up an 2010 Access Database

Protecting the integrity of information stored in a database is one of the most important responsibilities of a database administrator. One task associated with this responsibility is performing regular database backups. In this tutorial, we'll walk through the process of backing up your Access 2010 database using the software's built-in backup functionality.

Backing up an Access 2003 Database

I've often been asked "How do I create a backup of my Access database?" Until now, that's been a difficult question to answer. Prior to Access 2003, you would have to manually copy your Access .MDB files into a secure storage location. That's all changed with Access 2003. In this tutorial, we'll walk through the process of backing up your Access database using the new built-in backup functionality.

Backing up an 2013 Access Database

Converting an Excel Spreadsheet to an Access 2010 Database

Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!

Converting an Excel Spreadsheet to an Access 2007 Database

Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!

Converting an Excel Spreadsheet to an Access 2013 Database

Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!

Access 2013 Tour: The User Interface

If you're switching to Microsoft Access 2010 from an earlier version, you're bound to immediately notice some changes. If you've been using Access 2007, the ribbon-based user interface will look similar, but it's received a facelift. If you're switching from an earlier version, you'll discover that the way you work with Access is now entirely different!

Installing MySQL on Windows 7

Installing MySQL on Mac OS X 10.8 Mountain Lion

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 operating system (Mac OS X 10.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process.

Installing SQL Server 2012 Express Edition

Microsoft SQL Server 2008 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 environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.

Installing SQL Server 2008 R2 Express Edition

Creating a Pivot Table in Google Docs

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 functions Instead, they provide a graphical interface that allows users to create customized reports within a spreadsheet by simply dragging and dropping data elements to the desired columns or rows. In this tutorial, we examine the process of creating a pivot table in Google Spreadsheets.

Creating a Pivot Table in Excel 2010

Splitting an Access 2010 Database into Front-End and Back-End Components

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 your data, you may not wish them to modify the interface you use to work with the data yourself. Fortunately, Microsoft Access provides the ability to split a database into front-end and back-end components. You can safely share data with other users while keeping your interface private.

Using Expression Builder in Microsoft Access 2007

Have trouble remembering function names or arguments in Microsoft Access? We all do! Access' Expression Builder is a great tool that walks you through the process of creating expressions for your forms, tables, reports and queries while keeping a handy reference at your fingertips.

Using Expression Builder in Microsoft Access 2010

Password Protect an Access 2007 Database

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 a password, step by step.

Create a Microsoft Access 2010 Database Using a Template

Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access database using these templates.

Creating an Access 2010 Database from Scratch

In an earlier article, we reviewed the process for creating an Access database from a template. While this is certainly an agreeable, easy approach to building a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.