Skip to main content

Access Junkie - MVP Alumnus

Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
MSDN Articles
Contact Us
About Us
Member Login
Access 2007 Help Topics

This page lists new and revised Help topics about Microsoft Office Access 2007 on Office Online


This Help topic is a good starting point - Help and How-to for Microsoft Office Access 2007:


Release Date - Saturday, May 16, 2009


Export contacts to an Outlook address book:
Access and Outlook are both excellent programs for managing your personal and business contacts. As a result, you might find yourself wanting to export contact data from Access to Outlook.

Top tips for Access 2007:
No matter how long you've worked with Access, there are always a few more tips to learn. Read this article to learn more.

Customer case study: Moving from Excel to Access:
Is your data getting harder to manage in an Excel workbook? Hear the experiences of one organization as they moved their data into Access.

Watch this: Add attachments to records in a form:
Watch this video to learn how you can attach documents to records in your database.

Create charts and graphs in Access 2007 (Non-Microsoft site):
Read about how one Access expert likes to creates charts.

Watch this: Change the data type of a table field:
Watch this video on how to change the data type of a table field from the Datasheet view.
Release Date - Thursday, March 19, 2009

Use a query as the record source for a form or report:
Learn about what you need to consider before using a query as a record source.

Create and use a switchboard:
Learn how to create and manage a switchboard in your Access database.

Watch this: Use the Projects database template:
Watch this video and start using the Projects database template to manage your projects.
Release Date - Monday, February 23, 2009

Control data entry formats with input masks:
Help make your database easier to manage by defining how users must enter data in specific fields.

Specify how data displays by using predefined formats:
Learn how to use predefined formatting options to enhance the way your data appears in a table or form.

Create or remove a primary key:
Want to know how and why to use primary keys? Read this article and find out.
Release Date - Tuesday, February 10, 2009

Crew interview: in the Dev Kitchen:
Watch this interview with Access Senior Program Manager Clint Covington to learn more about the Access developer kitchen.

Roadmap to creating a form:
Read this article to learn the ins and outs of creating a form in Access.

Specify how data displays by using custom formatting:
Learn how to make data in a field appear in a specific format by using custom formatting.
Release Date - Tuesday, January 27, 2009

Archive Access data:
Keep your data organized by periodically archiving old or inactive records.

Demo: Merge Access data with Word:
Learn how to use the Mail Merge Wizard to merge Access data with a Word document.

Create a macro that runs when you open a database:
Do you want to perform a set of actions every time your database starts? Save time and create a macro to do it automatically.
Release Date - Tuesday, January 13, 2009

Set the default form that appears when you open a database:
Save time. Learn how to have the same form open automatically every time that you open your database.

Watch this: Highlight values on a report by using conditional formatting:
Watch this demo and learn how to use conditional formatting to draw attention to particular values.
Release Date - Thursday, January 1, 2009
Create a form by using the Multiple Items tool:
Learn how to create a form that shows many records at once.

Set the tab order for controls:
On a form, you can control where the "focus" moves each time that you press the TAB key. Read this article to find out how.

Add a total or other aggregate to a report:
Access reports are great tools for summarizing data. This article shows you how easy it is to add totals, averages, and other aggregates to a report.
Release Date - Tuesday, December 16, 2008

Create a form by using the Blank Form tool:
Access provides several different tools for creating forms with the controls already in place. Use the Blank Form tool if you'd rather add the controls yourself.

Which view should I use: Layout view or Design view?:
Layout view and Design view provide different tools for creating forms and reports. Learn the differences by reading this article.
Release Date - Friday, November 21, 2008
Install updates for Microsoft Office 2007 Help:
Make sure you have the latest Help articles by downloading and installing updated Help files. Click this link to learn more.
Add a field to a table:
Fields are the basic units of storage in a database, and come in a variety of types, such as Date/Time, Text, or Number. Read this article to learn more about creating fields.
Prevent duplicate values in a field:
Find out how you can ensure that each value in a field is unique.
Release Date - Monday, November 3, 2008
Create a form by using the Form tool:
The Form tool gives you a quick way to create a form that displays a single record at a time. See how it's done by reading this article.
Move and resize controls independently:
Access 2007 uses layouts to align controls on forms and reports. However, sometimes you just want to move a control without affecting the others. This article shows you how.
Require a value in a field:
Sometimes, an empty field just won't do. Read this article to see how you can ensure that a value is entered for each record.
Release Date - Tuesday, October 21, 2008
Select data by using a query:
You can use queries to look at subsets of data, and to review and summarize data from multiple tables. Read this article to learn how to create a simple select query.
Make summary data easier to read by using a crosstab query:
Crosstab queries provide a powerful way to summarize data by multiple values, and are similar in many ways to PivotTables in Excel. This article shows you how to get started using crosstab queries.
Automatically align controls on a form:
Trying to figure out how to align controls on forms and reports? This article shows you how layouts can make the job easier.

