Tutorials
Building an Access Database in Office 365
Looking for an easy way to move your Microsoft Access database to the cloud? Microsoft’s Office 365 service provides a central location where you can store and manipulate your Microsoft Access databases. This service has multiple benefits including leveraging Microsoft’s highly available environment to protect your data and enabling multiuser...
Creating Reports with Microsoft Access 2010
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 listing of employee home telephone numbers for the use of management using the Northwind sample database and Access 2010.
Top 5 Microsoft Access Books for Beginners
So, you'd like to learn more about Microsoft Access 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 Prices" links for a competitive listing of prices at various web merchants.
Converting a Spreadsheet to a Database
Do you have an unwieldy Microsoft Excel spreadsheet that you'd like to convert to an Access database? This illustrated tutorial walks you through the process, step-by-step.
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 2010 using the Now() function. In this tutorial, I explain the process step-by-step.
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.
Creating a Report in Microsoft Access
Would you like to create professional-looking reports from your Microsoft Access database with the click of a mouse? Follow along as we walk through the simple process of designing a reusable report.
Creating a Simple Query in Microsoft Access
Microsoft Access offers a powerful query function that allows you to extract information from your database. In this tutorial your About.com Guide to Databases walks you through the creation of a simple query.
Creating a Simple Query in Access 2013
Have you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access 2013 offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.
Creating Relationships in Microsoft Access
Microsoft Access offers powerful relationship functionality. This step-by-step illustrated tutorial walks you through the relationship creation process.
Fundamentals of Microsoft Access
Not sure if your organization needs a database? Your About.com Guide to Databases provides an overview of database concepts as well as the fundamental components of Microsoft Access.
How to Convert an Access 2.0 Database to Access 97/2000
Wondering how to convert an Access 2.0 database to Access 97 or Access 2000? Follow these easy steps!
Modifying a Query in Microsoft Access
Learn how to apply advanced techniques to refine your database queries. Your About.com Guide to Databases provides an introduction to adding and removing fields, adding query criteria and sorting your results.
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,...
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.
Migrating to SQL Server with the Access Upsizing Wizard
Many database users begin their adventure in the world of databases by creating a Microsoft Access database that meets the basic requirements of their organizations. Often, this is a dramatic improvement from an unwieldy collection of spreadsheets, text files or other documents that the organization previously used to manage information. However, eventually the business may outgrow that Access database and need to make the move to a more advanced database product.
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.
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.
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.
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!
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!
Splitting an Access Database, Step by Step
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...
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.
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.
Backing up an Access 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...
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 a Form in Microsoft Access
Forms offer a quick and easy way to offer a graphical data environment to users of your database. Follow along as your About.com Guide to Databases creates a simple form in Microsoft Access.
Creating Forms in Microsoft Access 2010
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry...
Backing up an Access 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...
Backing up an Access 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...
Creating Forms in Microsoft Access 2013
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry...
Creating a Simple Query in Access 2010
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 that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.
How to Install the Northwind Sample Database
The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it.
Password Protecting an Access 2010 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.
Converting an Access Database to SQL Server
Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL Server might be the solution you’re trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database. In this...