Access Developer Center

Microsoft Office Access is a tracking and reporting program that enables you to create sophisticated database solutions, extend data to the Web, and integrate Access functionality with other Office products.

Getting Started with Access Development

1. About Access

Product Overview

2. Get Access

3. Learn Access Development

VBA Highlights

Building SQL Statements that Include Variables and Controls in Access 2007
Learn how how to build a SQL statement by using VBA.

Constructing Modern Time Elapsed Strings in Access 2007
Use Access 2007 to display the time elapsed between the current date and another date.

Making a Searching List Box in Access 2007
Learn to use a text box and a list box together to create a search list box.

Using Excel Date Functions in Access 2007
Leverage Excel 2007 functions directly from your application using VBA and Automation.

Using Variables in VBA to Filter Access 2007 Queries
Use a fixed expression, a built-in VBA function, or a VBA variable to filter queries.

Chapter 21: VBA Primer

MVP Stephanie Krieger talks about when and why to use VBA, provides an introduction to the VBA language and code structure, and shows how to write, edit, and share simple macros.

Using VBA to Control Built-In Commands in the 2007 Office System

This article is a big picture introduction of common ways to control built-in commands in the 2007 Microsoft Office system using Microsoft Visual Basic for Applications (VBA).

Looking for Access Developer Content?

Access Support

More: Creating Managed Add-ins for Access 2007 | Ramp Up | Help for Access 2007 | Office Development RSS rss icon

Access Team Blog

How do you track customer relationships?
This is guest post from Allie Rutherford a summer college intern on the Access team. Do you own you... Mehr

Free report wizard offer from Gladstone
Mike Hnatt has generously extended to the Access blog readers a FREE version of Gladstone’s Access R... Mehr

Group numbers into custom ranges
I was looking at SQM data about file size last week and ran into an interesting question. We capture... Mehr

Newsgroups and Forums

Access MVPs

Stefan Hoffmann
has worked as a software developer for an independent software vendor since 1997. Most of his projects use databases (RDBMS) such as Access, Oracle and SQL Server.

Community Submitted Content

How Do I: Create User Prompts in Access 2007
Learn to display a custom dialog box that prompts users to confirm changes before saving a record.

Transitioning Your Existing Access Applications to Access 2007

Read about some of the issues to consider when converting your databases to the new ACCDB format.

Find out how you can submit an article, video, or code sample.

Access News

Chapter 8: Using Code to Add Advanced Functionality to Forms, Part 1 (Expert Access 2007 Programming)
This section discusses some of the different events you can use at the form level in Access 2007.

Chapter 11: Creating Dynamic Ribbon Customizations, Part 1 (Expert Access 2007 Programming)
Learn to create ribbon customizations for use in Access applications.

Creating Combo Boxes in Access 2007 that Allows Users to Select N/A
Use a simple Union query and an unbound combo box where users can only enter a provided value.

Highlighting the Current Field in Data Entry Forms in Access 2007
Use indentation and color in the current control on a form to highlight the current control.

Creating Page-Range Indicators on Pages in Access 2007
Add some hidden text and a little bit of VBA code to display the first and last items on the page.