Release Date - Monday, October 06, 2008
Validation rules:
Incorrectly-entered data can cause problems in any database. In this article, Access MVP Allen Browne shows you how validation rules help you keep the bad data out.

Add records to a table by using an append query:
If you have existing data that you want to add to a table, an append query can do it quickly and accurately.

Administer ODBC data sources:
Open Database Connectivity (ODBC) is a protocol that you can use to connect an Access database to an external data source such as Microsoft SQL Server. Learn how to manage ODBC data sources by reading this article.

Release Date - Tuesday, September 23, 2008
Relationships between tables:
Designing a useful database is all about creating the right relationships. Access MVP Allen Browne presents an example in this article.

Create a tabbed form:
Learn how to organize the controls on a form by using the Tab control.

Watch this: Create a tabbed form:
Looking for a video demo to help you add the Tab control to a form? Click this link.
Release Date - Tuesday, August 26, 2008
Create Access forms and reports from a SharePoint list:
You may already know that you can create Access forms and reports from a SharePoint list, but did you know that you can then make those forms and reports available on the SharePoint View menu?

Top tips for Access 2007:
No matter how long you've worked with Access, there are always a few more tips to learn. Read this article to learn more.

Customer case study: Moving from Excel to Access:
Is your data getting harder to manage in an Excel workbook? Hear the experiences of one organization as they moved their data into Access.
Release Date - Tuesday, August 26, 2008
Learn to think relationally:
Relational databases such as Access can help you store and retrieve data very efficiently, provided that you plan the tables correctly. Access MVP Allen Browne explains in this article.

Move Access data to a SQL Server database by using the Upsizing Wizard:
Storing your data in a SQL Server database can help improve the performance and scalability of your Access application. Read this article to learn how to use the SQL Server Upsizing Wizard.

Ways to share an Access database:
Want to make your database available for use by others in your workgroup? This new article shows you several techniques you can use.

Update data by using a query:
If you need to make the same change to many records in your database, an update query might be the best tool for the job.

Access SQL: Basic concepts, vocabulary, and syntax:
Knowledge of Structured Query Language (SQL) is not required to use Access, but knowing the basics can help you build a more powerful database.

Create custom menus and shortcut menus by using macros:
Create menus that contain only the commands you want. This new article shows you how.
Release Date - Monday, July 28, 2008
Create a form that contains a subform (a one to many form):
Looking for a good overview of adding subforms to forms? This article explains the basics, and provides a couple of video demos as well.

Customize how data is displayed by creating a lookup field:
Lookup fields let you quickly select a value from a predefined list. Read this article to learn how to create and modify these handy fields.

Add and customize date and time formats:
Storing and formatting dates and times are common tasks in any database. Get the details on how it's done.
Release Date - Monday, July 14, 2008
Why does Access want me to enter a parameter value?
Sometimes, changes to database objects can result in unwanted prompts that ask for a parameter value. Read this article to find out why they appear, and learn how to look for the cause of the problem.

Demo: Set the relationship between two tables:
Table relationships help you keep data organized across multiple tables. This new demo explains what they are and how to set them up.

Watch this: Create a subform by using the Subform Wizard:
Subforms let you display a record and its related records together on one form. The Subform Wizard walks you through the process, as shown in this short demo.
Release Date - Tuesday, July 01, 2008
Locate specific records in a database:
The larger your database, the harder it gets to find the data you need. Read this article to get tips on locating records quickly.

Set the field size:
Make sure your fields can accommodate the data that you want to store. This article gives you the details.

Document and print your database design:
Good database documentation helps you and others understand the structure of your database. Learn how to use the documentation features of Access by reading this article.
Release Date - Thursday, June 19, 2008
Demo: Add or remove controls from a layout:
Layouts help you quickly align and format data on forms and reports. Watch this short demo to see how to add or remove controls from layouts.

Demo: Create a form that contains a subdatasheet:
A subdatasheet lets you work with a lot of data in a compact space. See how to add one to a form.

