HowTos Index
How To Compact and Repair an Access Database
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.
How To Create a Trace with SQL Server Profiler
Traces allow you to track the specific actions performed against a SQL Server databases. They provide valuable information for troubleshooting database issues and tuning database engine performance. In this tutorial, we walk through the process of creating a SQL Server Trace with SQL Server Profiler, step-by-step.
How To Use SQL Server Upgrade Advisor
Microsoft provides the SQL Server 2008 Upgrade Advisor to help you detect upgrade issues before they occur. This tool examines your SQL Server 2000 and SQL Server 2005 databases and checks for any potential conflicts.
How To Add a Date or Time Stamp to an Access Database Table
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 Access using the Now() function. In this tutorial, I explain the process step-by-step.
How To Include Attachments in an Access Database
Microsoft Access allows you to include attachments in database tables. You may store photos, graphics, documents and other files in your Access database using Microsoft's Object Linking and Embedding (OLE) technology. Database attachments are a new feature in Access 2007.
How To Create an Alert Using SQL Server Agent
SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center.
How To Install the Northwind Sample Database in Microsoft Access
The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it.
How To Show or Hide Tabs in Microsoft Access 2007
Access 2007 introduces 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 simulate the appearance of older versions of Access.
How To Create an Adobe PDF File From an Access 2007 Database
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.
How To Create an Adobe PDF File From an Access 2003 (or earlier) Database
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.
How To Back Up a Microsoft Access Database
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 Add an Item to the Quick Access Toolbar in Microsoft Access
The Quick Access Toolbar provides you with immediate access to commonly used functions in Microsoft Access 2007. In this tutorial, we explore the process of adding your own favorite icons to the Quick Access toolbar, step-by-step.
How To Convert a Database to Access 2007 Format
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 format database to the new ACCDB format.
How To Change the Default Database Format in Access 2007
Access 2007 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.
How To Install Microsoft Access 2007
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 Create a Report Snapshot in Microsoft Access
Report snapshots offer a portable format that can be used to view Access reports on systems that don't have Microsoft Access installed. It's available for most versions of Windows and allows you to share reports via e-mail, the web or automated processes.
How To Use Expression Builder in Microsoft Access
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.
How To Print Mailing Labels in Microsoft Access
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.