1. Technology

Tutorials

Looking to learn about Microsoft Access? This collection of tutorials includes materials for novices and advanced users alike.
  1. Building an Access Database (9)

Building an Access Database in Office 365
Looking for an easy way to move your Microsoft Access database to the cloud? Microsofts Office 365 service provides a central location where you can store and manipulate your Microsoft Access databases. This service has multiple benefits including leveraging Microsofts highly available environment to protect your data and enabling multiuser...

Creating Reports with Microsoft Access 2013
Microsoft Access 2013 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 2013.

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.

Exporting Data from Microsoft Access 2007 to Microsoft Excel
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 capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

View and Edit SQL in Microsoft Access
Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of accessing the underlying SQL code and tweaking it to perfect Access queries.

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.

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.

Collecting Information for an Access Database by E-mail
Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard designed to facilitate this task. In this tutorial, we walk through the process of populating an Access table with user-provided information.

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.

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.

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.

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.

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.

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.

Creating Forms in Microsoft Access 2007
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isnt always an appropriate tool for every data entry situation. If youre working with users you dont 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,...

Creating Relationships in Microsoft Access 2007
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.

Password Protect an Access 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.

Creating an Access 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.

Create a Microsoft Access 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.

Using 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.

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.

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 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!

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!

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.

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.

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.

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.

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...

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 split a database into front-end and back-end components. You can safely share data with other users while keeping your interface private.

Create an Adobe PDF File From an Access 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.

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...

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...

Microsoft Access User-Level Security Tutorial
If you’re a Microsoft Office power user, you might be familiar with the encryption features of Word, PowerPoint and Excel. These programs all allow file owners to easily apply encryption. Unfortunately, Microsoft Access doesn’t offer similar functionality, but it still has relatively powerful security functionality. In this article, we’ll take a look at Microsoft Access user-level security, a feature that lets you specify the level of access to grant each individual user of your database.

How To Install Microsoft Access
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.

Designing Data Access Pages
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process.

Creating Dynamic Web Pages with Microsoft Access
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Publishing Access Data on the Web
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Sample Excel Document
Sample Excel Document

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.

Building an Access Database From the Ground Up
In this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up. Below you'll find the complete listing of tutorials in this series.

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.

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 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 Dynamic Web Pages with Microsoft Access
Do your web users need real-time access to the information contained within your database? Server-generated HTML might be just the solution you need.

Creating Relationships in Microsoft Access
Microsoft Access offers powerful relationship functionality. This step-by-step illustrated tutorial walks you through the relationship creation process.

Data Access Pages
Data Access Pages provide Microsoft Access 2000 users with a powerful tool for viewing and manipulating database information through the web.

Exporting Access Tables to Excel
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.

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!

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.

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.

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.

Publishing Access Data on the Web
Looking to share your Microsoft Access database with the world? Learn to publish reports to the web in this step-by-step tutorial.

How To Install Microsoft Access 2010
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 Install Microsoft Access 2010
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 Export Data from Microsoft Access 2010 to Microsoft Excel
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 capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

How To Show or Hide Tabs in Microsoft Access 2010
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 simulate the appearance of older versions of Access.

How To Create an Adobe PDF File From an Access 2010 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.

Create a Microsoft Access 2013 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.

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...

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 Relationships in Microsoft Access 2010
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship...

Creating an Access 2013 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.

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.

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.

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!

Input Masks in Microsoft Access
Do your databases contain fields where users have entered a mess of information in a variety of different formats? Microsoft Access input masks may help you alleiviate this inconsistency in your desktop databases. Input masks allow you to specify the format of allowable user input, preventing users from entering information in a form that does not meet your data quality requirements.

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.

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.

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 youre trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database. In this...

Database Relationships in Access 2013

Using Criteria in Microsoft Access Queries
Are you familiar with the use of criteria in queries? They can help you limit results in interesting ways!

Shortcut Keys in Microsoft Access
Microsoft Access shortcut keys make it faster to execute queries and enter data without the user having to remove their hands from the keyboard.

Copying, Renaming and Deleting Tables in Microsoft Access
Copying, renaming and deleting tables in Microsoft Access often causes confusion for database administrators. In this article, we clarify the differences between the three operations and explain how to perform each.

Filtering Data in Access 2013
Microsoft Access 2013 includes filters that pull specific information instead of users having to muddle through countless records.

Indexing Access 2013 Tables
Tables can be indexed, giving the user the power to execute sorts and finds in a manner that is faster and more efficient for fields that are frequently searched

Printing Query Results in Access 2013
ccess 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.

Saving Queries in Access 2013
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.

Queries Using Multiple Tables in Access 2013
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.

You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

©2014 About.com. All rights reserved.