Demo: Create a subform by dragging one form onto another form:
If you have two existing forms that show related data, you can drag one onto the other to create a subform. In this demo, you can see how it's done.
Release Date - Monday, June 02, 2008
Set name AutoCorrect options:
The name AutoCorrect feature helps keep your database operating correctly, even after you rename an object. Read this article to learn how to set the options for this feature.

Add a subdatasheet:
Learn how to create a subdatasheet by embedding one datasheet in another.

Watch this: Specify criteria for a text field:
Watch this new demo to see how you can limit the results of your query based on the value of a text field.
Release Date - Tuesday, May 20, 2008
Demo: Select the right form view:
Choosing the right form view can greatly impact the effectiveness of presenting your data. Watch this demo to get some tips.

Stop disabled mode from blocking a query:
See how you can enable database content that has been blocked by the security features of Access.

Decide whether to trust a database:
Learn more about the security features of Access, and how to determine if a database is trustworthy.
Release Date - Monday, May 05, 2008

Make your queries interactive by using parameters:
New video demos in this article help clarify how to add parameters to queries.

Refresh or requery data
If another person or process changes the data you're working with, you might want to refresh your view. Read this article to learn how.

Demo: Use the Expression Builder
The Expression Builder helps you create calculated fields and controls with a minimum of fuss. Watch this demo to see how it works.
Release Date - Monday, April 21, 2008
Hide VBA code from users:
Learn how to lock down an Access database to prevent users from making design changes.

Split a database:
Improve the flexibility and maintainability of your database by splitting it into a front-end/back-end configuration.

Watch this: Make a query ask for input:
Get more out of a query by entering new parameters each time you run it.
Release Date - Tuesday, April 08, 2008
Watch this: Make a control move as you resize a form:
Want that command button to always stick to the bottom right corner of a form? Watch this short demo to learn how.

Store the date and time when a record is modified:
Timestamps help you determine whether your data is up-to-date. This new article shows you how to add them.

Remove a subdatasheet:
Access creates subdatasheets by default in many cases, but you can remove them if you want.
Release Date - Monday, March 24, 2008
Demo: Bring your business data together in an Access database:
Access can help you integrate data from a variety of sources. See how it works by watching this demo.

Selecting and using the Access 2007 templates:
Access templates can help you build complete databases with just a few clicks. Learn how to select the one you want.

Run an Access macro by using a keyboard shortcut:
Make macros more accessible by assigning them to key combinations.
Release Date - Tuesday, March 11, 2008
Demo: Make a text box grow or shrink as you resize a form:
In Access 2007, controls can be configured to adjust their size as you resize the form. See how it's done.

Demo: Display a form and its datasheet simultaneously:
Split forms give you more flexibility in how you display your data. This demo shows you how they work.

Demo: Enable database content:
Some of the content in your database might be disabled by default. See how to enable it by watching this short demo.
Release Date - Tuesday, February 26, 2008
Help prevent and correct database file problems by using Compact and Repair
Keep your database in good shape by using the Compact and Repair command.

Restore a database
Rest assured! In the event of problems with your database, you can restore part or all of it if you have a backup copy.

Undo and redo typing
Learn how to use the improved Undo and Redo commands in Access 2007.
Release Date - Monday, February 11, 2008
Change the default folder for storing databases
You can specify which folder Access uses to store new databases. Read this article to learn how.

Help Access run faster
Learn tips that can help speed up database operations such as running reports or opening forms.

Link an Access 2007 database to a database that contains data access pages
Access 2007 doesn't support data access pages, but you can still link to databases that contain them.
Release Date - Tuesday, January 29, 2008
Modify a report:
Learn how to add such things as page numbers, line numbers, and logos to a report.

Demo: Collect data in Access 2007 by using e-mail
Take the pain out of data collection--let Access and Microsoft Outlook do the work for you!

Create a text box that looks up a value in a table
Display a value from a table or query other than the one that your form is bound to.
Release Date - Tuesday, January 15, 2008
Process SQL on a database server by using a pass-through query:

Combine text values by using an expression:
Release Date - Friday, December 14, 2007

Create a control that references a control on another form:
Release Date - Monday, December 03, 2007
Help secure an Access 2007 database:
Learn how to use the new security features in Access 2007.

Demo: Use control layouts on forms and reports:
See a video demo about how to format data on forms and reports.

Access Glossary:
Bookmark this glossary so that it's handy when you need it.
Release Date - Monday, November 19, 2007
What happened to data access pages?
Learn how to use Access 2007 to work with a database that contains data access pages.

Make a database easier to use by customizing and controlling the Navigation Pane.
Improve the usability of your database by customizing and controlling the Navigation Pane.

Show or hide the Navigation Pane
Keep the Navigation Pane visible when you need it.
Release Date - Saturday, November 3, 2007
Show trust by adding a digital signature:

View and manage objects by using the Navigation Pane:

Release Date - Tuesday, October 23, 2007
Exploring a desktop Access 2007 database
To navigate more precisely through the database management system, gain a better understanding of how the main components of Access are related.

What happened to user-level security?
Find out the best way to manage user-level security for the new, unsupported file formats.

Add a date or time stamp to new records
Learn how to add date and time information automatically when new files are added to your database.
Release Date - Monday, October 08, 2007
Interactive: Access 2003 to Access 2007 command reference guide.
Locate your favorite Access 2003 commands in Access 2007 by using this interactive reference guide.

Convert an Access 2007 database to an earlier file format
Read this if you are considering converting your database to an earlier version of Access.

Bypass startup options when you open a database
Learn to reset startup settings that might be denying you full access to a database.

Explore the Access Developer Portal
Getting comfortable working with macros, functions, and event procedures? Get more information about creating database solutions at the Access Developer Portal.

Release Date - Thursday, October 04, 2007
Track and view version information for SharePoint list items
If you're linking to data in a Microsoft Windows SharePoint Services 3.0 list, you can track versions of the items in the list. Find out how by reading this article.

Compare two tables and find only matching data
You can create a query that finds only the matching data in two tables. This article shows you two different ways of getting the job done.

Design great looking forms using Access 2007
Learn how to create professional and attractive Access forms in this excerpt from the new book, "Microsoft Office Access 2007 Plain & Simple."

Import an Access 2.0 database into an Access 2007 file
If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb).

Compare two tables and find records without matches
This article shows you how to use the Find Unmatched Query Wizard, how to modify the wizard output, and how to create your own query to find unmatched records.

Guide to designing reports
Learn the basics of designing reports in Microsoft Office Access 2007, and get tips for formatting different data types.

Distribute a report electronically
Save time and paper by distributing reports in an electronic format, such as PDF, Snapshot, or XPS.

Create or modify tables or indexes by using a data-definition query
Data-definition queries are a powerful tool for creating tables, indexes, constraints, and relationships. Read this article to learn more.

Move the tables in an Access database to a SharePoint site and link to them
Learn how to share and manage data from your Microsoft Office Access 2007 database through a Microsoft Windows SharePoint Services site.

Change the appearance of a control by using conditional formatting
Sometimes it can be difficult to find specific information on forms and reports. Learn how conditional formatting can make the important data stand out in your forms and reports.

Create and use subreports
Have you ever needed to display related information that is stored in separate tables or queries in one report? Using a subreport may be your solution.

Save the results of a select query
Learn how to save the results of a select query so that you can share a copy of that data.

Preview and print database objects
Learn about the preview and print options in Access 2007, and how to print all or selected records.

Add a custom title or icon to a database
Make it easier for users to identify your database by customizing it with a meaningful title or icon.

Insert page numbers into a form or report
Tired of trying to organize your reports or forms? Adding page numbers might be your solution.

Demo: Meet the Navigation Pane
Watch this demo for a quick look at the improved database management options in Access 2007.

Automate applications with macros in Access 2007
Use macros to automate responses to events without the pressure of learning a programming language.

Create an Access 2007 database using templates
Looking for some quick and creative options for creating a new database? See how templates can help.

6 ways to get ready for Access 2007
Read these tips from experts on Access 2007.

Export a database object to another Access database
Learn how exporting is much more than just another option to copy objects from one database to another.

Format the data in tables
Read this article to understand how to use enhanced formatting options to display information more effectively.

Introduction to the Access 2007 file format
This article provides an overview of the new features in the Access 2007 file format and addresses related file type changes. In addition, it covers file format issues that occur when converting to earlier file formats.

Make summary data easier to read by using a crosstab query
Learn how to use a crosstab query to restructure summary data in a format that is easier to read and understand.

Build forms in Access 2007 using design tools
Enhance your forms with the handy power of design tools.

Create a simple report by formatting a datasheet
Consider this solution when you need an instant and simple report.

Introduction to expressions
Get to know how and where expressions can be helpful.